Creating SystemDSN for 64 bit/32 bit ODBC connection on SQLSERVER

When we running 32 bit applications on 64 bit server, the application was unable to list the ODBC System DSN because it had been setup as a 64-bit DSN and the application needed a 32-bit system DSN for connectivity.

In this Document, we cover how to create a 32-bit /64-bit SYSTEM DSN on 64-bit machine.

By default on a Windows 64-bit server, when the 'Microsoft ODBC Data Source administrator' is run, it will launch the 64-bit version of odbcad32.exe, which can be used to create DSNs pointing to 64-bit IBM DB2 ODBC drivers only.

To create DSNs pointing to 32-bit IBM DB2 ODBC driver, the 32-bit 'Microsoft ODBC Data Source administrator' must be used.

 

Below are the steps to create a 32-bit DSN on a 64-bit machine.

1.    Open SYSWOW64 folder C:\WINDOWS\SYSWOW64\

2.    Run odbcad32.exe

3.       Select System DSN tab then click on Add button.

 

 

 

4.       Select a driver which you want and then follow the steps to create DSN.

 

Steps to create a 64-bit DSN on a 64-bit machine

By default ODBC administrator on 64-bit windows opens C:\WINDOWS\SYS32\odbcad32.exe

1.    Open SYSTEM32 folder C:\WINDOWS\SYS32\

2.    Run odbcad32.exe

 

 

Follow the next steps like above.