DevArt drvier versus built in Delphi XE driver

wloeppky · Post by **wloeppky** » Mon 28 Mar 2011 14:05

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

AndreyZ · Post by **AndreyZ** » Tue 29 Mar 2011 07:59

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.

wloeppky · Post by **wloeppky** » Tue 29 Mar 2011 13:06

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

Wayne

AndreyZ · Post by **AndreyZ** » Thu 31 Mar 2011 10:50

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