I am trying to connect an 32bit Access database to an Oracle database to extract data on client that has been upgraded to Windows 10. I have the 11g instant client installed. I am receiving the error message:
[Microsoft][ODBC driver for Oracle][Oracle]Error while trying to retrieve text for error ORA-01019 (#1019) [Microsoft][ODBC Driver Manager] Driver's SQLConnectAttr failed IM006
0 [Microsoft][ODBC Driver Manager][ Driver's SQLSetConnectAttr failed (#0)
What is the solution to this error message?
This maight be because you have more than one Oracle home defined, or none at all.
Make sure your 32bit Oracle client appears first in your PATH variable and try that.