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 http://blogs.msdn.com/b/sql_protocols/archive/2006/03/09/546852.aspx , 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