I'm having problems installing the Oracle ODBC drivers for Windows 7.
I have downloaded the 32-bit drivers and unpacked the following to the same location:
1. instant-basic-nt-184.108.40.206.0.zip (unpacked first)
2. instant-odbc-nt=220.127.116.11.0.zip (unpacked second)
Clicked on the odbc_install.exe, it runs and no errors are shown. Checking the ODBC Data Source administrator, there are no drivers visible.
Thanks in advance.
MS Office - 32-bit
Windows 7 - 64-bit
I have issues with this also. I have windows 7 64-Bit. I can not find any file that state clearly that they are the 64-Bit ODBC drivers for Windows. The C:\windows\sysWOW64\<filename> does nothing. I can get the SQL connection no problem, but I need one that comes up with 'ORACLE RDB' when I go to add a new connection. Does anyone have any idea what I am talking about? Please let me know.
A couple of things to look at.
The 32 bit ODBC configuration is where Greg mentioned. The 64 bit one is in Control Panel >System & Security > Administrative Tools.
According to the download page for ODAC ( http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html ), the 64 bit xcopy download doesn't include the ODBC driver. So you'll want the other download that does in order to get 64 bit ODBC drivers installed.
This is it! Thanks for this information -- this tip saved my day!
Check out Marko Sutic's Oracle Blog on how to install Oracle Client 11g on Windows 7 and then run the Windows 32-bit programs to find the drivers and registry entries.
when i am adding system dsn for microsoft odbc for oracle it is showing the following error:
the oracle client and networking components were not found.these components are supplied by Oracle corporation and are part of oracle versiion 7.3 client software installation.
my system have windows 7 64 bit and oracle 10g
what should i do now?
awaiting eagerly fr reply
I just went through 2 days of "fun" trying to install ODBC drivers on a new Windows 7 install for use with Toad 9.
I succeeded after some hair loss so I'm sharing my lessons learned.
1. The downloaded Oracle installations unpacked with folders and some files marked as "READ ONLY". Uncheck this flag.
- A number of files including log.XML files were marked "READ ONLY" causing the install to fail when install logs were updated.
- This caused the vast majority of my problems and led to others.
2. Even after cleaning your system by uninstalling Oracle, double check it’s gone, it may not be.
3. Run as Administrator
For products like Toad 9, make sure you DO NOT install to the default folder on windows 7 "c:\Program Files (x86)". Toad gets picky about the spaces. Install to a special folder just for Toad and it will be very happy i.e."c:\toad"
I hope that helps someone.
Edited by: 960437 on Sep 20, 2012 2:18 PM
Although I'm no huge fan of Microsoft, I don't know why you would go there before Oracle. I've never seen more senselessly designed software than what I've seen coming from Oracle Corporation. Absolutely nothing from Oracle, NOTHING!, works without devoting hours, sometimes days to research, trial and error and a LOT of cursing. What garbage.