If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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.