| | | | Browse by category |
Article ID: 987
Last updated: 01 Feb, 2008
Problem
The error message(s):
Cause
One cause of these error messages is a permission error on the database server. According the Sybase and MS-SQL Server documentation:
Action
Be aware that Sybase and MS-SQL Server both behave in this manner, and write your applications to take the possibilitiy of these errors into account. One method would be to check specifically for these error messages (or error codes) and then handle the situation as necessary. For more information on error handling in DBTools, please see section 8.3 of your online or printed DBTools.h++ documentation.
The error message(s):
The rollback transaction request has no corresponding BEGIN TRANSACTION.
or
The commit transaction request has no corresponding BEGIN TRANSACTION.
are occurring in my application even though a BEGIN TRANSACTION call is made.
Cause
One cause of these error messages is a permission error on the database server. According the Sybase and MS-SQL Server documentation:
Permission errors roll back transactions to the first begin transaction.
All work that was attempted inside of the transaction (or transactions) that failed will be rolled back.
Action
Be aware that Sybase and MS-SQL Server both behave in this manner, and write your applications to take the possibilitiy of these errors into account. One method would be to check specifically for these error messages (or error codes) and then handle the situation as necessary. For more information on error handling in DBTools, please see section 8.3 of your online or printed DBTools.h++ documentation.
This article was:
Helpful |
Not helpful
Report an issue
Article ID: 987
Last updated: 01 Feb, 2008
Revision: 1
Views: 10935
Posted: 03 Dec, 1999 by
Dean J.
Updated: 01 Feb, 2008 by
Dean J.
Others in this category
Powered by KBPublisher (Knowledge base software)