Database connection

[dunski]

Hi

Would anyone know what is the quickest way to see if your app can connect to your mysql database.

You see I have an app that connects to a mysql database and sends a lot of queries to it. The thing is sometimes there might be a loss of signal or the database might be temporarily down.

If either of these 2 things happen I can loose important information that needs to be sent to the database.

So I want to check if I can connect to both internet and the database.
Then
Send info
Or
Save info to local database or text file.

If anyone has any previous experience or knowledge of this I would appreciate your input.

Thanks very much

 

[aalekizoglou]

I suppose you're talking about direct connection from device to MySQL, are you?

I've done a lot of programming with Desktop, client/server software with Delphi, and Web database apps with PHP. With mobile devices, since the connection most probably would be WiFi, there is no such thing as stable connection, therefore even in a local area network you will have dropped connections.

For that reason I am trying to develop a library based on MySQLTunnel.php which our company utilizes in a lot of cases. both the tunnel and B4A classes can be found here http://www.b4x.com/forum/additional...3-class-dbmysql-connect-via-mysql-tunnel.html

The idea is to have a Delphi like dataset on the device with all the functionality, and when needed post updates to the DB.

You can give it a try

 

[dunski]

Hi aalekizoglou,

Thanks I'll check it out.