Hi Suhas,

Donnot use VFP with:

sqlsetprop(handle,"Transactions",2)

it have a bug when you disconnect the program quit without a explicit rollback.

read:
Thread #767979

A long explain start at Message #820367;
on messages Message #820416,Message #820567, Message #820602 ...

I hope Aleksey and VFPT fixed it on VFP9,
but on Message #820794 Aleksey write this,

According to this, current behavior SQLDisconnect() behavior is a legitimate BUG and, I assume, that it is not likely anyone relied on it. However, the fix I am thinking of is to force rollback rather than do nothing or generate an error.

and this is a error because this do
MSSQL multiapplication shared connections not usable.
Correct is do nothing, and to leave the backend to resolve the disconnection.

This is correct because:
- if the Client PC power supply crash, connection is disconnected without send command.
- If SQLDISCONNECT() return a error ( net line go down ), what you can do ?
Nothing !

Fabio