We're using SQL Anywhere 10 on a Windows 2008 R2 server. There's an application running on the server that creates connections to the database when it initializes. The Sql Anywhere documentation states that these local connections using shared memory aren't subject to the 240 minute default timeout, but these connections close after the 240 minutes have elapsed.
This same application is running on a Windows 2003 server and the same version of SQL Anywhere with no problems. There are local connections that have been active for several days.
My question - Are local database connections subject to the database timeout running under Windows 2008 Server R2?
asked 10 Aug '11, 16:26
I can confirm that shared memory connections in SA 10 are not subject to the idle timeout. As of version 12 they can be if requested by the client application, though the default is still off.
Idle timeout on TCP connections in version 10 and later (actually version 6 and later) does default to 240 minutes, so it is likely that you are actually connecting over TCP/IP as Volker and Mark said. Do
answered 10 Aug '11, 17:28
There are big differences to the security model between Windows 2003 and Windows 2008 R2. One of these differences is that processes run in different namespaces (sessions) so that processes that have been created by different remote desktop sessions cannot directly "see" each other. As a result I suspect, like Volker has suggested in his comment, that your client is connecting via TCP/IP rather than shared memory.
answered 10 Aug '11, 17:13