Windows 7 64bit ODBC Data sources

Today I was trying to create and ODBC Data Source to a database using 32 bit database drivers. When I accessed ODBC Data Sources (32bit) from Control Panel, I could not create a data source using 32 bit drivers and I was facing two Driver not found errors which can be seen in the following screenshots.

odbc administrator error reinstall driver

Database Driver not found error

odbc architecture mismatch between driver and application error

Driver’s ConfigDSN, ConfigDriver, or ConfigTranslator failed error

After searching in web and querying my colleagues I found that when you want to use Microsoft ODBC Administrator for:

  1. 64bit database drivers you have to run the 64bit version which is located in:
    C:\Windows\System32\odbcad32.exe
  2. 32bit database drivers you have to run the 32bit version which is located in:
    C:\Windows\SysWOW64\odbcad32.exe

Both windows look identical but the underlying implementation is different.

Advertisements

About cmanios

programming
This entry was posted in Databases, Sql Server and tagged , , , , , , . Bookmark the permalink.

One Response to Windows 7 64bit ODBC Data sources

  1. rvyafin says:

    So, the 64-bit drivers are located in System32 and the 32-bit drivers are located in SysWOW64? Very confusing!

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