Subject | Fixed: FB Connection problems |
---|---|
Author | sllimr7139 |
Post date | 2005-02-17T17:22:26Z |
Hi Dan,
Well I think I've got the problem figured out and a fix for it.
The problem appears to be that the ISP in question actually has
something set up to kill open connections on it's network that doesn't
have any activity on it after a certain length of time.
My brother was the one who pointed me in that direction, he's seen
this type of thing before.
So what I've done is created a simple stored proc that does nothing,
basically. The application executes the SP on a repeating timer once
every 5 mins or so. This appears to be a workable solution to the
disconnect problem, as my application ran all night last night with
out being disconnected.
I probably need to adjust the timer, as 5 min seems to be too short,
but I want to make sure that it actually works at the client site
first.
Thanks for giving me a direction to look at.
Ryan.
Well I think I've got the problem figured out and a fix for it.
The problem appears to be that the ISP in question actually has
something set up to kill open connections on it's network that doesn't
have any activity on it after a certain length of time.
My brother was the one who pointed me in that direction, he's seen
this type of thing before.
So what I've done is created a simple stored proc that does nothing,
basically. The application executes the SP on a repeating timer once
every 5 mins or so. This appears to be a workable solution to the
disconnect problem, as my application ran all night last night with
out being disconnected.
I probably need to adjust the timer, as 5 min seems to be too short,
but I want to make sure that it actually works at the client site
first.
Thanks for giving me a direction to look at.
Ryan.