This discussion is archived
1 2 Previous Next 23 Replies Latest reply: Jul 18, 2013 3:09 PM by user7346336 Go to original post RSS
  • 15. Re: Oracle 8 client in Windows 7 64-bit
    980333 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Anything orafad?
  • 22. Re: Oracle 8 client in Windows 7 64-bit
    1006960 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated

    hey there 980333 did you ever get this working?

1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points