Question
I want to create a 32 bit ODBC DSN pointing to 32 bit IBM DB2 ODBC driver for my 32 bit application in a 64-bit environment. How do I run the 32-bit ODBC administrator in a 64-bit environment?
Cause
The Microsoft ODBC Data Source Administrator is used by DB2 to create an ODBC DSN.
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.
If you have 32-bit applications running on a 64-bit Windows server, they will need to use the 32-bit ODBC driver. To create DSNs pointing to 32-bit IBM DB2 ODBC driver, the 32-bit 'MicroSoft ODBC Data Source administrator' must be used.
Answer
First, it is good to note that both 32-bit and 64-bit ODBC drivers are avail
I want to create a 32 bit ODBC DSN pointing to 32 bit IBM DB2 ODBC driver for my 32 bit application in a 64-bit environment. How do I run the 32-bit ODBC administrator in a 64-bit environment?
Cause
The Microsoft ODBC Data Source Administrator is used by DB2 to create an ODBC DSN.
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.
If you have 32-bit applications running on a 64-bit Windows server, they will need to use the 32-bit ODBC driver. To create DSNs pointing to 32-bit IBM DB2 ODBC driver, the 32-bit 'MicroSoft ODBC Data Source administrator' must be used.
Answer
First, it is good to note that both 32-bit and 64-bit ODBC drivers are avail