SQL Native Client and network disconnects
2
votes
1
answer
788
views
Does the SQL Native Client provide support for maintaining a persistent connection over the network at the driver level if there is a momentary network disconnect like a 999 error? Our applications are written in PowerBuilder (versions 12.5 and 6.5) and support SQL Server 2005 - 2014 and Express Edition - Enterprise Edition.
I read about the KeepAlive property at [Link](https://learn.microsoft.com/en-us/archive/blogs/sql_protocols/understand-special-tcpip-property-keep-alive-in-sql-server-2005) , https://technet.microsoft.com/en-us/library/ms190771(v=sql.120).aspx , and http://www.databaseskill.com/2357386/ . Would this help with this situation?
I also looked at the Microsoft site https://msdn.microsoft.com/en-us/library/ms130822(v=sql.120).aspx which lists all the SQL Native Client connection string properties. I found Failover_Partner, but this is for database mirroring, and I found MultiSubnetFailover, but this is for Always On Availability Groups (AG).
I also looked at http://www.connectionstrings.com/sql-server/ .
Thank you!
Mike Petrak
Asked by Mike Petrak
(436 rep)
Oct 13, 2015, 04:03 PM
Last activity: Oct 15, 2023, 11:32 AM
Last activity: Oct 15, 2023, 11:32 AM