Re: Rollback through ODBC?

In article <4iip30$o6a_at_dub-news-svc-2.compuserve.com>,

   aradford_at_interserv.com (Andrew Radford) wrote:
>We are writing a Visual Basic application that does updates against an Oracle
>database. The inserts are done using SQLPassthrough. The problem is that if
 we
>send a rollback command, it doesn't. We have also tried using the ODBC API
>calls and the same thing happens.
>
<snip>

Who's ODBC driver are you using??

The problem you've got sounds like an implementation restriction of the ODBC driver. You can check what can and cannot be done by querying the driver using (C API) SQLGetInfo.

The other thing is that a lot of ODBC drivers have an 'autocommit' option which is on by default. Again, driver info should tell you about this. You can disable it using (C API) SQLSetConnectionOption.

Sorry, all the calls are for 'C', I'm not familiar with VB's SQL interface.

Regards,

Dan. Received on Mon Mar 18 1996 - 00:00:00 CET