Kbase P143620: Is it possible to write to multiple databases using one DSN with SQL-92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/03/2009 |
|
Status: Unverified
GOAL:
Is it possible to write to multiple databases using one DSN?
GOAL:
Is it possible to write to multiple databases using ODBC?
GOAL:
Is it possible to write to multiple databases using SQL-92?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
No, this is not possible. Only the primary database may have changes made to it. All databases connected after the primary are read-only connections.
It would require 2 phase commit to work with database integrity. OpenEdge SQL supports 2 phase commit only when JTA is used in a Java client-server setup, but this is done using multiple DSN's from
a JDBC Java client.