Automatic reconnect / Long running transactions

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
bastian
Posts: 2
Joined: Tue 13 Apr 2021 06:45

Automatic reconnect / Long running transactions

Post by bastian » Wed 04 Aug 2021 08:26

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

Stellar
Devart Team
Posts: 446
Joined: Tue 03 Oct 2017 11:00

Re: Automatic reconnect / Long running transactions

Post by Stellar » Mon 06 Sep 2021 07:59

Hi,

Thank you for your reply.
Which driver are you using to connect to MS SQL Server (DevartSQLServer or DevartSQLServerDirect)?

Looking forward to your reply!
Best regards,
Sergey,
Devart Support Team

bastian
Posts: 2
Joined: Tue 13 Apr 2021 06:45

Re: Automatic reconnect / Long running transactions

Post by bastian » Mon 13 Sep 2021 06:42

Hi,

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

Thank you for your reply!

Post Reply