Set up your system for the IBM i Access ODBC driver

Presents procedures for setting up your environment to support the ODBC driver. For help configuring the ODBC driver, start the ODBC administration program from the IBM® i Access Client Solutions program group, and refer to the online help.

The IBM i Access ODBC driver is an ODBC version 3.5 compliant driver. The driver requires Microsoft Data Access Components (MDAC) version 1.5 or higher. Applications that use Microsoft ActiveX Data Objects (ADO) should have MDAC version 2.1 or higher installed. The runtimes for MDAC versions 2.1 and later provide additional function for applications that use ADO, the Microsoft OLE DB provider for ODBC, and IBM i Access ODBC to access their Db2® for IBM i data. If an application uses connection pooling or Microsoft Transaction Server (MTS) support, it is recommended that the latest MDAC version be installed. You can download MDAC from the following Microsoft Web Site: http://msdn.microsoft.com/data/aa937729.aspx.

See the ODBC data source topic to configure your ODBC driver. Complete your configuration by following the steps identified by the topic adding the local system to the RDB directory.

Using independent ASPs through ODBC is optional. See independent ASPs for more information about configuring this support.

For help configuring options for a specific data source, start the ODBC Administrator from the IBM i Access Client Solutions program group, select the data source to configure, and refer to the online help.