Sorry Aleksey,

I have made pressure on your answers because it is from much time that I waited for a clarification on this point.

The clarification is here:

>If connection is closed while there is in an active transaction, driver commits changes.

This point is very important, but i don't found any words on it in VFP Documentation and on MSDN.

This ODBC Driver behaviour is very strange for me.

I test it with C API.

On SQL Query Analyzer this command donnot exist

IF @@TRANCOUNT > 0 COMMIT TRAN

I do not read any ODBC book for know concept of transaction.

My knowledge of computer science sure have not been formed on the Microsoft documentation.

Fabio