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

Really? Do you mean if the connection is NORMALLY closed? I assume that's what you mean, cause if the connection to the server drops (pc dies) then I always thought the server rolled back.

I assume you mean if I do something like:

nConn = sqlconnect(connection)

SQLSetProp(nConn, "Transactions", DB_MANUAL)

SQLExec("INSERT INTO MYTABLE VALUES MYVALUES")

SQLDisq(nConn)

That the odbc driver will commit this? If so, interesting info.

BOb