• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

SQL Server 7.0 triggers help

DeRay_Scholz

Active Member
This is to all of you SQL Server gurus out there.

I am running SQL Server 7.0 and am adding a trigger to a JDE table. The trigger will execute on any insert to the table and insert the data into another JDE table which resides on another server.

I am getting the following error when I try and add a record to the original table:

Server: Msg 7392, Level 16, State 2, Procedure TEST, Line 3
Could not start a transaction for OLE DB provider 'SQLOLEDB'.
[OLE/DB provider returned message: Cannot start more transactions on this session.]

I can't seem to figure out what I am doing wrong or if there is some setting that I am missing.

Any help would be appreciated.

Thanks,
DeRay Scholz
The Upper Deck Company
B733.2 SP11.1 NT SQL 7.0
 

SSAJAROFF

Reputable Poster
Scholz :

Check that both SQL servers run with a domain account (preferably the same).

Sebastian Sajaroff

MCDBA

-----Mensaje original-----
De: DeRay_Scholz [mailto:deray_scholz@upperdeck.com]
Enviado el: Tuesday, March 13, 2001 4:23 PM
Para: jdelistml@jdelist.com
Asunto: SQL Server 7.0 triggers help


This is to all of you SQL Server gurus out there.

I am running SQL Server 7.0 and am adding a trigger to a JDE table. The
trigger will execute on any insert to the table and insert the data into
another JDE table which resides on another server.

I am getting the following error when I try and add a record to the original
table:

Server: Msg 7392, Level 16, State 2, Procedure TEST, Line 3
Could not start a transaction for OLE DB provider 'SQLOLEDB'.
[OLE/DB provider returned message: Cannot start more transactions on this
session.]

I can't seem to figure out what I am doing wrong or if there is some setting
that I am missing.

Any help would be appreciated.

Thanks,
DeRay Scholz
The Upper Deck Company
B733.2 SP11.1 NT SQL 7.0


--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=7
240
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +



B7321 to Xe, NT/W2K/SQL
JAS, Interoperability
MCDBA,MCP+I,MCSE,Citrix Admin
ssajaroff@grupoassa.com
Grupo ASSA - Application Software SA
 

nbandi

Member
Check whether both servers are trusted or not... Also see whether they run
distributed transaction management..





DeRay_Scholz <deray_scholz@upperdeck.com> on 03/13/2001 01:22:38 PM

Please respond to jdelist@jdelist.com

To: jdelistml@jdelist.com
cc: (bcc: Niranjan Bandi/HOFFMAN/PENTAIR/US)
Subject: SQL Server 7.0 triggers help



This is to all of you SQL Server gurus out there.

I am running SQL Server 7.0 and am adding a trigger to a JDE table. The trigger
will execute on any insert to the table and insert the data into another JDE
table which resides on another server.

I am getting the following error when I try and add a record to the original
table:

Server: Msg 7392, Level 16, State 2, Procedure TEST, Line 3
Could not start a transaction for OLE DB provider 'SQLOLEDB'.
[OLE/DB provider returned message: Cannot start more transactions on this
session.]

I can't seem to figure out what I am doing wrong or if there is some setting
that I am missing.

Any help would be appreciated.

Thanks,
DeRay Scholz
The Upper Deck Company
B733.2 SP11.1 NT SQL 7.0


--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=7240
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
 

DeRay_Scholz

Active Member
Top