Android Question Remote sql server is alive.

[makis_best]

Hi.

How I can check if a remote sql server (Mysql, MSSql, Postqree) is alive and running?
I try with a single ping but I think it is not the correct way cuz router reply and not the server.

Any help appreciated.

Thank you

 

[Erel]

There isn't enough information here to provide a useful answer.

The very general answer is that you can't check the status of a remote server unless you have access to it.

 

[aeric]

Try to establish a connection using a connection string or provider

 

[makis_best]

@aeric Just to check if my connection is astablish or not?
Some kind of a funtion?

 

[ronshahrokh]

create webapi example asp.net core and remote database sqlserver

 

[aeric]

@aeric Just to check if my connection is astablish or not?
Some kind of a funtion?

You can make a simple query (eg. SELECT getdate() ) for a interval of let say every minute. If connection lost, error will return.

 

[ronshahrokh]

There is no need for constant checking

 

[makis_best]

@ronshahrokh What did you mean?