The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server
Hi All,
We are facing following issue when performing following SQL query from remote machine to database server SQL Server 2014 SP2 to insert records in JDE custom table:
begin transaction
insert into F5740SN1 (
[SNDOC],[SNITM],[SNLITM],[SNAITM],[SNDOCO],[SNDCTO],[SNDTRI],[SNDS01],[SNDS02],[SNLOTN],
[SNMMEJ],[SNDOC0],[SNDCT0],[SNEV01],[SNTCOD],[SNUSER],[SNTDAY],[SNUPMJ],[SNUPMT],
[SNJOBN] ) Select 1,123,
'55415062005748
','F000016255
',
27336,'OL',119296,'00123654789987456321
','
','S66253
',
122025,0,' ',' ',' ','Texcomp1c ',123853,119296,123853, 'Texcomp1c
'
rollback transaction
-------------------error-----------------------------
“OLE DB provider
"SQLNCLI11" for linked server "MNSERVER" returned
message "No transaction is active.".
Msg 7391, Level 16, State 2, Line
3
The operation could not be
performed because OLE DB provider "SQLNCLI11" for linked server