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.
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.
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"
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.