Devart Forums

Delphi XE, testing DevArt driver instead of built in driver for SQL Server that comes with Delphi XE, with the built in driver a lot of my db transactions fail with error "cannot create connection because in manual or distributed tranasction mode". When I switched to the DevArt driver these errors all go away and my db transactions work like a charm.

I am wondering what is different about the DevArt driver that makes this work. Usng sqlncli10.dll for both.

A typical transaction would be:

Start db transaction
update SQL
select SQL - this is where error occurs with standard driver
update SQL
Commit db transaction

Thanks, Wayne

Hello,

We don't know why the standard driver has such behaviour. You can learn more about this error here: http://support.microsoft.com/default.as ... s%3B272358
Please write about this problem to the Embarcadero support.

I am in discussion with Embarcadero but no answer yet. Thought you might have some insight.

Wayne

This issue with the standard MSSQL dbExpress driver is well-known. You can find more information about it here:
http://edn.embarcadero.com/article/29226
http://cc.embarcadero.com/item/25998