Kbase P136897: Intermittent ODBC connection failure: Connection refused. Verify Host Name and Port Number.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/06/2010 |
|
Status: Verified
SYMPTOM(s):
Periodically, an SQL query using the ODBC driver, will fail with a connection error.
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver] Connection refused. Verify Host Name and Port Number. [DataDirect][ODBC Progress OpenEdge Wire Protocol driver] Socket closed.
The ODBC trace log created by turning on ODBC tracing shows that the socket has closed and the connection has been refused.
DIAG [08S01] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed. (7503)
DIAG [08S01] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Connection refused. Verify Host Name and Port Number. (0)
DIAG [IM006] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Driver's SQLSetConnectAttr failed. (0)
Connections are refused periodically, about once a day.
Connections are refused for about an hour, and then after that period will be accepted.
Only two out of the three network cards installed can be successfully pinged during the time period when the SQL connections are refused.
Running Start --> Settings --> Network Connections shows that one of the network card's status is currently disabled.
The network card that cannot be pinged is configured as a teamed, logical network card.
FACT(s) (Environment):
Network card teaming is also referred to as link aggregation.
The machine has three network cards installed and configured.
Running an ipconfig /all command on the server shows three network cards.
The network cards are teamed into a single logical network card.
Windows
OpenEdge 10.1B
CAUSE:
The teamed, logical network card is not currently enabled.
FIX:
Enable the teamed, logical network card's network connection by running Start --> Settings --> Network Connections.
Right click on the disabled connection and choose Enable.