Figure 1

The ODBC connection string format.

The general format for an ODBC connection string is as follows:
ODBC; [param1=value1];[param2=value2];...
The ODBC preamble does not have to be specified if you are using ADO to open a connection. Here is a list of valid parameters:
APP Name of the application initiating the connection
DATABASE Name of the database to connect to
DRIVER Name of the driver to be used (i.e.:"{SQL Server}")
DSN Name of the Data source to be used for the connection (optional)
SERVER Network address of the server, as specified by the network protocol to be used.
PWD Password
WSID Name of numeric ID of the workstation from which the connection is initiated.