4 Replies Latest reply on Nov 5, 2018 9:53 PM by jtomasic

    How to make 32-bit Oracle client driver available to ODBC administrator tool?

    jtomasic

      Hello All,

       

      I have downloaded 64-bit Oracle Instantclient 10.2 to my Windows 7 PC, and aIl works well as expected.  But I now have to download 32-bit Oracle Instantclient 10.2 and ODBC driver to be used in MS Access 2016.  I followed the instructions step by step as described in the following link:

       

      https://itkbs.wordpress.com/2014/07/28/how-to-install-odbc-driver-for-oracle-in-windows-7/

       

      Per instructions, I downloaded the instantclient-basic-nt-11.2.0.3.0.zip and instantclient-odbc-nt-11.2.0.3.0.zip files, unzip them and then modified the Path system Variable value for the folder that contains the instantclient and odbc information.  Once all done, for some reason, the Oracle 32-bit driver cannot be verified in the ODBC Data Sources.  My question is:

       

      How to make 32-bit Oracle client driver available to ODBC administrator tool so that I can connect to the Oracle database thru ODBC in MS Access?

       

      I have already spent a lot of time on this and I am desperately asking for your help.

       

      Any/all the help on this would be greatly appreciated.

       

      Thank you in advance,

      Jinlan

      --