BACKGROUND:
I have two databases that support two separate applications. Both applications are required to be in sync with one anther. One application is MSSQL 2000 based and the other is Oracle 9.i. Given the complexity of the first application (host), the best solution was to use linked servers to connect the SQL database to the Oracle database.
To prevent imbalances, the host application calls a package in Oracle to update the secondary application before it completes the transaction in SQL. This way, if anything fails at any point, the entire transaction is rolled back and neither databases are updated.
PROBLEM:
Our test system is stand alone but is performing the previously mentioned transaction in the same manner to an Oracle database on a Linux server. After passing testing, we promoted the application to the live system and are experiencing the following error when the transaction attempts to call the Oracle package:
Connectivity error: [Microsoft][ODBBC SQL Server Driver][SQL Server]MSDTC on server XXXXX is unavailable.
I have done some reading, but there really isn’t much literature on linked servers. Will someone help?
Thanks so much,
Tony
See if this link might be helpful for you:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=447602&SiteID=1
|||I checked MSDTC and it appears to be running just fine.
No comments:
Post a Comment