I am trying to use MS Access (in 64 bit Windows 7 OS) to get data from Oracle 12c Server (Oracle Linux Server) via ODBC. Initially, I installed the Oracle Client 12.2 (64 bit) on my computer. And I was able to create System DSN and the connection was tested successfully. However, I from 32 bit MS Access, I can't see the Oracle ODBC Drive (Oracle in OraClientHome1). Later I understand, since my MS Access is 32 bit, I can't really see the 64 bit driver or use the existing DSN using the 64 bit driver. My MS Access can only see the 32 bit ODBC driver. So, I used "Microsoft ODBC for Oracle", and it failed for "ODBC--call failed".
Later, I installed the Oracle 32 bit Client on another similar computer. This time, I was able to see the Oracle driver from my 32 bit MS Access, and created an ODBC DSN. Things got strange from here. If I type in the wrong password, I will get the incorrect login name and password error. If everything is correct, I get the "ORA-12154....... @12154 Driver's SQLSetConnectAttr failed......" error. However, from MS Excel 32 bit, I was able to connect to the same database server, and get data out.
Has anyone tried the similar thing and can give me some answer? Thanks in advance.
peace4future