Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connect to Oracle Database from VB 1

Status
Not open for further replies.

Raparla

IS-IT--Management
Aug 7, 2000
9
US
I am trying to connect to Oracle database from VB using RDO and keep getting the following error message.

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

Can some one help me in connecting to the Oracle database.
I am using the following code.

Conn = "UID=uid;PWD=pwd;driver={Microsoft ODBC for Oracle};CONNECTSTRING=srvr;"
Set En = rdoEnvironments(0)
Set Cn = En.OpenConnection("", rdDriverPrompt, False, Conn)

Thank you.
 
Why RDO and not ADO, I don't think you'll be able to access all the Oracle features with RDO. Anyway here's a link for connection strings and examples.


Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'.
 
DrJavaJoe,

It doesn't mater. I can use either RDO or ADO and I tried the connection strings listed in the link.

Dimandja,
I can use Oracle ODBC driver. Can you provide the connection string for this.

Thank you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top