Kbase P78979: SQL-89 Query fails with error(962).
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/7/2004 |
|
Status: Unverified
SYMPTOM(s):
SQL-89 Query fails with error(962).
Error: Table <name> does not exist or cannot be accessed. (962)
Test connect from ODBC Manager works.
CAUSE:
The owner name is prepended to the table name, i.e. pub.customer.
FIX:
In SQL-89, statements use the table name without a prepended owner name, i. e.
select name from customer;