Hello,
I have a Windows 10 64 bit machine that serves as a test environment (PC-2). On that machine I have Oracle XE 11g 64-bit installed.
On this same machine, I have ODBC applications on PC-2 that need to communicate with the Oracle Production server (PC-1).
I've installed the ODBC capability on many Windows machines that communicate directly with PC-1. The Standard Oracle Client 11g 32-bit is used for that, and the 32-bit ODBC connections work fine. I need 32-bit (not 64-bit) to communicate, in part, with Microsoft 32-bit applications.
My problem is that I need to communicate with the server from PC-2, where XE 64-bit is already installed. From what I read, Instant Client was a good choice to give me a 32-bit ODBC driver, but I can't seem to get the Instant Client to install.
My tnsnames.ora, listener.ora and sqlnet.ora files are in C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN
Here are a subset of my Windows 10 environment variables:
CLASSPATH = .\;C:\oraclexe\app\oracle\product\11.2.0\server\jdbc\lib\ojdbc5.jar;C:\apex\utilities
JAVA_HOME = C:\Program Files\Java\jdk1.7.0_60
ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server
PATH =
C:\oraclexe\app\oracle\product\11.2.0\server\bin;
C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN;
C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\instantclient_12_1;
(plus other non-oracle entries)
I extracted the file instantclient-odbc-nt-12.1.0.2.0.zip into the folder: C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\instantclient_12_1
I looked at some postings and reviewed the RegEdit Key settings for Instant Client. In HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient11g_home1 I have the following:
--NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
--ORACLE_GROUP_NAME = Oracle - OraClient11g_home1
--ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\instantclient_12_1
--ORACLE_HOME_NAME = OraClient11g_home1
When I run odbc_install.exe from a DOS Prompt I get the error: "Couldn't find Oracle Instant Client in present directory."
I tried copying the contents of the instantclient_12_1 folder into the parent ...network\ADMIN folder. I updated the ORACLE_HOME in RegEdit. Then I ran odbc_install.exe again. I get the same error.
What can I do to get a 32-bit ODBC driver that will appear in Microsoft's 32-bit data sources?
Many thanks for looking at this.