Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

> ## 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 DataServer for MS SQL Server passes the connection string specified by the `PRGRS_CONNECT` option directly through to the ODBC driver without modification. For more information and a complete list of keywords, refer to the Microsoft ODBC programming reference documentation. The parameter has the following syntax:

> Syntax
>     -Dsrv PRGRS_CONNECT,connection-string;

> 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 (;). There can be no spaces within `connection-string`. If any of the name/value pairs does include a space, substitute the value &^ for the space.

> 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:

>     CONNECT datasrc-name -ld logical-datasrc-name -dt MSS
>     			-Dsrv
>     PRGRS_CO,DSN=datasrc-name;server=servername;UID=name;PWD=password;.

> For `datasrc–name`, supply the name of the MS SQL Server database. `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 MS SQL Server database whose name has a blank space, which is not allowed by OpenEdge, substitute the characters &^ for the illegal characters in the data source name. OpenEdge 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:

>     CONNECT datasrc-name -ld logical-database-name -dt MSS
>     		-Dsrv PRGRS_CO,data-&^source&^name;.

> - To connect to the MS SQL Server database using the ODBC driver as a guide, specify an empty `PRGRS_CONNECT`, which tells the ODBC driver to handle the entire connection process interactively. For example:

>     CONNECT datasrc-name -ld logical-name -dt MSS
>     			-Dsrv PRGRS_CO,;.

> To simplify your `PRGRS_CONNECT` string, you can specify a File DSN. When you configure access to your SQL Server database, specify a File DSN and then reference that file in your connect string. For example:

>     CONNECT datasrc-name -ld logical-name -dt MSS
>     			-Dsrv PRGRS_CO,FILEDSN=dsn-filename;.

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