Re: ODBC and transactions

From: Kurt Johnson <kujotx_at_spamspamgreeneggsandspampdq.net>
Date: 1998/03/26
Message-ID: <01bd58cb$9b0d7e00$8be390d1@IT-Win95-Test.cgs.com>#1/1

Can't you just create an Access table with your transaction processing code then insert the finished Access table into your Oracle table using a pass-through query?

Regards,

Kurt

> GreMa_at_T-online.de wrote:

> >Hello !
> >I have to migrate a Visual-Basic Application (multi-user) from MS-Acces
 to
> >Oracle.
> >But in access used transactions don´t work with ODBC. VB ignores the
> >Begintrans and messages an error by executing committrans ("committrans
> >without begintrans")
> >What is the usual way / concept to use transactions in VB via ODBC ???
Received on Thu Mar 26 1998 - 00:00:00 CST