Kbase P141296: SQL connection Error reads [DataDirect][ODBC ProgressOpenEdge Wire Protocol driver]Socket closed, wi
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/13/2009 |
|
Status: Unverified
SYMPTOM(s):
SQL connection Error reads [DataDirect][ODBC ProgressOpenEdge Wire Protocol driver]Socket closed, with Development License.
Test connect error with ODBC reads [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Connection Refused. Verify Host Name and Port Number.
Database was created by a Progress restore of a database that had permissions granted for all SQL users.
Only Progress License installed on the host is for Development.
There are not database products installed on this host.
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge Category: Configuration
Progress 9.x
OpenEdge 10.x
CAUSE:
ODBC connection configuration contained an actual host name for the host entry.
Development products can create and start a databases, however, databases started by Development products will not support network connections without a WorkGroup or Enterprise database license installed on the same host. In order to test network connectivity with just a Development product installed the "localhost" setting must be used in place of host name, thereby, invoking a local loop back connection to the database.
FIX:
Development products must use localhost for the -H or "host" parameter setting to test remote connectivity.
ie:
mpro test -H localhost -S 5555