Previous Topic: SQLBrowseConnect: Selective Server SpecificationNext Topic: SQLDriverConnect: Selective Option Specification


SQLBrowseConnect Advantages and Disadvantages

The advantage of the SQLBrowseConnect connection is that the list of available servers is provided at connection time, which allows the Server Administrator to change the names of servers without having to inform workstation users of the change. The user is configured with a single data source identifying any single member of the server group.

The disadvantage of the SQLBrowseConnect connection is that the application must include additional programming to collect the CAICCI IDs, the server name, user ID, and password from the workstation user instead of relying on the ODBC Driver to use any values installed for that data source as defaults. However, the SQLBrowseConnect form of connection allows the application to store the results of a connection process and automatically reconnect to that same server by using SQLDriverConnect.