The PRGRS_CONNECT option allows you to pass ODBC-specific information to the ODBC driver. This option has the following syntax:

Syntax

-Dsrv PRGRS_CONNECT,connection-string;

The connection string is separated from the option by a comma (,) and ends with a semicolon (;).

Use the PRGRS_CONNECT option in the following cases:

  • To connect to a data source whose name is not allowed by OpenEdge; for example, a name that includes blank spaces, ampersands (&), commas (,), and/or carets (^). In the connection string, pass the following characters rather than the unallowed characters. The driver resolves the passed characters to the unallowed character:
    • Pass the ampersand (&) character as two ampersand (&&) characters
    • Pass the caret (^) character as two caret (^^) characters
    • Pass the blank space character as an ampersand and a caret (&^)
    • Pass the comma (,) character as a caret and ampersand (^&)
  • To establish complex connections that require more than the Physical Database Name (-db), User ID (-U), and Password (-P) parameters. In all cases, the values must not be space delimited and must be passed in a single connection string.

    For example, the following connection string sets the user ID and password for the server and user ID and password for the data source:

DSN=sports;UID=engine-login-name;PWD=engine-login-pass;
UIDDBMS=dblogin;PWDDBMS=dblogin-pass

For more information and syntax examples, see Special connection issues.