This content has been marked as final. Show 23 replies
Well first of all, Oracle 8 is 15 years old, so im not surprised at all it doesnt work properly on a much newer OS.
%windir%/SYSWOW64/odbcad32.exe is for 32-bit drivers
%windir%/system32/odbcad32.exe is for 64-bit drivers and this is the one being executed when running from control panel
(logical, isnt it?...)
The registry keys containing information about these are:
in /ODBC/ODBCINST.INI/"ODBC Drivers" key, there is a list of the drivers, while ODBC/ODBCINST.INI/<driver_name> contains the details
based on this info, you can try to repair it in the registry manually as according to the error it doesnt have the correct path specified, however i would just install a newer, supported version
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Oracle in OraDb11g_home2] "APILevel"="1" "CPTimeout"="60" "ConnectFunctions"="YYY" "Driver"="C:\\oracle\\base\\product\\db11202\\BIN\\SQORA32.DLL" "DriverODBCVer"="03.51" "FileUsage"="0" "Setup"="C:\\oracle\\base\\product\\db11202\\BIN\\SQORAS32.DLL" "SQLLevel"="1"
977330 wrote:You can, but not with Oracle 8 unless you're going to do a lot of manual work (and maybe not even then). Newer 32 bit clients work prefectly well in Windows 7 x64. I'm using one right now. :)
Rich did you ever get this resolved, I'm having a similar issue and have went down the paths you have. I have no problem running Oracle drivers in XP mode but surly we can get the 32-bit ODBC's to run out of 64bit mode in W7.
No sadly it's 8i although pretty soon we're going to have to make a move. I'm having trouble with the basic 10.2.0.5 install. somethings goofy and I have to install the basic and then the odbc files from Oracle. As naturally 11 (full version) is the only version that Oracle has for download on their website.
Edited by: 977330 on Dec 18, 2012 1:22 PM
I think I'm close, I've got the 32 bit client for 10.0.2.05 installed with all the files in the right directory and I've added copied the .ora files into subfolders in network/admin
I've added W7 enviornment variables for ORACLE_HOME and TNS_NAMES. The former points to the instaclient10.2 folder and the latter the network/admin subfolder within the instaclient10.2 folder.
Now I'm getting the dreaded error code 126, basically saying it can't find the SQORAS32.DLL which is in the folder.
Do I have a path error either in the variables or in the registry?
I've gotta be close.
Yes, and I read the directions as well as the readme. As I'm fairly new to this I'm not obviously understanding it fully. Instead of updating a system variable called ORACLE_HOME or TNS_NAMES...I should just add a variable called PATH to the system variables and map it to the installed instaclient directory?
Ah, ok, sorry for the too short explanations.
PATH is "part" of the system (Windows).
Just open a command prompt window (cmd) and type 'set' + enter. There's a bunch of pre-defines.
Well, open the control panel for Environment variables, in the System variables section (lower half) you would find PATH (or Path, same thing).
c:\> path c:\> set path c:\> set p
Double click to edit, put your Instant client install (unzip) directory first, followed by a semi-colon (look at how other values/paths are separated). Click OK, OK, OK, ... to "save".
Then reboot the machine just to be on the safe side (having all processes to pick up the change).