On the Start menu, click Control Panel.Ģ. To open the ODBC Data Source Administrator, follow the below steps:ġ. To complete the process, select a driver and then follow the prompts to create the DSN.Ĭreating DSN pointing to 64-bit IBM DB2 ODBC driver: Move the horizontal scroll bar to the right, to see the File column and the 32-bit IBM DB2 ODBC driver - DB2CLI.DLL listed and select one.
#DB2 ODBC DRIVER 64 BIT DRIVERS#
If multiple DB2 copies are installed, drivers from all of those copies will be listed. Using the 32-bit Data Source Administrator, a new ODBC data source can be created for the 32-bit IBM DB2 ODBC driver (DB2CLI.DLL). Using Windows Explorer, browse to the C:\WINDOWS\SysWOW64\odbcad32.exe and double click on the odbcad32.exe to bring up the 32-bit ODBC Data Source administrator. 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 maintains its own copy of the registry that is only for 32-bit applications.
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).
#DB2 ODBC DRIVER 64 BIT HOW TO#
Next it will be helpful to understand how to create a DSN using a specific driver.Ĭreating DSN pointing to 32-bit IBM DB2 ODBC driver: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Ħ4-bit "IBM DB2 ODBC DRIVER" is registered under: Here is where they are located.ģ2-bit "IBM DB2 ODBC DRIVER" is registered under: First, it is good to note that both 32-bit and 64-bit ODBC drivers are available on a Windows 64-bit system.
0 kommentar(er)
