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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS Sql to Oracle - Distributed Transactions

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-09-23 : 09:24:10
Aser writes "I am using DTS to export and import records from SQL Server 7.0 to Oracle.

On my client machine I have installed SQL Server 7.0 and Oracle Lite, while on the server I have Oracle 9i.

I am enlisting the tasks used in the DTS package in a Transaction. However I get a message "Does not support Distributed transactions". How do I over come this problem? Are there any providers of drivers which I can install to solve my problem.

Any help will be greatly appretiated.

Aser"

chadmat
The Chadinator

1974 Posts

Posted - 2002-09-23 : 14:51:38
Is this the exact message you get?

What OS are you using?

Could this be the issue?

http://support.microsoft.com/?scid=kb;en-us;Q269344

-Chad

Go to Top of Page
   

- Advertisement -