Db2 Odbc Driver Windows 7 64 Bit
Agrale 4100 4x2 Arado aiveca 1 folha - Agrale 4100 4x2. AGRALE 4100 - ANO 1994 + 03. Agrale 416 Trabalhando. Agrale 4100. Manual Trator Agrale 4100. Home; Manual Trator Agrale 4100; Author: Warley Max 2 downloads 66 Views 8MB Size.
'Greetings, I downloaded the DB2 V10 32 bit AESE from IBM and installed it on my Windows 7 64 bit PC, after installation I tried to configure the ODBC driver, but its suprised that its not installed, I tried to reinstall DB2 again but no use.
Installing and Configuring DB2 Clients Installing and Configuring DB2 Clients The DB2 Call Level Interface (CLI) run-time environment and the ODBC driver are included with the DB2 Client Application Enabler. This is contained on the DB2 Client Application Enablers CD-ROM or can be downloaded from the Web page at This support enables applications developed using ODBC and DB2 CLI APIs to work with any DB2 server. DB2 CLI application development support is provided by the DB2 Software Developer's Kit (DB2 SDK) which is part of the separately orderable DB2 Application Development Kit product. Before DB2 CLI or ODBC applications can access DB2, the DB2 CLI packages must be bound on the server. Although this will occur automatically on the first connection if the user has the required authority to bind the packages, it is recommended that the administrator do this first with each version of the client on each platform that will access the server. See for specific details. The following general steps are required on the client system to give DB2 CLI and ODBC applications access to DB2 databases.
These instructions assume that you have successfully connected to DB2 using a valid user ID and password. Depending on the platform many of these steps are automatic. For complete details, see the section that deals specifically with your platform.
• Use the CCA to add the database (if you have separate client and server machines) so that its instances and databases can be made known to the Control Center, then add the instances and databases for that system. (Your local system is represented by Local icon.) If you do not have access to this program you can use the catalog command in the command line processor. • On all platforms other than OS/2 and Windows 3.x, the DB2 CLI/ODBC driver is automatically installed when the DB2 Client Application Enabler is installed, and therefore nothing needs to be done. On OS/2 and Windows 3.x you must use the Install ODBC Driver icon to install both the DB2 CLI/ODBC driver and the ODBC driver manager.
• To access the DB2 database from ODBC: • The Microsoft, Visigenic, or other ODBC Driver Manager must already be installed (this is done by default during the installation of DB2). • The DB2 databases must be registered as ODBC data sources. The ODBC driver manager does not read the DB2 catalog information; instead it references its own list of data sources. • If a DB2 table does not have a unique index then many ODBC applications will open it as read-only. A unique index should be created for each DB2 table that is to be updated by an ODBC application. Refer to the CREATE INDEX statement in the SQL Reference.
Using the Control Center you would alter the settings of the table, then select the Primary Key tab and move one or more columns from the available columns list over to the primary key columns list. Any column you select as part of the primary key must be defined as NOT NULL.
• Various CLI/ODBC Configuration Keywords can be set to modify the behavior of DB2 CLI/ODBC and the applications using it. • If you followed the above steps to install ODBC support, and added DB2 databases as ODBC data sources, your ODBC applications will now be able to access them.
After the platform specific instructions there are further details on the following topics: • • • The platform specific details on how to give DB2 CLI and ODBC applications access to DB2 are divided into the following categories: • • • Before DB2 CLI and ODBC applications can successfully access a DB2 database from a Windows client, perform the following steps on the client system: • The DB2 database (and node if the database is remote) must be cataloged. To do so, use the CCA (or the command line processor). See for more details.
For more information refer to the on-line help in the CCA (or the CATALOG DATABASE and CATALOG NODE commands in the Command Reference). • Verify that the Microsoft ODBC Driver Manager and the DB2 CLI/ODBC driver are installed.