------=_NextPart_000_0041_01C51828.5C83D7F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
We are a software company operating in India. We have been trying an =
experiment to connect developer6i to MySql database. We have been facing =
a problem while sending an insert statement to the database. The problem =
is that each insert is autocommited even if is not explicitly committed =
using the commit statement. This is true for the InnoDB tables also that =
shud support transactions. The inserts are not autocommitted in these =
tables when operated thru the MySQL console but they are autocommitted =
when operated from developer 6i using ODBC.
We are using MySql version 4.0.14 as the database at the backend.
At the frontend we are using Developer 6i (6.0.8.19.2), MyODBC- =
standard-3.51.07-win.exe. We are also using the OCA60 and the =
SQL*NET-ODBC patches.
We have been trying various options to disable autocommit like =
specifying set autocommit=3Doff at the sql prompt but no use. It would =
be great if somebody could guide us at to how to set autocommit off when =
using MySQL from Developer6i through ODBC.
Regards,
Smita
------=_NextPart_000_0041_01C51828.5C83D7F0--
