DTS distributed transaction - SQL Server Forums

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 distributed transaction

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-10-31 : 08:52:34

Aser writes "I have been using DTS to transfer data between Oracle 9i Lite (Microsoft
OLE DB Provider for Oracle) and SQL server 7.0/MSDE (Microsoft OLE DB
Provider for Sql Server). Dynamically I am creating and executing the
package using Visual Basic 6.0. I have enrolled all the steps in a
transaction in the DTS package as it is crucial. Initially it did not work,
error given was "Does not support distributed transaction". However after
searching online, I changed the registry entries as

For NT
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Transaction Server\Local Computer\My
Computer]
"OracleXaLib"="oraclient8.dll"
"OracleSqlLib"="orasql8.dll"
"OracleOciLib"="oci.dll"

The above works perfectly. And my package executes without any failure.

Issue 1 : In case, with Oracle 9i Lite client, Oracle is installed on the
machine, i get the same error "Does not support distributed transaction".
and package fails even after the registry has been changed.

For 2000
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]
"OracleXaLib"="oraclient8.dll"
"OracleSqlLib"="orasql8.dll"
"OracleOciLib"="oci.dll"

Issue 2 : I really havent tested on windows 2000 platform, and i dont know
if the packge will fail or succeed.

Issue 3 : Main Issue
I need to get my packge working on Windows XP. I tried changing the registry
(just like for NT and 2000) but without success.
How can i get my package to execute successfully on XP?

Issue 4 : On some machines, the package just stops after 60/65 steps. There
is no logic. I changed the oCustomTask.FastLoad = True to false and then it
works on those machine(rather slowly)

I have been trying to get the things right for more than a month now, but I
still cannot gurantee that the DTS package will execute successly on any
operating system and on any machine.

Can you kindly address the issues and show me the light at the end of the
tunnel? Is there a 100% sure way to get DTS package executing properly?

I look forward to your reply.

Any help/suggestions will be appretiatiatd."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources