Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linked Server - transaction interface not supported

Status
Not open for further replies.

snufse1

Programmer
Nov 14, 2008
66
US
I have a linked server that connects to db2/400. When running the script:

Insert into #JDE_EqmTable(jde_cost_code, jde_sum_hrs, jde_uom)
Exec ('Call QGPL.get_eqmqty(?)', @JobNumber1) AT AS400SRV_MSOLEDB

I get error:
The requested operation could not be performed because OLE DB provider "DB2OLEDB" for linked server "AS400SRV_MSOLEDB" does not support the required transaction interface.

Now, when I comment out the line "Insert into....." it works fine.


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top