Devart Forums

Hello,

thank you for fixing this issue.
Can you share some details in what kind of issue this was? Or a link to the issue description?

We are developing a complex product which runs at different clients, so before we can update the database access drivers we have to test the new driver in different parts of the product. As the reported error occurs only intermittently, additional information would help us to decide when we update our driver. For reference, can you please add the version number, in which the issue was fixed.

best regards,
Bastian

Hi,

we are using the DevartSqlServer driver (purchased version 8.3.1).

Thank you for your reply!

Hello,

we are using the devArt dbExpress Database driver for SQL Server. One of our clients seems to have connection interruptions to the database. This is handled nicely because there is an automatic reconnect in the driver.

Now, sometimes the following error occurs: "Cannot create new connection because in manual or distributed transaction mode" (in German, but that does not matter).

Part of out product is a very long running transaction while importing data. If a connection error occurs during that transaction, would it trigger a reconnect and that produce that error? MARS (multiple active result sets) are currently disabled, would this help in this scenario?

I'm (almost) sure that we don't automatically reconnect or create new connections during the transaction and we already have indications that connection errors could be possible at the client site.

Can you give us a hint what to do in such a situation? As an external software provider, we have no influence to the connection quality at the client site.

Thanks for your help,
Bastian