SQLitening Support Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

Welcome to the SQLitening support forums!

Author Topic: Keeping a conntection client-server alive  (Read 428 times)

Fim

  • Guru
  • ***
  • Posts: 145
    • View Profile
    • Fims sajt
Keeping a conntection client-server alive
« on: December 05, 2017, 08:23:01 AM »

If a client does not call the server in x minutes, you will get an error -18 at the next call.
Is there any good way to stay connected?
/Fim W.
Logged
Fim W

cj

  • Master Geek
  • ****
  • Posts: 679
    • View Profile
Re: Keeping a conntection client-server alive
« Reply #1 on: December 05, 2017, 10:57:10 PM »

http://sqlitening.com/support/index.php?topic=9196.msg24122#msg24122
http://www.sqlitening.com/support/index.php?topic=3412.30
SQLiteningServer.Cfg
FACT
ConnectionTimeOut = Number Minutes --- Control the number of minutes the server will wait to receive a message from an active connection.  Default is 30. Set to -1 if you want to never timeout.
Logged
CJ

Fim

  • Guru
  • ***
  • Posts: 145
    • View Profile
    • Fims sajt
Re: Keeping a conntection client-server alive
« Reply #2 on: December 06, 2017, 02:40:11 AM »

The server works so well, so you forget that there is an SQLiteningServer.Cfg. Now I have changed to Timout = -1.
Thanks for the help.
Then there's another thing, why should you have a TimOut at all?

/Fim W.
Logged
Fim W

cj

  • Master Geek
  • ****
  • Posts: 679
    • View Profile
Re: Keeping a conntection client-server alive
« Reply #3 on: December 06, 2017, 07:38:07 AM »

Some programs connect, do something, disconnect to allow many more clients or free memory on server.
The time-out terminates a connection if a client doesn't do anything within an expected time period.
Both methods have advantages, but if connect time is very small I'd connect, do something, disconnect.
On a local network it might make more sense to stay connected.   
















Logged
CJ

Fim

  • Guru
  • ***
  • Posts: 145
    • View Profile
    • Fims sajt
Re: Keeping a conntection client-server alive
« Reply #4 on: December 06, 2017, 08:38:43 AM »

Cj,
Thank you for the clarification.
Logged
Fim W