Kbase P9963: Error 7864 when trying to make an ODBC connection to database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/02/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
All Supported Operating Systems
SYMPTOM(s):
Error 7864 occurs when trying to make an ODBC connection to Progress database
Column in table has value exceeding its max length or precision (7864)
[MERANT][ODBC PROGRESS driver][PROGRESS]Column _Desc in table PUB._Index exceeding its max length or precision. (#-210012)
Database has long index descriptions
CAUSE:
Bug# OE00089451
FIX:
Index descriptions less than 144 characters in length and less than 72 characters in displayable width of the _INDEX, _DESC should be used.
Alternatively, the SQL Width can be modified as described in solution P47292.