Kbase 21149: SQL-89: SQLDA Metadata Encoding Error (2972)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/14/2011 |
|
Status: Verified
SYMPTOM(s):
SYSTEM ERROR: SQLDA metadata encoding error. (2972)
Error Using Microsoft Access via SQL-89 data source to retrieve information from a table:
"Microsoft Jet database engine could not find the object
<Table-Name>. Make sure the object exits and that you spell its
name and the path name correctly."
FACT(s) (Environment):
Windows
CAUSE:
The SQL89 server-side hitting the Progress networking 32K limit on a network logical message. The sqlda to describe the number of columns you are trying to read is greater than the 32K limit.
FIX:
Write the query to select only the table fields needed and keep the returned data to less than 32K.
A workaround for this problem when using Microsoft Access is to write the query before selecting the data source to connect to the database.
1) Select new query in design View.
2) Close Show Table Window.
3) Right mouse click and select pass thru mode.
4) Select the appropriate Data Source and click OK.
The Selected data fields will appear.