Hi all I am dealing with a strange one and am looking for ideas.
Setup:
- Windows 10 Enterprise, 64-bit
- MS Access 2013, 32-bit
- Oracle Instant Client 11, 32-bit
I am using the above setup to connect to a remote Oracle 11g database in Access. Due to certain limitations I have the need to use the Microsoft ODBC for Oracle driver, but whenever I try to connect I would get the error message below:
ODBC--call failed.
[Microsoft][ODBC driver for Oracle][Oracle]Error while trying to retrieve test for error ORA-01019 (#1019) [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed IM006 0 [Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr failed (#0)
Here's the kicker. If after I open the Access file I first try to connect using the Oracle instantclient_11_2 driver, everything connects properly. Once I do that, if I try to connect using the Microsoft ODBC for Oracle driver again, everything works as well. It is as though connecting with the Oracle instantclient_11_2 driver first sets something straight. As soon as I close the Access file and reload, I'd have to repeat the same procedure for the Microsoft ODBC for Oracle driver to work.
Any idea on what the magic is with connecting using Oracle instantclient_11_2 first that makes Microsoft ODBC for Oracle work is appreciated. It is a workaround for now but it's quite a nuisance.