Kbase P100076: 'No Data' error when connecting via ODBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
ODBC Test connect button generates the following error:
[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS] No Data.
Connection timed out on socket=<n> for usernum <n>, attempt disconnect. (1280) in the database log file
Connection timed out on socket=32 for usernum <n>, attempt disconnect. (1280)
CAUSE:
Database broker is not configured to support SQL-92
FIX:
Add the parameter -ServerType SQL, start a secondary broker for SQL-92 connection or start only one broker without -ServerType 4GL, so the broker can answer requests coming from both 4GL and SQL clients