Keeping idle connections alive!

Tools

Keeping idle connections alive!

Hi All,

    Is there anyway to keep the connections alive in SQL Assistant. In the system i am using its expiring every 3 minutes and i have to login again. any shortcuts?

Thanks in advance.

Tags (2)
4 REPLIES
N/A

Re: Keeping idle connections alive!

This is no setting in SQLA.

But your DBA might automatically disconnect idle sessions (although 3 minutes is quite short)

Dieter

Re: Keeping idle connections alive!

Thanks Dieter for u r prompt response.
i could have stated better.
Yes the setting in the server is such that they will disconnect idle sessions(idle for 3 minutes).

Is there by any mechanism we can overcome this in SQLA, instead of connecting again and again and losing any data in the VT's?
In Putty and all we have an option to send send alive packets to keep the connection alive with the unix servers.
N/A

Re: Keeping idle connections alive!

AFAIK there's now way to do this in SQLA. 

You should talk to your DBA, maybe he's willing to increase that value :-)

Dieter

Re: Keeping idle connections alive!

Thanks Dieter :-)