Getting to 32-bit ODBC data on 64-bit Windows

This really got me frustrated for a few days until a colleague pointed me in the right direction. The issue concerns actually displaying your 32-bit ODBC control panel in 64bit windows.

I was trying to install and setup some 32-bit drivers to an open source database engine within Windows Server 2008. I have been aware for a long time that there are both 32 and 64 bit versions of the ODBC control panel in windows and have set up both in the past (though it had been a while since i had to do 32-bit on 64 bit system.)

I kept running odbcadm32.exe using the “Run..” dialog box. This kept opening up the 64 bit ODBC control panel and had me really confused. The trick is to specify the path and run c:\windows\syswow64\odbc32adm.exe Both versions have the same filename and windows will choose the 64bit by default!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: