I have been trying to get Oracle 10g instant client running on my computer for hours.
The platform is Windows Server2003,it is running within a PC Client and the Oracle installation directory is "c:\oracle". After the basic installation it is suggested that:
1. A system variable called TNS_ADMIN be created and pointed at the directory where the tnsnames.ora is placed.
2. The latest files mfc71.dll and msvcrt.dll where located and pathed and for extra caution they were also placed in the bin directory.
3. The accompanying ODBC drivers have been installed and appears as an option in the ODBC administrator.
4. I have gone so far as to check the registries for any odd paths, classes, or ODBC variations that could be affecting things and, 'yes' even rebooted.
Now everything should work but... The following error continues to popup:
“The setup routines for the Oracle in instantclient10_2 ODBC Driver could not be loaded due to system error code 126″
“Could not load the setup or translator library”
Same issue from the start to finish...