Kbase P48096: [DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Table/View/Synonym not found (7519)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/08/2005 |
|
Status: Unverified
FACT(s) (Environment):
Windows
Progress 9.1D
SYMPTOM(s):
[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Table/View/Synonym not
found (7519)
Connecting to the database using ODBC.
Application is a VB application.
The error is generated executing a statement like:
SELECT SomeFieldList FROM SomeViewName
CAUSE:
The referenced view 'SomeViewName' was a 4GL created view which can not be accessed by the SQL-92 engine.
FIX:
Views created by the 4GL engine are only accessible by 4GL clients and are not accessible by JDBC or ODBC clients like the Progress SQL Explorer Tool, WinSQL, etc.
Views created by the SQL-92 engine are only accessible by ODBC and JDBC clients via the SQL-92 engine and are not accessible by 4GL client applications.