My office computer recently got upgraded. It is now running Windows Vista 64bit as it has 8Gig of ram in it (32-bit can’t make use of more than 4Gig of ram). Why so much memory? For running VM’s mainly (lots of test environments, etc).
Well, I was back to working on a program that uses the ODBC drivers to connect to our Oracle database. I had previously installed and configured the Oracle 64-bit ODBC drivers, and the test in the ODBC Configuration panel works just fine. But the program won’t connect.
Guess what - you have to use the 32-Bit ODBC drivers (ok, I kind of suspected that). The real catch tho, is to configure it, you have to launch the control panel from the command line so you get the 32-bit version of the ODBC configuration tool. The command line is:
%WINDIR%\SysWOW64\odbcad32.exe
If you just run odbcad32.exe, windows will run the 64-bit version (despite the name showing 32).