>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