Re: Rollback through ODBC?

Dan Creswell 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.

May I suggest Oracle Objects for OLE? Check out the following URL:

http://www.oracle.com/products/oracle_objects_for_ole/html/ooOverview.html

Best Regards,

Ken Received on Tue Mar 19 1996 - 00:00:00 CET