Hi,

I work with VB6 and an Oracle-database. Until now I use OLE with the following code :

Set cn = New ADODB.Connection

With cn
.Provider = "OraOLEDB.Oracle.1" 'Oracle Provider for OLE DB
.CommandTimeout = 15
.Properties("Data Source") = "u8"
.Properties("User ID") = "test"
.Properties("Password") = "test"
.CursorLocation = adUseClient
End With

cn.Open

And now I want to try, how the connection via ODBC works, but I don't know, how I can call the Oracle-ODBC-Provider.

Please help me,

Sascha