Connect to Oracle Database from VB 1

[Raparla]

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.

 

[DrJavaJoe]

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.

http://www.able-consulting.com/ADO_Conn.htm

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'.

 

[Dimandja]

You are not using the Oracle ODBC driver?

 

[Raparla]

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.

 

[Dimandja]

From

http://support.microsoft.com/default.aspx?scid=kb;EN-US;193332:

con1.Open "PROVIDER=MSDASQL;" & _
"DSN=dseOracle;" & _
"UID=demo;PWD=demo;"

 

[Swi]

Here is another good connection string site. I like this site and the one DrJavaJoe suggested most.

http://www.connectionstrings.com/

Swi