topic Pix & continuous SQL/ODBC connections in Network Security https://community.cisco.com/t5/network-security/pix-continuous-sql-odbc-connections/m-p/40813#M687490 <P>I've come across a problem w/ a home-grown application on a DMZ opening a connection to an internal SQL server through a PIX. The app seems to want to open a connection and keep it open forever. The Pix, as per default, drops the connection after an hour. In response to irrate developers we've upped the timeout value to 3 hrs, hoping that at least some traffic would flow through that socket within that time-period.</P><P></P><P>Has anyone else come across a similar problem? Have you any other thoughts on settings that could be changed. We'd like to limit the timeout value somewhat and are pushing the developers to write in some type of keep-alive transaction (slim chance).</P><P></P><P>Regards</P> Fri, 21 Feb 2020 05:53:58 GMT mcordiez 2020-02-21T05:53:58Z Pix & continuous SQL/ODBC connections https://community.cisco.com/t5/network-security/pix-continuous-sql-odbc-connections/m-p/40813#M687490 <P>I've come across a problem w/ a home-grown application on a DMZ opening a connection to an internal SQL server through a PIX. The app seems to want to open a connection and keep it open forever. The Pix, as per default, drops the connection after an hour. In response to irrate developers we've upped the timeout value to 3 hrs, hoping that at least some traffic would flow through that socket within that time-period.</P><P></P><P>Has anyone else come across a similar problem? Have you any other thoughts on settings that could be changed. We'd like to limit the timeout value somewhat and are pushing the developers to write in some type of keep-alive transaction (slim chance).</P><P></P><P>Regards</P> Fri, 21 Feb 2020 05:53:58 GMT https://community.cisco.com/t5/network-security/pix-continuous-sql-odbc-connections/m-p/40813#M687490 mcordiez 2020-02-21T05:53:58Z Re: Pix & continuous SQL/ODBC connections https://community.cisco.com/t5/network-security/pix-continuous-sql-odbc-connections/m-p/40814#M687507 <HTML><HEAD></HEAD><BODY><P>Until you get your application fixed, you&#146;ll have to keep that timeout value up there. The only problem is, this eats away at other PIX resources. 3 hours shouldn&#146;t be too bad, more might be... depending on your network and usual load. </P></BODY></HTML> Thu, 15 Nov 2001 15:05:19 GMT https://community.cisco.com/t5/network-security/pix-continuous-sql-odbc-connections/m-p/40814#M687507 smahbub 2001-11-15T15:05:19Z