I've got a series of applications that make connections to an SQL Server. The applications are designed to run with SQL Server 6.5 and 7.0, and MS Access databases.
(achieved through opening the MS Access databases as database objects, and the SQL Server connection as a connection object)
I need a quick fix on a connection problem, which appears only to be with SQL 6.5. The applications are being disconnected from the SQL server, by the SQL server - presumably after the connection timeout. Is there any way I can stop this from happening without having something like a timer firing a query every so many seconds?
I had a go at setting the .querytimeout option to 0, but that did not appear to work.
Is there perhaps an option on the SQL Server side that can be set? Anything that can be easily done in code?
Any suggestions greatfully received.
