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 !

----------
Ontwikkelaars van Sitestepper - ondehoud zelf uw website : www.sitestepper.com

----------
Lambrechtshoekenlaan 211 - 2170 Merksem ( Antwerpen ) - Belgium
tel: (32)3-541 77 24 - fax: (32)3-542 49 69 - mobile: (32)475-32 99 47 -
(32)475-81 67 83
web: www.edelcom.be - www.edelcom.com - email: info@...

[Non-text portions of this message have been removed]