Progress
ODBC Driver Guide


Connecting to a Data Source Using a Connection String

If your application requires a connection string to connect to a data source, you must specify the data source name that tells the driver which section in the system information to use for the default connection information. Optionally, you may specify attribute=value pairs in the connection string to override the default values stored in the system information. These values are not written to the system information. You can specify either long or short names in the connection string. The connection string has the form:

DSN=data_source_name[;attribute=value[;attribute=value]...] 

An example of a connection string is:

DSN=PROGRESS;DB=PAYROLL;UID=JOHN;PWD=XYZZY;HOST=LOCALHOST;
PORT=2055 

Table 2–1 gives the long and short names for each attribute, as well as a description.

The defaults listed in the table are initial defaults that apply when no value is specified in either the connection string or in the data source definition in the system information. If you specified a value for the attribute when configuring the data source, that value is the default.

Table 2–1: Connection String Attributes
Attribute
Description
Database (DB)
The name of database to which you want to connect.
DataSourceName (DSN)
A string that identifies a Progress data source configuration in the system information
HostName (HOST)
The name of the system where the database is stored.
LogonID (UID)
The default logon ID (user name) used to connect to your Progress database. A logon ID is required only if security is enabled on your database. If so, contact your system administrator to get your logon ID. This ID is case-sensitive.
Password (PWD)
A case-sensitive password.
PortNumber (PORT)
The system port number setup for the database listener process.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095