Defining Basic Connection Strings
Show this topic in Library frames
The data provider uses a connection string to provide information needed to connect to a specific database server. The connection information is defined by connection string options.
The options have the form:
"option=value;option=value;option=value"
The following connection string contains the minimum information necessary to connect to a Pervasive.SQL server.
"ServerDSN=Demodata;UID=test;PWD=test;ServerName=localhost;";
See Connection String Options for the Pervasive.SQL Provider for detailed information about all of the supported connection string options.
Note the following in regards to connection strings:
- The spaces in the option names are required.
- All connection string option names are case-insensitive. For example, UID is the same as uid. However, the values of some options, such as UID and PWD, may be case-sensitive.
Table 1-1 gives the name and description for each option required for a minimum connection to a Pervasive.SQL server.
Table 1-1 Minimum Connection String Options Required for Pervasive.SQL
|
Option
|
Description
|
|
ServerDSN
|
Specifies the name of the data source on the server to which you want to connect, for example, ServerDSN=ServerDemo.
|
|
ServerName
|
The address of the server or host name and the port number where the data resides. The default port number is 1583.
For example, ServerName=myServer.1583;
|
|
PWD
|
Specifies the password used to connect to your Pervasive.SQL database.
|
|
UID
|
Specifies the default user name used to connect to your Pervasive.SQL database.
|
