• 1 reply
  • Latest Post - ‏2013-06-14T14:27:02Z by amccarl
73 Posts

Pinned topic How do I run the 32-bit ODBC administrator in a 64-bit environment?

‏2013-06-11T19:15:26Z | db2 dbdsupport hivalue technical-article

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.

Microsoft Windows 64-bit platforms maintain a compatibility feature which enables a 32-bit application to run transparently in a 64-bit environment, known as WOW64, (Windows-32-on-Windows-64). This maintains its own copy of the registry that is only for 32-bit applications. 

The data sources using 32-bit IBM DB2 ODBC drivers can be created by using the 32-bit Microsoft ODBC data Source Administrator:  C:\WINDOWS\SysWOW64\odbcad32.exe

This is also covered by the technical article 1384435


  • amccarl
    73 Posts

    Re: How do I run the 32-bit ODBC administrator in a 64-bit environment?

    Hello!  We've had a number of clients respond through feedback to our technical documents indicating that they have further questions or comments that require additional dialogue.  Unfortunately, our feedback is anonymous, so unless an email address or other contact information is included, we have no way to get back in touch with you.
    Within DB2 support, the management team asked if we could somehow link our documents to the forums so that we could invite more discussion - like this!   As a start, we chose about 30 technical articles and "seeded" the forum with initial entries so that we could have a starting place for conversation.  The documents have now been updated with links to the forums as well.  
    Hopefully, we will make DB2 support better by providing more interaction around our technical information!