I've spent two days trying to install oracle ODBC drivers on my WIN7, read lots and lots of pointless forums and about to lose all hope...
i tried installing oracle client. According to documentation this is the only thing you need to do "... and enjoy!" they say.
1 - downloaded instantclient-basic-windows.x64-220.127.116.11.0.zip
2 - extracted it to C:\instantclient_11_2
3 - downloaded instantclient-odbc-windows.x64-18.104.22.168.0.zip
4 - extracted it to C:\instantclient_11_2
5 - ran C:\instantclient_11_2>odbc_install.exe
6 - got: "Oracle ODBC Driver with same name already exists."
7 - At this point, no other oracle product, besides java, was running on my machine. Double checked.
No "enjoy" for me :(
Then i installed full ODAC.
1 - got ODTwithODAC1120320_32bit.zip (the full 230 Mb version, not the XCopy one)
Now, at this point, microsoft is to blame. It turns out that control panel's odbc manager only shows you the 64bit drivers installed, as odac has its odbc drivers in 32 bit version, you have to use C:\Windows\SysWOW64\odbcad32.exe to check if your oracle driver was properly installed.
Why on earth do they hide it? dunno.
So, if someone from oracle ever reads this, please, please, please fix the instant client distr so regular people can just follow what documentation says and actually "enjoy"
Find odbc_install.exe right hand click and select run as administrator, then the 64 bit odbc link appears in the odbc options previously I could only see the SQL option
(Note to Oracle: users dont always have automatic Admin rights on corporate machines and quite rightly too)
The other issue I have seen before is the Windows path statement does not like spaces; so if you have installed into your documents folder and your user name has a space in it the path may not work correctly, install to a folder in the root such as c:\instantclient