About this task
There
are several ways to specify connectivity information so that your
CLI and
ODBC database applications can use the
IBM Data Server Driver for ODBC
and CLI to
connect to a database. When
CLI settings
are specified in multiple places, they are used in the listed order:
- Connection strings parameters
- db2cli.ini file
- db2dsdriver.cfg file
- Specify the database connectivity information in the connection
string parameter to SQLDriverConnect.
- For CLI applications
only: put the database connectivity information in the CLI configuration
file.
There is no support for the Command Line Processor
(CLP) with the IBM Data Server Driver for ODBC
and CLI.
For this reason, you cannot update CLI configuration
by using the CLP command "db2 update CLI cfg"; you
must update the db2cli.ini initialization file
manually.
If you have multiple copies of
the IBM Data Server Driver for ODBC
and CLI installed,
each copy of the driver has its own db2cli.ini file.
Ensure that you make the additions to the db2cli.ini for
the correct copy of the driver.
For more information about
the location of the db2cli.ini file, see db2cli.ini initialization file.
- Use the db2dsdriver.cfg configuration
file to provide connection information and parameters. For
example, you can specify the listed information in the db2dsdriver.cfg configuration
file, and pass the connection string in SQLDriverConnect() as DSN=myDSN;PWD=XXXXX:
<configuration>
<dsncollection>
<dsn alias="myDSN" name="sample" host="server.domain.com" port="446">
</dsn>
</dsncollection>
<databases>
<database name="sample" host="server.domain.com" port="446">
<parameter name="CommProtocol" value="TCPIP"/>
<parameter name="UID" value="username"/>
</database>
</databases>
</configuration>
- For ODBC applications only: register the database as an
ODBC data source with the ODBC driver manager. For more
information, see Registering ODBC data sources for applications that use the IBM Data Server Driver for ODBC and CLI.
- Use the FileDSN CLI/ODBC
keyword to identify a file data source name (DSN) that contains the
database connectivity information. For more information,
see FileDSN CLI/ODBC configuration keyword.
A file DSN is a file
that contains database connectivity information. You can create a
file DSN by using the SaveFile CLI/ODBC
keyword. On Windows operating
systems, you can use the Microsoft ODBC
driver manager to create a file DSN.
- For local database servers only: use the PROTOCOL and
the INSTANCE CLI/ODBC
keywords to identify the local database.
- Set the PROTOCOL CLI/ODBC
keyword to the value Local.
- Set the INSTANCE CLI/ODBC
keyword to the instance name of the local database server on which
the database is located.
For more information, see Protocol CLI/ODBC configuration keyword and Instance CLI/ODBC configuration keyword.