Fetch All=False

Elmoh · Post by **Elmoh** » Mon 30 Jan 2006 16:38

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

Ikar · Post by **Ikar** » Tue 31 Jan 2006 09:47

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

Elmoh · Post by **Elmoh** » Tue 31 Jan 2006 14:06

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

Thanks for your help

Ikar · Post by **Ikar** » Mon 06 Feb 2006 12:01

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