1 2 Previous Next 23 Replies Latest reply: Jul 18, 2013 5:09 PM by user7346336 Go to original post RSS
      • 15. Re: Oracle 8 client in Windows 7 64-bit
        980333
        Appreciate the extra patience.

        I did as directed. You say I don't need ORACLE_HOME got it, but do I need TNS_NAMES added as a variable or am I good?

        I'm going out to update and restart now. I'll post my results here in a minute.

        Thanks
        • 16. Re: Oracle 8 client in Windows 7 64-bit
          orafad
          a+ wrote:
          do I need TNS_NAMES added as a variable or am I good?
          TNS_ADMIN, I assume. No it's not required.

          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.
          • 17. Re: Oracle 8 client in Windows 7 64-bit
            980333
            Okay I'm still getting the error saying it can't find the .dll file?

            Any ideas?
            • 18. Re: Oracle 8 client in Windows 7 64-bit
              980333
              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
              • 19. Re: Oracle 8 client in Windows 7 64-bit
                orafad
                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?
                • 20. Re: Oracle 8 client in Windows 7 64-bit
                  980333
                  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:*

                  c:\>set path
                  Path=C:\oracle\instantclient-basic-win32-10.2.0.5\instantclient_10_2;C:\Program
                  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\
                  PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

                  Previously had the Universal Installer 1.71.9.0 install Oracle8i Client 8.1.7.0.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.
                  • 21. Re: Oracle 8 client in Windows 7 64-bit
                    980333
                    Anything orafad?
                    • 22. Re: Oracle 8 client in Windows 7 64-bit
                      1006960
                      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**! ;)

                      Cheers,
                      Michael
                      • 23. Re: Oracle 8 client in Windows 7 64-bit
                        user7346336

                        hey there 980333 did you ever get this working?

                        1 2 Previous Next