Error in VB6 -> Oracle 9i, pls HELP!!!

[dumdumdum]

Hi all,

I encounter problem when using VB 6 with oracle 9i, can anyone give me some idea how to solove it? or any other good methods? Many thx...

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Set conn = New ADODB.Connection
conn.CursorLocation = adUseClient
conn.ConnectionString = "DRIVER={Microsoft ODBC for Oracle};" _
& "SERVER=xxx;" _
& "DATABASE=xxx;" _
& "UID=xxx;" _
& "PWD=xxx;" _
& "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 163841
conn.Open

Error : [Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr failed

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Set conn = New ADODB.Connection
conn.CursorLocation = adUseClient
conn.ConnectionString = "DRIVER={Oracle in OraHome92};" _
& "SERVER=xxx;" _
& "DATABASE=xxx;" _
& "UID=xxx;" _
& "PWD=xxx;" _
& "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 163841
conn.Open

Error : [Oracle][ODBC][Ora]ORA-12560: TNS: protocol adapter error

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

I wonder is there any problem about the "DRIVER" or Oracle setup problem?

Best Regard,
dumdum

 

[sem]

I suppose that one of you xxx may be incorrect Check SERVER and DATABASE values.

Regards, Dima

 

[MCubitt]

dum,

I have the same problem.

Connecting to a number of DBs using Microsoft ODBC for Oracle is fine, but with one it gives me the same error you go.

So I tried Oracle in OraHome92 and get the same error you describe.

Did you resolve the issue? My values are fine.

thanks


Applications Support
UK

 

[MCubitt]

I connect through SQL Plus and ODBC without problem.

Very strange...




Applications Support
UK

 

[sem]

I suspect you have more than one Oracle home, am I right?

Regards, Dima

http://seminihin.narod.ru