Previous Topic: SQLDriverConnect: Selective Option SpecificationNext Topic: SQLConnect: Automatic Option Specification


SQLDriverConnect Advantages and Disadvantages

The advantage of the SQLDriverConnect method of connection is that the data source configuration options are used. Once the data source is configured, the workstation user does not reenter the data source options again. Options left blank when configuring the data source are collected from the user at each connection attempt, which can be appropriate for user ID, password, and server name. You can connect to any server in the server group (identified by CAICCI system and application IDs). It is also possible to connect to any server by overriding the configured CAICCI IDs and the server name.

The disadvantage of the SQLDriverConnect method of connection is that the user cannot get a list of available servers. Only the server name configured for the data source is available unless the user overrides it with a server name published by the server administrator.