Kbase P5731: Error 1006 when starting a trigger through SQL89 connection
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/03/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 8.3E
SYMPTOM(s):
Error 1006 when starting a trigger through SQL-89 connection
[MERANT][ODBC PROGRESS driver][PROGRESS]<program name> Database <dbname> not connected. (1006)
<program name> Database <dbname> not connected. (1006)
The database in the trigger is referenced through logical name
The error doesn't occur when the database's physical name is the same as logical one.
The OIB is started with -ld and -trig parameters indicating required database's logical name and the trigger location.
CAUSE:
The Datasource configuration of the ODBC driver doesn't include -ld and -trig parameters in the Database Connection Options field. The trigger, when launched by the OID, attempts to find related tables in the database referenced by a logical name (as it has been compiled) and the ODBC connection to the OIB is done by the database's physical name (without -ld parameters). The right place to set -ld parameter when using SQL-89 connection is the Datasource configuration.
FIX:
Set -ld and -trig parameters in the Database Connection Options field in the Advanced Tab of the Datasource configuration window.