Hello
Has anybody had similar problem.
Successfully installed Oracle 64 bit instant client ( basic package, sqlplus package and ODBC package ) version 11.2.0.4 downloaded from technet on Win 8.1.64 bit.
It works well on my notebook installation. So during running odbc administrator and defining new odbc connection from third party analytical tool to the Oracle database , it works fine.
But when repeating installation on end user's PC station ( tried on two of them ) get following error:
The setup routines for the Oracle in instantclient_11_2 ODBC driver could not be loaded due to system error code 14001. The application has failed to start because its side-by-side configuration is incorrect. Please se the application event log for use the command-line sxstrace.exe tool for more details.
C:\Oracle\instantclient_11_2\SQORAS32.DLL.
Is anybody familiar what did I do wrong or where to look for corrections ?
Attention it works well on my notebook but can not repeat successful end on other production stations with same procedure.
Trying to prepare instructions for Win administration guys.
What are the steps I performed ( as I said it worked fine on my Notebook using normal user account without Administrator rights and
switching to Administrator credentials only during some steps with Run As Administrator option of performing command.
S1. With normal non-admin user account on Win64 8.1 station copied 3 packages of 64 bit instant client 11.0.2.4 from
technet distribution source ( the highest release before 12c ) on the newly made directory C:\Oracle\instantclient_11_2.
Unzipped packages are: basic, sqlplus, ODBC. Made also directory C:\Oracle\instantclient_11_2\network\admin and
put tnsnames.ora and sqlnet.ora files there.
S2. Removing all older and other distributions of Oracle client as Administrator
S2.1 stopping the services which found with Ora prefix in services
S2.2 restarting the station and removing the components from registry
S2.3 deleting C:\app\User...directory
S3.3 unset Environment variables for ORACLE_HOME, TNS_ADMIN and removing ORACLE_HOME/bin from PATH variable
S3. With Run as Administrrator ran Control Panel option for setting new environment variables:
ORACLE_HOME = /Oracle/instantclient_11_2 , TNS_ADMIN = /Oracle/instantclient_11_2/network/admin
Include /Oracle/instantclient_11_2 in the PATH variable.
S4. With Run As Administrator ran MSDOS command prompt..and ran following commands :
cd C:\Oracle\instantclient_11_2
tested connection sqlplus user/pwd@db...
Works.
S5. ran the command odbc_install.exe
successfully added ( on ms dos prompt received succesfull message ).
S6. Went into ODBC administrator ( Control Panel-> System Security -> Administration tool -> ODBC administrator 64 bit )
When trying to define ODBC source and selecting the Oracle instant client from the list ( so it is successfully appearing )
and confirming the configuration get the error :
The setup routines for the Oracle in instantclient_11_2 ODBC....
the command-line sxstrace.exe tool for more details.
C:\Oracle\instantclient_11_2\SQORAS32.DLL....