SQL Server Performance Forum – Threads Archive

Linked server DTS issue

Hi need help, I am using Linked server to connect to a oracle server and transferring the data to the local tables, it is working fine if the join transaction is not selected, if we select it it fails with the following error: "MSDASQL was unable to run distributed transaction", the join transaction unit is required as I need to rollback the deletion of data from the tables in the first step of package. Any help will be appreciated. Transaction coordinator is running.

You haven’t mentioned the operating system used here if its windows 2003 fix it as per KBAhttp://support.microsoft.com/kb/839279 link.
If not ensure the MSDTC has been started successfully and you’re using valid and compatible Oracle driver to connect. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks Satya, but I am using Windows 2000.

Ensure the latest service pack has been applied and as I said latest ORacle driver too. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

I wouldn’t even do it that way, use a stored procedure instead so you can control the way the commit and rollbacks work better than your DTS package will, plus it’ll be much faster. www.aspnetsource.com www.aspnetsource.com

]]>