Kbase P5622: How to use ODBC with triggers that connect to other databases
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/02/2010 |
|
Status: Verified
GOAL:
How to use ODBC with triggers that connect to other databases
GOAL:
Is it possible to use ODBC to fire triggers that connect to other databases ?
FACT(s) (Environment):
Windows
Progress 8.x
Progress 9.x
FIX:
Since the ODBC driver is tied to a Progress Client Networking, the startup.pf file can be used to connect the required other databases to the 4GL triggers.
Add the required startup parameters into startup.pf for databases that are going to be used by the triggers like this:
-db db1
-H host1
-S serv1
-N TCP
-db db2
-H host2
-S serv2
-N TCP