CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server

edited Nov 20, 2019 9:40AM in CNC, DB and Operating System - JDE1 (MOSC) 2 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center