SqlDbx
You are not logged in.
Pages: 1
I'm pretty sure this is not a problem with SqlDbx, but i'd like to hear some comments anyway.
Basically if I leave my connection with the database idle for some time, the connection will time out and freeze the program. I have to manually kill it from Task Manager.
Is anyone aware of this problem?
Offline
Do you have timeout set in SqlDbx or your admin kills your connection?
Offline
I have set disconnect option to 'Never' in SqlDbx.
Confirmed with the administrator that he doesn't kill any idle connections. Not familiar with any similar timeout settings on Sybase either.
Offline
How does this issue manifest itself.
Is application frozen after some time?
Does it hangs after you try to execute SQL when connection timed out?
Offline
I usually have multiple connections opened for weeks and do not experience any problems
How does this issue manifest itself.
Is application frozen after some time?
Does it hangs after you try to execute SQL when connection timed out?
That's close. The application will freeze when I try to run a query, disconnect or even close it. It is not happening with all my databases, just some of them. Not sure what the problem is, or what settings to tweak.
Offline
It would be helpful if you try to leave connection opened for long
time in isql or some other tool to see if the issue is related to SqlDbx
or something else.
Offline
It would be helpful if you try to leave connection opened for long
time in isql or some other tool to see if the issue is related to SqlDbx
or something else.
I left isql connected for two hours and ran a query, which executed perfectly. However, I have noted that the same disconnection problem occurs with using sql advantage. But because i can close the connection in sql advantage, it is less disruptive compared to sqldbx.
Offline
Thanks for the info.
What version of Open Client you have installed and
what Sybase version you use?
Offline
Adaptive Server Enterprise/12.5.3/EBF 13196 ESD#6/P/Sun_svr4/OS 5.8/ase1253/1945/32-bit/FBO/Fri Jan 20 07:50:34 2006
Open Client 12.5.1
Offline
What happens if you open connection in SqlDbx, then kill it from isql or sqladvantage and then
try to execute query in SqlDbx.
Does it hangs?
Offline
Pages: 1