emergency help - vb6, msdora & oracle 9.02


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: emergency help - vb6, msdora & oracle 9.02

  1. #1
    zac Guest

    emergency help - vb6, msdora & oracle 9.02


    program development/test environment
    vb 6.0
    os: XP
    database: Oracle
    mdac installed 2.7
    connection type: ole db

    i was originally connecting to a 9.01 oracle database using msdora. Everything
    was going perfect. in fact, that release is in production and is being used
    on 35 machines.

    then the client upgraded to Oracle 9.02.

    due to space limitations on my development machine. I removed 9.01 from
    it installed 9.02 (db install was succesful, import of database into 9.02
    was successful).

    PROBLEM: when i try to connect my app it is unable to connect to the 9.02
    database using msdora. it does not open the connect string.

    QUESTION: is there a more current msdora available.
    QUESTON: has anyone experienced this problem.

    note: i just download mdac 2.7 service pack 1 and i am still unable to connect.

    connection string:

    dim cnn1 as adodb.connection
    strcnn1 = "provider=msdora;data source=mblzdev;user=mbluser;password=mbl;"
    set cnn1 = new adodb.connection
    cnn1.open strcnn1

  2. #2
    Paul Clement Guest

    Re: emergency help - vb6, msdora & oracle 9.02

    On 9 Jan 2003 14:28:20 -0800, "zac" <zweeler@aol.com> wrote:


    program development/test environment
    vb 6.0
    os: XP
    database: Oracle
    mdac installed 2.7
    connection type: ole db

    i was originally connecting to a 9.01 oracle database using msdora. Everything
    was going perfect. in fact, that release is in production and is being used
    on 35 machines.

    then the client upgraded to Oracle 9.02.

    due to space limitations on my development machine. I removed 9.01 from
    it installed 9.02 (db install was succesful, import of database into 9.02
    was successful).

    PROBLEM: when i try to connect my app it is unable to connect to the 9.02
    database using msdora. it does not open the connect string.

    QUESTION: is there a more current msdora available.
    QUESTON: has anyone experienced this problem.

    note: i just download mdac 2.7 service pack 1 and i am still unable to connect.

    connection string:

    dim cnn1 as adodb.connection
    strcnn1 = "provider=msdora;data source=mblzdev;user=mbluser;password=mbl;"
    set cnn1 = new adodb.connection
    cnn1.open strcnn1

    I don't know whether Oracle 9.01/02 still uses the TNSNAMES.ORA config file but I would check that
    to make certain that you have an entry for your database server.


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

  3. #3
    zac Guest

    Re: emergency help - vb6, msdora & oracle 9.02


    thanks Paul

    i had to go into the registrry and delete the existence of the previous oracle
    and reset the default home.



    Paul Clement <UseAdddressAtEndofMessage@swspectrum.com> wrote:
    >On 9 Jan 2003 14:28:20 -0800, "zac" <zweeler@aol.com> wrote:
    >
    >
    > program development/test environment
    > vb 6.0
    > os: XP
    > database: Oracle
    > mdac installed 2.7
    > connection type: ole db
    >
    > i was originally connecting to a 9.01 oracle database using msdora. Everything
    > was going perfect. in fact, that release is in production and is being

    used
    > on 35 machines.
    >
    > then the client upgraded to Oracle 9.02.
    >
    > due to space limitations on my development machine. I removed 9.01 from
    > it installed 9.02 (db install was succesful, import of database into 9.02
    > was successful).
    >
    > PROBLEM: when i try to connect my app it is unable to connect to the

    9.02
    > database using msdora. it does not open the connect string.
    >
    > QUESTION: is there a more current msdora available.
    > QUESTON: has anyone experienced this problem.
    >
    > note: i just download mdac 2.7 service pack 1 and i am still unable to

    connect.
    >
    > connection string:
    >
    > dim cnn1 as adodb.connection
    > strcnn1 = "provider=msdora;data source=mblzdev;user=mbluser;password=mbl;"
    > set cnn1 = new adodb.connection
    > cnn1.open strcnn1
    >
    >I don't know whether Oracle 9.01/02 still uses the TNSNAMES.ORA config file

    but I would
    >check that
    >to make certain that you have an entry for your database server.
    >
    >
    >Paul ~~~ pclement@ameritech.net
    >Microsoft MVP (Visual Basic)



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center