Go to the C:\Windows\SysWOW64 folder and run odbcad32.exe there to create Oracle's native 32-bit ODBC driver for your app and test the connection.Add, so that the Oracle ODBC 32 bit driver recognizes your tnsnames.ora file, the environment variable TNS_ADMIN with the value C:\instaclient_11_2 and copy in that folder the original tnsnames.ora from your Oracle home network\admin folder.Īt this point, you have the 32 bit ODBC driver available and with Oracle tnsnames.ora configured.In fact, in order to leave system as untouched as possible, don't do it. Instructions says to Add the folder C:\instaclient_11_2 to the system PATH, but it is not necessary just for ODBC to work.After it, you have Oracle ODBC 32 bit available in the system. The instaclient ODBC must be also unzipped in that folder and then, you need to execute odbc_install.exe.It is installed simply by unzipping in a folder, for example, C:\instaclient_11_2.Download from the 32-bit instaclient and the 32-bit ODBC ( instantclient-basic-win32-11.1.0.7.0.zip and instantclient-odbc-win32-11.1.0.7.0.zip).We will need basic instaclient + ODBC instaclient The idea is to add instaclient 32 bit to the server manually, so nothing will interfere in the main system. Other apps that rely on 32-bit DLLs may not work because will not find it. NOTE: this solution is just for an specific case, the case when you need only ODBC 32-bit working on the 64-bit system.
0 kommentar(er)
