MSACCESS 2000 ODBC link to Oracle Failing (1 Viewer)

[Sonali]

Hi,

This is the first time I am posting through this site.
When I tried to link to Oracle 8/Oracle 8i database through MSACCESS 2000 I get the following error.

ODBC-call failed
[Microsoft][ODBC driver for Oracle][Oracle]ORA-03121: no interface driver connected - function not performed(#3121)[Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr failed(#0) [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed(#0)


PLEASE HELP!!!

Sonali

 

[Schof]

The following Oracle ODBC driver versions work just fine for me:

8.00.05.00
8.00.510.00
8.00.64.00
8.01.06.00
8.01.57.00
8.01.64.00

As does the following Microsoft ODBC for Oracle dirver:

2.573.4403.00


Here is a snippit of code that I use that may help?

Dim wrkODBC As Workspace
Dim conPubs As Connection

' Create ODBCDirect Workspace object.
Set wrkODBC = CreateWorkspace("NewODBCWorkspace", "admin", "", dbUseODBC)
Set conPubs = wrkODBC.OpenConnection("DBConnection", dbDriverPrompt, True, "ODBC;DSN=;UID=;PWD=")