ODBC for Oracle

[dartoisky]

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

[dammansky]

amai wi, oj da nog nie wit!!!

[urs]

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

[Iouri]

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
iouri@hotsheet.com