SQL SERVER – Fix : Error: 3902, Severity: 16; State: 1 : The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.

SQL Server Integration Services Error : The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. (Microsoft OLE DB Provider for SQL Server)

Fix/Workaround/Solution:

Option 1:
To work around this problem, do not call the stored procedure by using ODBC Call syntax. You can call the stored procedure in may ways by using ADO. One of the methods is to call a stored procedure by using a command object. (View Example)

Option 2:
If the sql statements are like
BEGIN TRAN

SQL Statements

END TRAN

SET “RetainSameConnection” property on the connection manager to true. This will fix the problem.

Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL Error Messages, SQL Scripts, SQL Server Security, SQL Transactions
Previous Post
SQL SERVER – Running 64 bit SQL SERVER 2005 on 32 bit Operating System
Next Post
SQL SERVER – Fix : Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns

Related Posts

1 Comment. Leave new

  • Hi, thanks for your help! I’m having this problem when using vb6 + SQLServer 2005 + WinXP. Could you give an example of option 2, please?

    Reply

Leave a Reply