> Hi,
>
> Can you use transactions when you access Firebird db using an
> ODBC driver ?
>
> I use the IBPHoenix ODBC 2.x driver to access Firebird from my
> .asp pages.
> Everything seems to work, but I have no clue as to whether I am using
> transactions or not.
>
> I do an open connection , than perform the action I want (select, insert,
> update etc...) and than close the connection on each page where such an
> action is required. So that will be no problem. But what if I want to
> control transactions during my processing on one page ? Maybe update
> several tables, and rollback of the last one does not succeed.
>
> Or am I asking a wrong question here ?
>
> Thanks for any insight you might provide me here ...
>
>
> ----------
> E.De.L.Com bvba - De Softwarebrug naar de gebruiker!
> Professioneel maatwerk is goedkoper dan u denkt !

right place to ask the question and certainly you can control transactions
this way. The driver will have a start transaction method of some kind. I
use the gemini driver, I dare say your driver is similar... you will have
something similar to
DBConn.BeginTrans
DBConn.CommitTrans
You will get an implict transaction on each page which commits at the end og
page processing.
If you start an explicit one, it will rollback if it's not explicitly
commited.
Alan