Migrating ODBC Dependent Applications from a 32-bit to a 64-bit Server

Written by James McDonald

March 7, 2013

I have an Java application that polls a Time and Attendance clock and connects to a ODBC datasource and injects the records into a database table.

I recently moved it from an old 32-bit server Windows 2008 to Windows 2008 R2 and couldn’t get it to connect to the database any more.

I discovered that it was due to the Data source that I created being a 64-bit data source. The STDERR output of the program showed that there was a problem with architecture mismatch.

I discovered that the System DSN created using the standard Start ==> Control Panel ==> ODBC administrator was incorrect.

The answer was to delete the 64-bit DSN and create a new one with the correct 32-bit version of the ODBC Administrator program

  • The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
  • The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.

Once I ran the 32-bit version of of ODBCAD32.exe and created a 32-bit System Datasource it all started working.

REF: http://support.microsoft.com/kb/942976



Submit a Comment

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The reCAPTCHA verification period has expired. Please reload the page.

You May Also Like…

Clear HSTS Settings in CHrome

Open chrome://net-internals/#hsts enter the domain in the query field and click Query to confirm it has HSTS settings...

Ubuntu on Hyper-v

It boils town to installing linux-azure # as root or sudo apt-get update apt-get install linux-azure...