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

Alex

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

Thanks Eric,

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