ODBC with SQL

tantsa@hpsgpe01.sgp.hp.com (Alfred Tan) writes...

>I'm currently using Ingres ODBC drivers in a Visual Basic application and I
>cannot use SQL transaction statements. Has anybody used SQL transaction 
>statements in the same way? I know that the following SQL statements are not
>supported by the ODBC driver povided by Ingres Net:
> 
>(i)  Set Autocommit Off
>(ii) Set Autocommit On
>(iii)Rollback statements
> 
>Any help in most welcomed!
>Thanks in advance.
> 

In the dynamic SQL programming environment, SQL statements can be
either 'PREPARE'd or 'EXECUTE IMMEDIATE'.  'SET' statements can
not be 'PREPARE'd.  I think level 1 of ODBC has this limitation
of not supporting Xaction statements.

I may be mistaken, please feel free to correct me if I have
mis-stated things.

Nabil Courdy
ncourdy@macc.wisc.edu
=====================
Ingres Q & A
To William's Home Page
Email William