Kbase P116230: Getting error (779) when connecting to Unified Data server broker
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/10/2009 |
|
Status: Unverified
SYMPTOM(s):
Getting error 779 when connecting to Unified Data server broker
If you supply the -H parameter, you must also supply -S. (779)
Connecting via a remote MS SQL Server DataServer unified broker
-DataService present in connection parameter
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).
FACT(s) (Environment):
Progress 9.1E
MS SQL Server DataServer
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> -Dsrv svub,1 .
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 .
-db <ODBC DSN> -ld <Logical name> .
Or
3. Use probroker to connect