Solved

How to rollback transaction for MS-Access using SQL?

Posted on 1998-01-21
2
342 Views
Last Modified: 2013-12-03
I am using ODBC to interface with MS-Access.  My application manage to execute the SQL rollback command but it does not rollback the transaction.

Wherelse, I manage to rollback transaction from ORACLE which is using native mode.

Could it be something that I have to set in ODBC setup?
0
Comment
Question by:cwchaw
2 Comments
 
LVL 7

Expert Comment

by:faster
Comment Utility
Does the ACCESS driver support roll back in the first place?
0
 
LVL 1

Accepted Solution

by:
yl earned 200 total points
Comment Utility
In order to rollback a transaction you need the turn off the AutoCommit option for the connection you are using. You do this by the following Odbc API call:

SQLINTEGER iValue = SQL_AUTOCOMMIT_OFF;
SQLSetConnectAttr(hDbc, SQL_ATTR_AUTOCOMMIT, (void*) Value, NULL);
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

This tutorial is about how to put some of your C++ program's functionality into a standard DLL, and how to make working with the EXE and the DLL simple and seamless.   We'll be using Microsoft Visual Studio 2008 and we will cut out the noise; that i…
With most software applications trying to cater to multiple user needs nowadays, the focus is to make them as configurable as possible. For e.g., when creating Silverlight applications which will connect to WCF services, the service end point usuall…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now