Kbase 15391: ODBC ERROR 247 and 254 INVALID STATEMENT using MS-Access 2.0
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
ODBC ERROR 247 and 254 INVALID STATEMENT using MS-Access 2.0
Using MS-Access 2.0 and version 7.3C or 8.0A Odbc.
When attaching a table from Ms-Access to a Progress data source with
columns that have double underscores in them, you will receive errors
** Unable to understand after -- "<string>". (247) S
** Invalid statement. (254) Access voilation or Progress Odbc syntax
error.
Customer is using MFGPRO database which had double underscores in them
Fix/closure: Fixed in version 8.0B, 9
This bug was caused because of an error in the odbc driver that
incorrectly assumed that all column names with double underscores were
arrayed columns. The parsing macro has been modified to ensure that
only arrayed columns have the double underscores removed and replaced
with square brackets.
Progress Software Technical Support Note # 15391