Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.3K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 394 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
How to make 32-bit Oracle client driver available to ODBC administrator tool?
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
--
Answers
-
Refer note: Test a 32-bit OLEDB Connection With a UDL File on 64-bit Windows (Doc ID 405743.1)
How To Install Both 32-bit and 64-bit ODP, OLEDB, And ODBC Oracle Software on 64-bit Windows (Doc ID 795602.1)
-
You have to open the 32bit version of ODBC administrator tool to view the list of 32bit ODBC driver installed on your 64bit OS. It is located in C:\Windows\SysWOW64\odbcad32.exe.
You can configure DNS for your ODBC driver using it and your 32 bit MS Access could access that DNS.
-
I am looking for a resolution on how to make 32-bit Oracle 'instantclient', NOT Client, driver available in the ODBC Administrator Tool so that I can configure it to access Oracle database in MS ACCESS 2016(which is 32-bit) thru ODBC. Thanks for your information though.
-
Thanks for your response. Yes, I found C:\Windows\SysWOW64\odbcad32.exe along w/ a list of folders and *.dll files in the same folder.
Do you mean to add a DSN, say ODBC_32, w/ variable value of 'C:\Windows\SysWOW64\' as one of the Environmental Variables in the system properties? If not, please explain or give me an example.
Since we are currently on Oracle 10.1.0.5, so I tried to uninstall Oracle instantclient-basic-nt-11.2 and instantclient-odbc-nt-11.2 by running odbc_uninstall.exe, but nothing happened. I then downloaded the following zip files to a new folder:
32-bit Oracle instantclient 10.1.0.5:
instantclient-basic-win32-10.1.0.5-20060419.zip
32-bit ODBC 10.1.0.5:
instantclient-odbc-win32-10.1.0.5-20060419.zip
from the same web site link:
https://www.oracle.com/technetwork/topics/winsoft-085727.html
At the completion of the installation(by following the same processes), the 32-bit Oracle driver is still not available in the ODBC Data Source Administrator. I current have the following Environmental Variables and corresponding values:
Variable Name Value
---------------- --------------------------
TNS_ADMIN C:\Oracle\Network\Admin (where tnsnames.ora is saved.)
MRS C:\Oracle_ODBC (for all downloaded Oracle/ODBC 10.1.0.5)
PATH ‘;C:\Oracle_ODBC’ appended to the end of existing PATH value
Please clarify what you meant and maybe provide further instructions. For some reason the 32-bit Oracle instantclient driver is not being seen by ODBC Data Source Administrator.
I think I am probably missing something very simple here in trying to resolve the issue of making 32-bit Oracle instantclient driver available to ODBC Data Source Administrator, but after spending so mush time on this, I am not sure anymore...
Any hint, help or further instructions on this would be greatly appreciated.
Thanks again.