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 |
UID | User ID |
WSID | Name of numeric ID of the workstation from which the connection is initiated. |