Error: Unable to begin a distributed transaction

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

Transact-SQL (2005)

Error: Unable to begin a distributed transaction

Author

Topic

snufse
Constraint Violating Yak Guru

469 Posts

Posted - 2008-12-01 : 13:10:42

I need to create a procedure that connects to a db2/400 machine and calls a proc on same. I have created a query and testing the code using query analyzer. It gives me error in the "insert into..". If I leave this line out it works fine. Any ideas?

CREATE TABLE	#JDE_JobQtyDetailTable
		(  jde_date datetime,
                   jde_cost_code nvarchar(15),
		   jde_detail_qty decimal(8,2)
                                       )
declare @JobNumber char(12)
declare @ItemNumber char(8)
declare @JdeDateFrom int
declare @JdeDateTo int       
set @JobNumber = '     1100281'
set @ItemNumber = '0080     ' 
set @JdeDateFrom = 0
set @JdeDateTo = 0

insert into #JDE_JobQtyDetailTable 
Exec ('Call QGPL.get_jobdet(?,?,?,?)', @JobNumber, @ItemNumber, 
@JdeDateFrom, @JdeDateTo) AT as400srv_msdasql

drop table #JDE_JobQtyDetailTable

Error:

OLE DB provider "MSDASQL" for linked server "as400srv_msdasql" returned message "[IBM][iSeries Access ODBC Driver]Enlist with DTC phase failed. 2".
Msg 7391, Level 16, State 2, Line 17
The operation could not be performed because OLE DB provider "MSDASQL" for linked server "as400srv_msdasql" was unable to begin a distributed transaction.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources