Previous Topic: SQLDriverConnect Connection String FormatNext Topic: Driver-Specific Connection and Statement Attributes


Supported Attribute Keywords and Attribute Values

The following table provides a summary of the connection string attribute keywords and attribute values supported on the SQLDriverConnect function. This table includes both the keywords defined as part of the Microsoft ODBC specification and those defined as extensions for CA IDMS Server. These keywords correspond to the fields in the DriverConnect dialogs as well as to the information used to define data sources and servers in the ODBC Administrator.

Keyword

Defined By

Attribute Value

DSN

Microsoft

Data source name

DRIVER

Microsoft

Driver name (cannot use with DSN)

DICT

CA

Dictionary name (use with DRIVER only)

NODE

CA

Node name (use with DRIVER only)

TASK

CA

Alternate task code (use with DRIVER only)

UID

Microsoft

User ID

PWD

Microsoft

Password

ACCT

CA

Account information, if used

CCINAME

CA

CAICCI host server name or IP address (optional, use with DRIVER only). Presence of this option dictates the use of the 'CCI' communications protocol. Either an IPv4 or an IPv6 address can be specified.

CCIPORT

CA

CAICCI host server port (optional, use with DRIVER only). This option is required when the CCINAME option is specified.

WAIT

CA

CAICCI reply wait timeout (optional, use with DRIVER only)

HOST

CA

DNS host name or IP address of the target IDMS CV (optional, use with DRIVER only). Presence of this option dictates the use of the 'IDMS' communications protocol. Either an IPv4 or an IPv6 address can be specified.

PORT

CA

TCPIP port number of the IDMSJSRV listener (optional, use with DRIVER only). This option is required when the HOST option is specified.

SSL

CA

Secure Sockets Layer indicator (optional, use with DRIVER only)

PROGRAM

CA

Program name (optional, use with DRIVER only)

The following is an example of a connection string for CA IDMS Server:

DSN=CA IDMS database;UID=JELKA01;PWD=XYZZY;ACCT=R45-87

Note: For more information, see the following: