ODBC for Oracle

Hello there,

I have to make a connection to an Oracle database to retrieve some information for my database in Access. But it doesn't work. Can someone help me with some example code ? I tried to establish the connection with 'Microsoft ODBC for Oracle', but that doesn't work.

thank you in advance,
dartoisky

amai wi, oj da nog nie wit!!!

add adodc on ur form
right click ,properties
and then select "Microsoft ODBC for Oracle"
provide user name and password

For the current Oracle ODBC Driver from Microsoft:

oConn.Open "Driver={Microsoft ODBC for Oracle};" & _
"Server=OracleServer.world;" & _
"Uid=demo;" & _
"Pwd=demo;"

For the older Oracle ODBC Driver from Microsoft:

oConn.Open "Driver={Microsoft ODBC Driver for Oracle};" & _
"ConnectString=OracleServer.world;" & _
"Uid=demo;" & _
"Pwd=demo;"



Iouri Boutchkine
[email protected]