Link to home
Start Free TrialLog in
Avatar of o3h
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?
ASKER CERTIFIED SOLUTION
Avatar of St3veMax
St3veMax
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial