![]() ![]() To verify that they both exist on the machine: On Windows 3.x you must use the Install ODBCĭriver icon to install the Microsoft ODBC Driver Manager and the DB2 Installed with DB2 unless the ODBC component is manually unselected during the On Windows 32-bit operating systems they are both ![]() Verify that the Microsoft ODBC Driver Manager and the DB2 CLI/ODBC driverĪre installed.See Configuring Database Connections for more details.įor more information refer to the on-line help in the CCA (or theĬATALOG DATABASE and CATALOG NODE commands in the Command Reference). To do so, use the CCA (or the command line The DB2 database (and node if the database is remote) must beĬataloged.Windows 3.x, Windows 95, Windows 98, and Windows NT Client Access to DB2 using CLI/ODBCīefore DB2 CLI and ODBC applications can successfullyĪccess a DB2 database from a Windows client, perform the following steps on UNIX Client Access to DB2 using CLI/ODBC.OS/2 Client Access to DB2 using CLI/ODBC.Windows 3.x, Windows 95, Windows 98, and Windows NT Client Access to DB2 using CLI/ODBC.The platform specific details on how to give DB2 CLI and ODBCĪpplications access to DB2 are divided into the following categories: Platform Specific Details for CLI/ODBC Access How to Set CLI/ODBC Configuration Keywords.How to Bind the DB2 CLI/ODBC Driver to the Database.If you followed the above steps to install ODBC support, and added DB2ĭatabases as ODBC data sources, your ODBC applications will now be able toĪfter the platform specific instructions there are further details on the.Of DB2 CLI/ODBC and the applications using it. Various CLI/ODBC Configuration Keywords can be set to modify the behavior.Table, then select the Primary Key tab and move one or more columnsįrom the available columns list over to the primary key columns list.Īny column you select as part of the primary key must be defined as NOT Using the Control Center you would alter the settings of the A unique index should be created for eachĭB2 table that is to be updated by an ODBC application. If a DB2 table does not have a unique index then many ODBC applications.The ODBCĭriver manager does not read the DB2 catalog information instead it The DB2 databases must be registered as ODBC data sources.Installed (this is done by default during the installation of DB2). The Microsoft, Visigenic, or other ODBC Driver Manager must already be.OS/2 and Windows 3.x you must use the Install ODBCĭriver icon to install both the DB2 CLI/ODBC driver and the ODBC driver On all platforms other than OS/2 and Windows 3.x, the DB2ĬLI/ODBC driver is automatically installed when the DB2 Client ApplicationĮnabler is installed, and therefore nothing needs to be done.Have access to this program you can use the catalog command in the Local system is represented by Local icon.) If you do not Machines) so that its instances and databases can be made known to the ControlĬenter, then add the instances and databases for that system. Use the CCA to add the database (if you have separate client and server.For complete details, see the section that deals Depending on the platform many of these steps areĪutomatic. These instructionsĪssume that you have successfully connected to DB2 using a valid user ID and The following general steps are required on the client system to give DB2ĬLI and ODBC applications access to DB2 databases. See Binding Database Utilities for specific details. With each version of the client on each platform that will access the To bind the packages, it is recommended that the administrator do this first Although this will occurĪutomatically on the first connection if the user has the required authority The separately orderable DB2 Application Development Kit product.īefore DB2 CLI or ODBC applications can access DB2, the DB2 CLI Provided by the DB2 Software Developer's Kit (DB2 SDK) which is part of DB2 CLI application development support is This support enables applications developed using ODBC and DB2 CLI APIs to ![]() On the DB2 Client Application Enablers CD-ROM or can be downloaded from the The DB2 Call Level Interface (CLI) run-time environment and the ODBC driverĪre included with the DB2 Client Application Enabler. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |