ODBC Driver Implementation and Configuration › ODBC Connection Options › SQLDriverConnect: Selective Option Specification

SQLDriverConnect: Selective Option Specification

An application using the SQLDriverConnect form of connection must build a connection string that specifies values for the Data Source Name and for the eight data source options required by CA Datacom/DB. The required options are as follows:

• SERVER (Server Name)
• UID (User Identification)
• PWD (Password)
• SYSID (System Identification)
• APPLID (Application Identification)
• HOSTNAME (Host Name)
• HOSTPORT (Host Port Connection)
• TCP_CCI_SW (CCI or TCP Connection)

The string created by SQLDriverConnect can be constructed by the application to match an earlier connection established with the SQLBrowseConnect.

If the connection string does not include a data source name, the user is asked to choose one from those installed on the workstation. If the connection string omits an option, the ODBC driver asks the user for the options with a window called the Connection window, which is similar to the ODBC Setup window. Values specified in the Setup window when the data source was installed are displayed as default values in the Connection window.

The Connection window is bypassed only if all options are specified during data source configuration, or are provided by the application in the connection string. However, the application can specifically request the ODBC Driver to display the Connection window.