multiple databases in sql server on windows 2000
Posted 23 September 2002 - 04:58 PM
Posted 24 September 2002 - 12:10 PM
That allows me to access diffent SQL database, but only one per PRO-IV session.
I don't think PRO-IV supports multiple dabases from one session.
Posted 25 September 2002 - 09:36 AM
If you are able to make it work as one session and multi-database please inform us (via this forum) how. But honestly i doubt if it's even possible.
Posted 25 September 2002 - 10:20 AM
Only one SQL database can be connected per PRO-IV session. Once connected, the database is not released until PRO-IV is exited.
We have Oracle and we use database links from our ERP database to our ecommerce database.
SQL server may have a similar feature.
Posted 25 September 2002 - 10:21 AM
Posted 25 September 2002 - 10:51 AM
When connecting to multiple databases in a single PROIV session you should be aware of the potential problems with commiting data across multiple database instances.
Posted 25 September 2002 - 11:50 AM
Hope this helps looks like I wasn't the only one with this problem
Posted 26 September 2002 - 12:56 AM
Unless of course you are issuing a imbedded COMMIT command in PROIV itself. Which i myself am trying to avoid and i also tell my team to do so. Since you require to understand the PROIV cycle to be fully aware of where to properly put it. But even me eventhough am aware of the cycle i still try not to code this in.
Posted 26 September 2002 - 01:18 AM
Posted 26 September 2002 - 08:19 AM
At the end of the day i guess if we can avoid doing a update on two database then don't do it.
Posted 26 September 2002 - 11:13 AM
Traditionally, 2PC is done by Transaction Processing Monitors (sometimes more generally referred to as Transaction Managers or TMs). These are products such as CICS or Tuxedo. ProIV does not work with Transaction Managers except on the IBM mainframe.
However, nowadays most databases have a 2PC capability. For example if you update multiple Oracle databases VIA A SINGLE DATABASE CONNECTION then Oracle should provide 2PC automatically for you.
Oracle may also be able to provide 2PC with other databases if you use the right 'gateway' products - I'm not certain. I have not investigated what other databases provide.
Notice that it is vital to do the work via a single database connection - otherwise the databases don't even know their work is part of the same transaction (there are ways around this but it's too complicated to get into here and you don't want to go there..)
ProIV, as far as I am aware has no 2PC capability of its own so if you connect to multiple databases directly from ProIV (which seems to be the topic here) you definitely will not get 2PC.
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users