This content has been marked as final. Show 23 replies
a+ wrote:TNS_ADMIN, I assume. No it's not required.
do I need TNS_NAMES added as a variable or am I good?
You could put the tnsnames.ora file in the instantclient folder i.e. same as where PATH points. If you want to use local naming that is. If you use Easy connect naming instead, you might do without tnsnames.ora.
I also checked my "Path" to make sure that the directory string was first as well as exactly case sensitive to the actual path. I checked the registry for the Oracle ODBC driver in the Wow6432Node and it to is exactly what it should be (pointing to the correct folder for the sqora32.dll and sqoras32.dll files. I entered the commands on the command line as you indicated.
There has to be something else I'm missing. Again Windows 7 64 bit and I'm using the 32-bit download from OTN. I've unzipped both the "Basic" and "ODBC" files in the same folder as a subfolder in my C:\oracle file location. I've then run the odbc_install.exe as an Administrator (fine no errors)...I've also added network\admin as subfolders to the instantclient_10_2 folder and placed SQLNET.ORA and TNSNAMES.ORA into the folder and pointed TNS_ADMIN in my system variables to it.
What on earth have I missed...I know it's going to be something that makes me feel stupid.
Edited by: a+ on Dec 20, 2012 2:20 PM
What is the full error message and how do you get (reproduce) the error exactly?
Please also post a copy-paste of output of 'set' command.
What is the name of the driver from the Drivers tab in ODBC admin? (under syswow64)
Does this machine have or did it have any other Oracle installations?
Does connecting with IC Sqlplus work?
Alright orafad lets see,
When trying to add a system DSN I get: "The setup routines for the Oracle in instantclient10_2 ODBC driver could not be loaded due to system error code 126: The specified module could not be found. (C:\oracle\instantclient-basic-win32-10.2.0.5\intantclient_10_2\sporas32.dll).
When trying to add a File DSN I get: "Error Cannot Load Resource File sqresus.dll"
I get either when trying to add the listed Driver from the 32-bit ODBC Data Source Administrator from Windows 7. The driver shown in the DSN menu shows up as "Oracle in instantclient 10_2"
*Set cmd output:*
Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common F
iles\Microsoft Shared\Windows Live;C:\Program Files (x86)\Intel\iCLS Client\;C:\
Program Files\Intel\iCLS Client\;c:\Program Files (x86)\AMD APP\bin\x86_64;c:\Pr
ogram Files (x86)\AMD APP\bin\x86;C:\Windows\system32;C:\Windows;C:\Windows\Syst
em32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;c:\Program Files (x86)\ATI
Technologies\ATI.ACE\Core-Static;C:\Program Files\Dell\Dell Data Protection\Acc
ess\Advanced\Wave\Gemalto\Access Client\v5\;C:\Program Files (x86)\NTRU Cryptosy
stems\NTRU TCG Software Stack\bin\;C:\Program Files\NTRU Cryptosystems\NTRU TCG
Software Stack\bin\;C:\Program Files\Intel\Intel(R) Management Engine Components
\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program
Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x
86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Windo
ws Live\Shared;C:\Program Files (x86)\QuickTime\QTSystem\
Previously had the Universal Installer 126.96.36.199 install Oracle8i Client 188.8.131.52.0...This archaic setup wouldn't run which is why I uninstalled it...Although I'm aware there may be some residual files that weren't uninstalled.
I don't know anything about IC Sqlplus.
I just had the same problem and figured it out with the tool "Dependency Walker" (http://www.dependencywalker.com). When you load the DLL "sqoras32.dll" into Dependency Walker then you'll see that the Windows DLLs "MFC71.DLL" and "msvcr71.dll" are required. These files are not by default installed on a Windows 7 x64 system. So just download the mentioned DLLs (e.g. from http://www.dll-files.com/) and put them into the Oracle Instant Client folder. Now everything should work fine!
So the error message has nothing to do with not finding "sqoras32.dll" - the registry entries linking to the file are correct. The real problem is the missing dependent DLLs. What a pain in the a**! ;)