Progress
DataServer
for ODBC Guide
Special Connection Issues
The DataServer (-Dsrv) parameter uses the PRGRS_CONNECT option to allow you to pass ODBC-specific information to the ODBC driver. A DataServer connection string contains all of the information needed to establish a connection. It consists of a series of keywords/value pairs separated by semicolons. The Progress DataServer for ODBC passes the connection string specified by the PRGRS_CONNECT option directly through to the ODBC driver without modification. For more information, refer to the Microsoft ODBC Programmer’s Reference . It has the following syntax:
ODBC-specific connection information is passed in
connection–string
. The connection string is separated from the option by a comma (,) and ends with a semicolon (;).Value pairs within the connect string are delimited by a semicolon (;).
NOTE: PRGRS_CO is a valid abbreviation for PRGRS_CONNECT.Use the PRGRS_CONNECT parameter in the following cases:
- To establish complex connections that require more than the Physical Database Name (-db), User ID (-U), and Password (-P) parameters, as follows:
For
datasrc–name
, supply the name of the ODBC data source. Server is a driver-specific keyword. The -Dsrv connection string is passed directly to the data source. The DataServer does not modify this value.- To connect to an ODBC data source whose name has a blank space, which is not allowed by Progress, substitute the characters &^ for the illegal characters in the data-source name. Progress ignores
datasrc–name
when you use PRGRS_CONNECT; however, you must supply it to pass syntax validation. Supply the name as part of the connection string for PRGRS_CONNECT, as follows:
- To connect to the ODBC data source using the ODBC driver as a guide, specify an empty PRGRS_CONNECT, which tells the ODBC driver to handle the entire connection process interactively. This technique is useful if you are not sure about what connection parameters to use for a particular ODBC data source. For example:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |