This question is locked. New answers and comments are not allowed.
Hi-
We're using OpenAccess with a SQL Server 2008 back-end. When using OpenAccess to call stored procedures, it is apparent that the stored procedure call is wrapped in a database transaction. This is problematic because we have stored procedure calls that need to rollback in case of error. Calling ROLLBACK in the stored proc is causing issues with the database connection from OpenAccess. Our assumption is that this is because the ROLLBACK affects the transaction initiated by OpenAccess. Some or all subsequent stored procedure calls fail with an exception.
Is there a way to disable wrapping stored procedure calls in a transaction?
We're using OpenAccess with a SQL Server 2008 back-end. When using OpenAccess to call stored procedures, it is apparent that the stored procedure call is wrapped in a database transaction. This is problematic because we have stored procedure calls that need to rollback in case of error. Calling ROLLBACK in the stored proc is causing issues with the database connection from OpenAccess. Our assumption is that this is because the ROLLBACK affects the transaction initiated by OpenAccess. Some or all subsequent stored procedure calls fail with an exception.
Is there a way to disable wrapping stored procedure calls in a transaction?