Kbase P23388: MS Access 2000 generates #NAME? symbols when linking a Progress table via an SQL92 ODBC connection.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Windows
Progress 9.1x
MERANT 3.60 32-BIT Progress SQL-92
SYMPTOM(s):
MS Access 2000 generates the following symbol(s):
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
when linking a Progress table via an SQL92 ODBC connection.
CAUSE:
The data stored within the Progress database is actually larger than the Progress schema's (SQL width) field definition. MS Access 2000 expects the data from a foreign database (like Progress) to to be equal to or less than the value defined within the foreign database's schema definition (since MS Access 2000 uses a foreign databases's SQL schema definition to build it own schema definition).
FIX:
1) Modify the Progress (SQL width) schema definition using the Data Dictionary to
be sure it's large enough for the data contained within the database.
2) Use the the Progress "dbtool" utility (new with the 9.1D07 service pack) to
modify the Progress (SQL width) schema definition.
3) Maintain the size of the data within the Progress database to records
which are equal to or less than the value defined by the Progress schema's
(SQL width) definition.