ADO connection string keywords

To specify ActiveX Data Objects (ADO) connection string keywords, you must specify the keyword by using the keyword=value format in the provider (connection) string. You must delimit multiple keywords with a semicolon (;).

The following table describes the keywords supported by the IBM® OLE DB Provider for Db2®:

Table 1. Keywords supported by the IBM OLE DB Provider for Db2
Keyword Value Meaning
DSN Name of the database alias The Db2 database alias in the database directory.
UID User ID The user ID used to connect to the Db2 server.
PWD Password of UID Password for the user ID used to connect to the Db2 server.

Other CLI configuration keywords also affect the behavior of the IBM OLE DB Provider.