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

 

0 Comments

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…

Squarespace Image Export

To gain continued access to your Squarespace website images after cancelling your subscription you have several...

MySQL 8.x GRANT ALL STATEMENT

-- CREATE CREATE USER 'tgnrestoreuser'@'localhost' IDENTIFIED BY 'AppleSauceLoveBird2024'; GRANT ALL PRIVILEGES ON...

Exetel Opt-Out of CGNAT

If your port forwards and inbound and/or outbound site-to-site VPN's have failed when switching to Exetel due to their...