Query
Reference Manual
Query and ODBC
: Connection Strings
Connection Strings
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.
1974 to current year.
AVEVA Solutions Limited and its subsidiaries. All rights reserved.
