Kbase 20505: Unable to connect to foreign data source with errors 1451, 778 and 8083 when using Unified DataServe
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/4/2011 |
|
Status: Verified
SYMPTOM(s):
Unable to connect to ORACLE, getting error 1451
Unable to connect to MS SQL Server, getting error 778
Unable to connect to MS SQL Server, getting error 8083 when connecting through NameServer
Failed to connect to ORACLE database . (1451)
Error <read/writing> socket, ret=<n>, errno=<n>. (778)
Failed to connect to MSS database. (6142)
MsgFormatException received on client connection : <MsgFormatException_string> <MsgFormatExceptionMsg_string>. (8083)
Using Unified DataServer Broker
Can connect to the standard DataServer Broker, _probrkr
Client is connecting to Unified Broker with only -H -S -N parameters
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
MS SQL DataServer
ODBC DataServer
Oracle DataServer
All Supported Operating Systems
CAUSE:
Progress client is missing Unified DataServer Broker connection string; "-Dsrv SVUB,1". This switch tells the client process to use the correct communication so that it can connect correctly to the Unified DataServer Broker, rather than the standard broker, _probkr.
FIX:
Client must include the "-Dsrv SVUB,1" in addition to the -H -S -N when connecting to the Unified DataServer Broker.