How to point to 32 bit IBM DB2 ODBC driver on 64-bit Microsoft system?
来源:互联网 发布:软件工程项目明细 编辑:程序博客网 时间:2024/06/05 13:35
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 available on a Windows 64-bit system. Here is where they are located.
32-bit "IBM DB2 ODBC DRIVER" is registered under:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\
Driver ---> ~\SQLLIB\BIN\DB2CLI.DLL
Setup ---> ~\SQLLIB\BIN\DB2ODBC.DLL
64-bit "IBM DB2 ODBC DRIVER" is registered under:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\
Driver ---> ~\SQLLIB\BIN\DB2CLIO.DLL
Setup ---> ~\SQLLIB\BIN\DB2ODBC64.DLL
Next it will be helpful to understand how to create a DSN using a specific driver.
Creating DSN pointing to 32-bit IBM DB2 ODBC driver:
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
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.
Example:
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). If multiple DB2 copies are installed, drivers from all of those copies will be listed.
Example:
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.
Example:
To complete the process, select a driver and then follow the prompts to create the DSN.
Creating DSN pointing to 64-bit IBM DB2 ODBC driver:
To open the ODBC Data Source Administrator, follow the below steps:
1. On the Start menu, click Control Panel.
2. In Control Panel, click Administrative Tools.
3. In Administrative Tools, click Data Sources (ODBC).
By default when ODBC administrator is open in 64-bit Windows, it will launch 64-bit 'Micorsoft ODBC Data Source Administrator' which is WINDOWS\system32\odbcad32.exe (the 64-bit version).
Example:
Using the above 64-bit Data Source Administrator, new ODBC data source can be created for the 64-bit IBM DB2 ODBC driver(DB2CLIO.DLL) only. If multiple DB2 copies are installed, drivers from all of those copies will be listed.
Example:
Move the horizontal scroll bar to the right, to see the File column and the 64-bit IBM DB2 ODBC driver -DB2CLIO.DLL listed and select one.
Example:
4. To complete the process, select a driver and then follow the prompts to create the DSN.
- How to point to 32 bit IBM DB2 ODBC driver on 64-bit Microsoft system?
- 在64位系统下安装32位ODBC驱动问题How to install and configure a 32 bit ODBC driver on a 64 bit Operating System?
- How to Install OracleClient11g32-bit on Win7 + Add ODBC
- How to Convert a 32-bit Database to 64-bit Database on Linux (remove olap)
- How to Convert a 32bit Database to 64bit Database on Linux
- File System Redirector and Sysnative - how to call 64 bit program from 32 bit application
- No JVM could be found on your system. Please define EXE4J_JAVA_HOME to point to an installed 32-bit
- No JVM could be found on your system.please define ESE4J_JAVA_HOME to point to an installed 32-bit o
- How to run 32 bit .NET Windows apps on 64 bit Windows (including with IEExec)
- How to run 32-bit app in Ubuntu 64-bit?
- How to compile Andriod in Ubuntu 64 bit system
- How to compile Android 2.3 on Ubuntu 10.04 32bit
- How to compile Android 2.3 on Ubuntu 10.04 32bit
- How to compile Android 2.3 on Ubuntu 10.04 32bit
- How to install debug flash player 11.1 on 64-bit
- How to install VirtualBox on Fedora 17 (64 bit)
- How to install ASE Isql on 64bit Win7
- How to install Pandoc on Ubuntu14.04 64 bit
- C#之中SqlCommand以及相关函数的使用
- 使用WebView显示GIF图
- 基于requirejs实现angular的按需加载
- 面向对象设计的基本原则
- 第二题
- How to point to 32 bit IBM DB2 ODBC driver on 64-bit Microsoft system?
- Visual C++ 2012 动态创建Ribbon 按钮若干问题
- autolayout Compact,Regular,Any 解析
- Session过期,如何跳出iframe框架页的问题
- MyEclipse10中配置开发Python所需要的PyDev 绝对靠谱 不忽悠!
- 实现将Android项目发布到GitHub上面
- UVa 10081 - Tight Words
- 反代理google网站
- Python二维码生成库qrcode安装和使用示例