Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-25 : 09:23:43
|
| Aser writes "I am using SQL Server 7.0. In this i have created DTS package to transfer data from SQL Server to Oracle 9i (using MSDAORA/MS ODBC driver as provider for Oracle). When i try to run Distributed Transaction between two servers it gives an error message that MSDAORA does not support Distributed transactions. Is it possible to run distributed transaction between SQL server and Oracle server. If yes how? Thanx" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-25 : 10:05:37
|
| Not convinced that dts will incorporate sql server v7 in a transaction.I though Oracle 9 did support distributed transactions.If it does work it sounds like a good way of taking both servers out of action.Design things so that it doesn't need to lock either system - using staging tables should do it.Maybe another thing I should add to my signature.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
DTS distributed transactions