Need the ability to explicitly set DBPROP_COMMITPRESERVE
Posted: Mon 03 May 2010 23:10
Hi,
I would like to set
DBPROP_COMMITPRESERVE and DBPROP_ABORTPRESERVE to TRUE for static cursor.
This is needed to avoid the "object is in zombie state" errors.
See details here: http://support.microsoft.com/kb/321714
I could set these properties using ADO but could not found a way to set it using SDAC.
Temporarly I added these 2 lines
AddPropBool(DBPROP_COMMITPRESERVE, True);
AddPropBool(DBPROP_ABORTPRESERVE, True);
into procedure TOLEDBRecordSet.SetCommandProp;
and now our application works fine.
Can you please expose these properties on the TMSConnection or on TMSSQ and TMSQuery?
Or it would be even better if you would let customization of command properties (maybe an event on the connection which gets called in TOLEDBRecordSet.SetCommandProp). In the event handler I could set any property before the properties are assigned to the command).
Regards
Geza
I would like to set
DBPROP_COMMITPRESERVE and DBPROP_ABORTPRESERVE to TRUE for static cursor.
This is needed to avoid the "object is in zombie state" errors.
See details here: http://support.microsoft.com/kb/321714
I could set these properties using ADO but could not found a way to set it using SDAC.
Temporarly I added these 2 lines
AddPropBool(DBPROP_COMMITPRESERVE, True);
AddPropBool(DBPROP_ABORTPRESERVE, True);
into procedure TOLEDBRecordSet.SetCommandProp;
and now our application works fine.
Can you please expose these properties on the TMSConnection or on TMSSQ and TMSQuery?
Or it would be even better if you would let customization of command properties (maybe an event on the connection which gets called in TOLEDBRecordSet.SetCommandProp). In the event handler I could set any property before the properties are assigned to the command).
Regards
Geza