linked server unable begin distributed trasaction

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 2005 Forums

SQL Server Administration (2005)

linked server unable begin distributed trasaction

Author

Topic

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2008-07-16 : 18:32:39

I have a linked server connecting SQL Server 2005 to Sybase ASE 12.5
using ODBC driver and a DSN Data source for connectivity
it works fine
however It fails when i try to run distributed code
OS is Windows server 2k3 with sp1 on both servers
both servers can be pinged from each other
DTC service is running fine
firewall service is disabled

Please advice

following is the error
OLE DB provider "MSDASQL" for linked server "AssetAllocation" returned message "[DataDirect][ODBC Sybase Wire Protocol driver]Distributed transaction enlistment failed.".
Msg 7391, Level 16, State 2, Procedure usp_Rebalance_Process_Transactions, Line 157
The operation could not be performed because OLE DB provider
"MSDASQL" for linked server was unable to begin a distributed transaction.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-16 : 19:36:14

Did you enable DTC in both servers? Check this article:

http://groups.google.com/group/microsoft.public.sqlserver.server/msg/127255ab5a3a1fe0

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-16 : 22:58:59

YCan you post whole query?

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2008-07-17 : 14:16:54

DTC service is running fine on both servers
It seems problem is with destination Sybase server
it does not have DTC component
when i open Component services from control panel it shows nothing
it seems i need to install DTC Com component for sybase ASE 12.5
please guide me here

SCHEMA
Posting Yak Master

192 Posts

Posted - 2008-07-17 : 15:10:52

quote:
Originally posted by rajkumarrai_bis

DTC service is running fine on both servers
It seems problem is with destination Sybase server
it does not have DTC component
when i open Component services from control panel it shows nothing
it seems i need to install DTC Com component for sybase ASE 12.5
please guide me here

Here you go.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-17 : 23:39:08

DTC is windows component, does Sybase run on windows? Did you enable network access in dtc?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources