o3h
asked on
SQLDependency and connection timeout (I think).
Hi, Im using building a Windows app which uses SQLDependency with SQL Server 2005 express edition.
When someone update/inserts/deletes a row the app is notified this works great.
But if the is idle for a couple of minutes it stops working.
Im not sure but i think this because the connection to the SQL server timeouts?
This app will be running for several days, what would be the best solution to still have SQLDependecy events working during this time?
When someone update/inserts/deletes a row the app is notified this works great.
But if the is idle for a couple of minutes it stops working.
Im not sure but i think this because the connection to the SQL server timeouts?
This app will be running for several days, what would be the best solution to still have SQLDependecy events working during this time?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.