OraFAQ Forum: Networking and Gateways » Microsoft ODBC for Oracle connection won't work

Home » RDBMS Server » Networking and Gateways » Microsoft ODBC for Oracle connection won't work

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator