Access via ADO to an Orale-database

[smuehlfeld]

Hi,

I want to write a visual basic programm, with which I can access via ADO to an oracle-database. But I have the problem, that I don't know exactly, which dll-File I have to include.

Please help me.

Thanks
Sascha

[Cakkie]

You must include msdaora.dll, wich contains the oracle drivers for ado

Tom Cannaerts
[email protected]

The best way to escape a problem, is to solve it.

[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
[email protected]