I am testing more today to ensure that this new driver is compatible with
nsodbc.c.
The two drivers are almost identical, ODBC call for ODBC call, and it looks
as though autocommit mode can be turned off pretty trivially in nsodbc.c.
I happen to find Rob's DB2 driver easier to read and understand, and it has
the beginnings of the ns_ora blob extensions -- so I am working with that
one at the moment.
I will probably post it somewhere in the next day or two and I will then
encourage people to try it out with odbc.
Using this driver, you have the choice of setting up the service in
autocommit or manual commit mode. In manual commit mode, it will be easier
to implement transactions and in fact you will have to explicitly commit
after every sequence of insert/delete/update. (Including, it appears with
SQL Server 7, committing after performing a "create table".)
Jerry
=====================================================
Jerry Asher [EMAIL PROTECTED]
1678 Shattuck Avenue Suite 161 Tel: (510) 549-2980
Berkeley, CA 94709 Fax: (877) 311-8688