Kbase P96717: Cannot import a table into Access via ODBC connection to the database due to SQL Width issues
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/25/2004 |
|
Status: Unverified
SYMPTOM(s):
Cannot import a table into Access via ODBC connection to the database
Looks like data is being retrieved but after a long period of time receives error 20217 from the ODBC driver
[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]-20217 (#-20217)
20217 error is listed in SQL-92 Guide and Reference as a connect exception. A network error on the server.
dbtool ran against the database showed SQL width problems for this table.
CAUSE:
SQL Width problems for the table being imported.
FIX:
Use dbtool to detect and fix SQL width problems for the database. For information on dbtool see solution P24496, "What is the DBTool?"