SQL Server and MARS Hi, Does anyone have experience with MARS and SQL Server when using native client in your Windev/Webdev application? Which connection string text should be used to force MARS usage on a connection? I have weird error message popping up on some of our clients workstations "cannot create new connection because in manual or distributed transaction mode" and it happens on simple HReadSeekFirst while transaction is active. The weird thing is that it happens on some workstations only. I would like to try to solve it with MARS. Regards, Alex https://www.wxforum.info/read.php?27131,799174,799174#msg-799174 Tue, 19 May 2026 03:26:55 +0200 Phorum 5.2.23 https://www.wxforum.info/read.php?27131,799174,799176#msg-799176 Re: SQL Server and MARS https://www.wxforum.info/read.php?27131,799174,799176#msg-799176
I found that string too however I do not know if it actually works with Windev connections. I guess I just have to try it. That is why I asked if anyone used MARS in the past.

Best regards,
Alex]]> alex.kolaric WinDev Forum Mon, 16 Mar 2026 20:08:04 +0100 https://www.wxforum.info/read.php?27131,799174,799175#msg-799175 Re: SQL Server and MARS https://www.wxforum.info/read.php?27131,799174,799175#msg-799175
I believe you use:

MultipleActiveResultSets=True

This can be in your analysis connection/extended information or if you use HDescribeConnection and use the Extended Information portion.

Eric W]]> ewiegert WinDev Forum Mon, 16 Mar 2026 20:02:29 +0100 https://www.wxforum.info/read.php?27131,799174,799174#msg-799174 SQL Server and MARS https://www.wxforum.info/read.php?27131,799174,799174#msg-799174
Does anyone have experience with MARS and SQL Server when using native client in your Windev/Webdev application? Which connection string text should be used to force MARS usage on a connection? I have weird error message popping up on some of our clients workstations

"cannot create new connection because in manual or distributed transaction mode"

and it happens on simple HReadSeekFirst while transaction is active. The weird thing is that it happens on some workstations only. I would like to try to solve it with MARS.

Regards,
Alex]]> alex.kolaric WinDev Forum Mon, 16 Mar 2026 19:21:03 +0100