Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

Pix & continuous SQL/ODBC connections

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.

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).

Regards

1 REPLY
Silver

Re: Pix & continuous SQL/ODBC connections

Until you get your application fixed, you’ll have to keep that timeout value up there. The only problem is, this eats away at other PIX resources. 3 hours shouldn’t be too bad, more might be... depending on your network and usual load.

103
Views
0
Helpful
1
Replies