NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: TimR on March 15, 2024, 10:21:25 AM

Title: Mssql Driver options
Post by: TimR on March 15, 2024, 10:21:25 AM

Are these Driver options still recommended for MSSQL tables?
/BUSYHANDLING=2 /LOGONSCREEN=FALSE /MULTIPLEACTIVERESULTSETS=TRUE

I saw some posts from years ago and wanted to make sure a better way hasn't arrived.

Title: Re: Mssql Driver options
Post by: Bruce on March 15, 2024, 11:44:49 PM

In different contexts people seem to get different results whether MultipleActiveResultsSets os on or off.
I suspect it depends a bit on the SQL Server version, and also possibly your own code style.

But yes, from my point of view, those are still recommended.

Cheers
Bruce

Title: Re: Mssql Driver options
Post by: Alberto on March 16, 2024, 06:24:38 AM

/BUSYHANDLING=2 /LOGONSCREEN=FALSE
should be enought, at least if you use the MsSql driver
Regards