0 Replies Latest reply on Nov 16, 2018 8:57 PM by jtomasic

    Can multiple Oracle Instantclients/ODBC be installed for different tools to access Oracle dB on a PC?

    jtomasic

      Greetings,

      I successfully installed 64-bit Oracle instantclient 10.2 and “Toad for Oracle” (similar to Oracle developer) on my Windows 7 and all functioning as expected. Now, I have been trying to install 32-bit Oracle instantclient 10.1 and ODBC to be used in 32-bit MS Access 2016 thru ODBC connection to Oracle dB by by following the following link:

       

      http://www.oracle.com/technetwork/topics/winsoft-085727.html 

       

      So far, I also completed the following in trying to make 32-bit Oracle instantclient 10.1 and ODBC to work:

       

      • Added the following folder where all downloaded/unzipped/installed files are saved:

       

      C:\Oracle\instantclient_10\instantclient10_1

       

      • Verified the dB server name defined in the tnsnames.ora file which is assigned to the TNS_ADMIN System variable name is accurate.

       

      • Configured the Oracle 10.1 driver in the following ODBC Data Source Administrator:

       

      C:\Windows\SysWOW64\odbcad32.exe

       

      But, I kept receiving the following error message while trying to connect to Oracle instantclient 10.1 thru ODBC in MS Access 2016:

       

      ORA-12154: TNS:could not resolve the connect identifier specified [#12154) [Microsoft][ODBC Driver Manager] SQLSetConnectAttr failed IM006 0 [Microsoft][ODBC Driver Manager]Driver’s SQLSetConnectAttr failed (#0)

       

      After spending a lot of time in trying to resolve the above error, my question is:

       

      Can multiple Oracle Instantclients(e.g. 32-bit, 64-bit and/or different Oracle versions), along w/ Oracle/ODBC drivers if required for connecting to Oracle database, be installed on a PC?

       

      If the answer is “no”, perhaps use a separate PC for different Oracle Instantclients version is the solution. 

       

      If the answer is “yes”, please share your knowledge and experience of multiple ORACLE instantclient and ODBC installations w/ me. 

       

      Any/all the help would be greatly appreciated!

       

      Thanks millions in advance.