NetTalk Central

Author Topic: Mssql Driver options  (Read 2381 times)

TimR

  • Newbie
  • *
  • Posts: 28
    • View Profile
Mssql Driver options
« 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.


Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Mssql Driver options
« Reply #1 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

Alberto

  • Hero Member
  • *****
  • Posts: 1873
    • MSN Messenger - alberto-michelis@hotmail.com
    • View Profile
    • ARMi software solutions
    • Email
Re: Mssql Driver options
« Reply #2 on: March 16, 2024, 06:24:38 AM »
/BUSYHANDLING=2 /LOGONSCREEN=FALSE
should be enought, at least if you use the MsSql driver
Regards
-----------
Regards
Alberto