Kbase P132113: Geting invalid attribute in connection string and exceeding maximum number of connection errors atte
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/06/2008 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
Geting invalid attribute in connection string and exceeding maximum number of connection errors attempting a test connect with SQL92.
[DataDirect][ODBC PROGRESS driver]Invalid attribute in connection string.
Error: [ODBC Progress Driver]:Error in Network Daemon. (8933)
_sqlsrv2 processes started but no longer responsive.
Test connect was working but is no longer working.
CHANGE:
Firewall modified.
CAUSE:
Ports for the firewall were defined for the broker port of the database but no window of ports was defined to allow the server spawned by the Broker to be accessed.
FIX:
When using firewalls ports, the ports must be opened for the brokers and all servers to be spawned by the brokers.
The ports must be open for bi-directional communication.
To constrain the broker to use specific ports, use the -minport <portnum> and -maxport <portnum> parameters when starting the database.
Each broker should define a separate range of ports to prevent contention.