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:[email protected]]
Enviado el: Tuesday, March 13, 2001 4:23 PM
Para: [email protected]
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
[email protected]
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 <[email protected]> on 03/13/2001 01:22:38 PM

Please respond to [email protected]

To: [email protected]
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