I am looking for a little guidance regarding IIS7 SQL Server connection pooling timeout. I have two issues.
As we have migrated our app ASP.NET app to IIS7, I am wondering what a good general value would be for the timeout would be. In IIS6 we would extend the connection timeout to several minutes so that under normal load there would always be a SQL connection available.
Second I am having a mysterious problem setting the connection pool timeout through the ODBC Administrator console. No matter what value I enter, when I re-open the form the value has changed back to the default. This must be something simple, but I am just not seeing it.
Thanks in advance, for any replies.
Jim