 Microsoft ODBC for Oracle connection won't work [message #131617] |
Mon, 08 August 2005 11:29  |
oconsi
Messages: 1
Registered: August 2005
|
Junior Member |
|
|
Hi, This has been driving me nuts for about 2 days.
I am trying to connect to and Oracle database from
VB6 using the Microsoft ODBC for Oracle as it is
only driver to allow record sets to be returned
from an Oracle package.
My connection code looks like this.
Dim Cn As ADODB.Connection
Conn = "UID=UserID; PWD=pasword; driver={Microsoft ODBC for Oracle};SERVER=servername;"
Set Cn = New ADODB.Connection
With Cn
.ConnectionString = Conn
.CursorLocation = adUseClient
.Open
End With
I can connect via Oracle client drivers no problem
but all I get with the above is an 80004005 error
and no explanation. It's as though the server
does not exist when I use the Microsoft driver.
I'm using MDAC 2.81.
Does anyone have any suggestions? Any help would be greatly appreciated.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
