Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

jtomasicNov 1 2018 — edited Nov 5 2018

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

--

Comments

Post Details

Added on Nov 1 2018
#odbc, #windows-and-net
4 comments
33,203 views