Devart Forums

We use DbxSda driver connecting to MSSQL server 2000.
The client developed is MDI (multple document interface).
One SQLConnection (or CRSQLConnection) is shared among several forms.
We used the parameter FetchAll=True , everithing was working fine.
Now for performance reason we set the parameter FetchAll=False.
Actually if one form displays results from a query, ClientDatset ApplyUpdates
called from another form gives the following error :
can not create new connection because in manual or distributed mode.

Any Idea ??



IDE : C++ Builder 6
DB MSSQL Server 2000
OS Win XP

Transaction conflict is FetchAll = False mode limitation. This is MS SQL server limitation and we can't provide any way to avoid this problem.

Is this an OLEDB limitation or bug.
Do we have to upgrade Microsoft Oledb or MDAC ?

Thanks for your help

This is server limitation. If you upgrade client it wouldn't solve the problem.