Kbase P26121: Unable to retrieve data using ODBC connection
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/8/2005 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
MERANT 3.60 32-BIT Progress SQL-92
SYMPTOM(s):
Unable to retrieve data using ODBC connection
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210012
[JDBC Progress Driver]:Column <field> in table PUB.<file> has value exceeding its max length or precision.
CAUSE:
Data stored in the field exceeds SQL-WIDTH of that field.
FIX:
SQL-WIDTH needs to be adjusted for the fields where data is too large. Progress Service Pack 9.1D06 introduced a new utility called dbtool that gives options to adjust the SQL Width. The syntax is dbtool db-name. See the README for 9.1D06 for further information.