Discussion:
Preserving Access Application During SQL Server Reboots
(too old to reply)
W
2013-06-19 22:30:48 UTC
Permalink
We have a Microsoft Access application that terminates with an error every
time SQL Server is restarted. My understanding from Googling this is that
either the application or the driver is using database queries / connections
that become invalid as soon as SQL Server stops. Is there any driver we
can use with Access that would implement a connection pool or some mechanism
behind the scenes that would allow Access to survive an SQL Server reboot?
--
W
Erland Sommarskog
2013-06-20 08:01:29 UTC
Permalink
Post by W
We have a Microsoft Access application that terminates with an error
every time SQL Server is restarted. My understanding from Googling
this is that either the application or the driver is using database
queries / connections that become invalid as soon as SQL Server stops.
Is there any driver we can use with Access that would implement a
connection pool or some mechanism behind the scenes that would allow
Access to survive an SQL Server reboot?
Sounds like a question that is suitable for an Access forum.
--
Erland Sommarskog, SQL Server MVP, ***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Continue reading on narkive:
Loading...