ODBC driver for Windows

The ODBC client package works with Windows as a 32-bit and 64-bit driver.

Downloading and configuring

Download the relevant Windows ODBC driver from the IBM® Data Server Driver Package.

64 bit


DSClients-ntx64-dsdriver-...      
IBM Data Server Driver Package (Windows/x86-64 64 bit)
...

32-bit


DSClients-nt32-dsdriver-...      
IBM Data Server Driver Package (Windows/x86-32 32 bit)
...

To install the ODBC client, run the appropriate file as administrator: v10.5fp3_ntx64_dsdriver_EN.exe or v10.5fp3_nt32_dsdriver_EN.exe

ODBC driver directory structure

The Db2 Big SQL Windows ODBC driver folder contains the following directories and files for both the ..\win32\ and the ..\win64\ versions:

..\bin: Contains the DLL files for the application.
..\lib: Contains the runtime library file.
..\cfg: Contains the odbc.ini configuration file.
..\include: Contains the header files that are used to compile client applications.
sql_dsn.vbs: This script updates the registries with any additional DSN information in the odbc.ini file configuration information. For any DSN information added to the odbc.ini file, run the sql_dsn.vbs script file as an administrator from a Windows command line to register the added DSN information.

ODBC driver configuration

The configuration information for the ODBC driver is specified in the db2dsdriver.cfg file. For more information about the Data Server driver package, see Validating IBM Data Server Driver Package (Windows) installation.

Edit the db2dsdriver.cfg file to provide the required DSNalias and database information.

Client application configuration

A client application must provide the DSN name to the ODBC driver.

If the client application does not need to be compiled first, the name is provided in the external data source configuration of the client application. These applications generally contain user-friendly interfaces and can be configured by using the interface of the application.

If the client application must be compiled first, use one of the following ODBC application programming interfaces:

SQLConnect
SQLDriverConnect

These functions are useful for applications that have no user interface. In these cases, the application must reference the header file that is included in the following ODBC directory, ..\include.

Removing the ODBC driver and DSN entries

To remove the ODBC driver, run Windows Start -> All Programs -> IBM -> IBM Db2 Big SQL ODBC driverUninstall IBM Db2 Big SQL ODBC Driver.

If you remove the ODBC driver, the DSN that is created during installation is removed. You can remove other DSN entries by using the Windows registry (Windows Start ->Run->regedit) and

Deleting the relevant DSN entries under ODBC->ODBC.INI.
Deleting the relevant DSN names under ODBC->ODBC.INI->ODBC Data Sources.

Then, edit the db2cli.ini file to remove relevant DSN entries from it.