Kbase P52644: SQL-89: Cannot select from a large table (200 - 300 fields) via ODBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
SQL-89: Cannot select from a large table (200 - 300 fields) via ODBC
Progress 9.1D
Progress 9.1C
MERANT 3.70 32-BIT Progress SQL-89
SYMPTOM(s):
WinSQL gives "SYSTEM ERROR: SQLDA metadata encoding error."
Deleting fields from a table "fixes" the problem
In WinSQL: Cannot expand tables to view fields (no + sing)
CAUSE:
You have reached a limit in the SQL-89 interface. This limitation does not exist anymore with SQL-92 complient ODBC Driver.
FIX:
Design smaller tables or use SQL-92 complient ODBC driver instead.