Connection Strings
- Last UpdatedOct 31, 2023
- 1 minute read
A connection string consists of a number of parameter definitions, each of which has a keyword, an ‘=’ character and a value. A semicolon separates each parameter definition from the next and is also placed at the end of the string. For example:
DSN=MyDB;UID=myname;PWD=mypassword;
Usually, the DSN, UID and PWD keywords are the only keywords that are needed.
The following table describes the attribute values of all the common keywords:
|
Keyword |
Attribute value description |
|---|---|
|
DSN |
Name of a data source. |
|
FILEDSN |
Name of a .DSN file from which a connection string will be built for the data source. |
|
DRIVER |
Description of the driver. For example, Rdb or SQL Server. |
|
UID |
A user ID. |
|
PWD |
The password corresponding to the user ID or an empty string if there is none (PWD=;). |
|
SAVEFILE |
The file name of a .DSN file in which the attribute values of keywords used in making the present, successful connection should be saved. |