Kbase P102868: Getting error (779) when specifying the connection parameters in one CONNECT statement
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/28/2008 |
|
Status: Verified
SYMPTOM(s):
Getting error 779 when specifying the connection parameters in one CONNECT statement
If you supply the -H parameter, you must also supply -S. (779)
FACT(s) (Environment):
Connecting via a remote MS SQL Server DataServer broker (unified broker or _probrkr)
The parameters -H and -S are properly specified
The error does not occur when using 2 CONNECT statements (one for the schema holder, and one for the MS SQL Server database).
Progress 9.1E
OpenEdge 10.x
MS SQL Server DataServer
ODBC DataServer
All Supported Operating Systems
CAUSE:
Bug# OE00114791
FIX:
Upgrade to 10.0B03 or later.
If upgrading is not an option, there are 2 ways to work around this error message:
1- Use 2 CONNECT statements to connect to the MS SQL Server database.
Assuming the shema holder is local, and the remote MS SQL Server DataServer unified broker is named mssbroker1:
CONNECT <path>\<Shema Holder's name> -1 .
CONNECT <ODBC DSN> -dt MSS -ld <Logical name> -H <Host Name> -S <Name Server's port> -DataService mssbroker1 -U <User name> -P <Password> .
Or
2- If the connection parameters are stored in the schema holder, just specify the ODBC DSN and the logical name.
CONNECT <path>\<Shema Holder's name> -1 .
<ODBC DSN> -ld <Logical name> .