Accessing a remote MySQL server using B4A... I need a demo.

Hi,
I'm new to B4A and struggling to access a remote MySQL server from my B4A app. I don't have any more time to play around, trying to learn as I do so. I'm looking for someone to develop a simple demo app for me to:

1. Demonstrate how to Log-In to my remote MySQL server
2. Provide examples of how to Delete, Update and Insert data from the database

If interested, contact me at mike@ascove.com and we can discuss further. Payment terms to be agreed if interested.

Mike

Hi Star-Dust,
I appreciate your response. The example you provided works perfectly. My misunderstanding was trying to use JRDC to connect to the remote server.

Many Thanks,
Mike

Star-Dust said:

[B4X] [B4XLib] SD_SQL (direct access to MySQL, MariaDB, MS SQL, FireBird)

Based on @Peter Simpson's code (here), I developed a library that allows you to connect directly to MySql, MsSql (for the moment) databases with B4A and B4J. To be clear, you don't need JRDC to connect to the database located on a server (I am working on a version for b4i, but it is only...

www.b4x.com

Click to expand...

Star-Dust said:

This method is for connecting to a database locally

Click to expand...

?

Ascove said:

I'm new to B4A and struggling to access a remote MySQL server from my B4A app.

Click to expand...