Kbase P4599: Why won't my 4GL database trigger fire from my SQL-92 ODBC connection?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
GOAL:
Why won't my 4GL database trigger fire from my SQL-92 ODBC connection?
GOAL:
Are the 4GL data dictionary triggers used by sql-92 clients?
FACT(s) (Environment):
Progress 9.x
FIX:
A Progress 9.x Database is comprised of two engines, the 4GL engine and the SQL-92 engine. A 4GL database trigger resides on the 4GL engine. A SQL-92 ODBC client connects to the SQL-92 engine. Thus, the SQL-92 client can't see the 4GL engine's database trigger.
To alleviate the problem, use the SQL-89 ODBC driver to make an ODBC client connection to the 4GL engine via the OIB/OID process. The OID process is a Progress 4GL client process which is capable of firing a 4GL database trigger.