Android Question Remote sql server is alive.

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Oct 30, 2019

• #2

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.

 

Upvote 0

aeric

Expert

Licensed User

Longtime User

• Oct 30, 2019

• #3

Try to establish a connection using a connection string or provider

 

Upvote 0

makis_best

Well-Known Member

Licensed User

Longtime User

• Oct 30, 2019

• #4

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

 

Upvote 0

R

ronshahrokh

Member

Licensed User

• Oct 30, 2019

• #5

create webapi example asp.net core and remote database sqlserver

 

Upvote 0

aeric

Expert

Licensed User

Longtime User

• Oct 30, 2019

• #6

makis_best said:

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

Click to expand...

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

 

Upvote 0

R

ronshahrokh

Member

Licensed User

• Oct 31, 2019

• #7

There is no need for constant checking

 

Upvote 0

makis_best

Well-Known Member

Licensed User

Longtime User

• Nov 1, 2019

• #8

@ronshahrokh What did you mean?

 

Upvote 0