Kbase P10528: Error 7519 when running SQL-92 query against 4GL tables
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/03/2010 |
|
Status: Verified
SYMPTOM(s):
Error 7519 when running SQL-92 query against 4GL tables
Table/View/Synonym not found (7519)
FACT(s) (Environment):
Same query previously worked in Progress 8.x using SQL89.
Windows 32 Intel
Progress 9.x
MERANT 3.60 32-BIT Progress SQL-92
CAUSE:
User is accessing a table from the PUB schema without prefixing the table with PUB. All 4GL tables, by default, are owned by PUB. Using SQL-92, all queries must specify the table owner. This was not the case when using SQL-89.
FIX:
Add the "DefaultSchema" string value set to "PUB" in the registry:
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\<your DSN name>
and
HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\<your DSN name>
This entry allows you to keep your existing code written with the ODBC SQL-89 Driver. Reconnect to the database with the client and test the application again.