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:
32-bit ODBC 10.1.0.5:
from the same web site link:
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.