Hi,

Can anyone explain why I am getting the following message when a stored proc. is called from DataFlex? When called via the SQL Management Studio it works fine irrespective of a commit or rollback

The proc. is called within a Begin/End_Transaction but it also does its own Begin Transaction and Commit, or Rollback, Transaction. It also uses the connection that was established by the application's connection id. Baffling!

Code:
General error: 25000 (266)--[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.