Android Question New sql connection

[Richard Phipps]

Can some please point me to the latest link for how to connect to my mysql database remotely. I currently connect via a vb.net desktop application

I have read a lot but there seems to be a lot of old threads which I am unsure which is current

I have already download the addional library jdbcsql

Thanks

 

[Peter Simpson]

I use with all desktop and paid bespoke client applications.

✅ JDBCSQL Connector/J - Connect directly to MySQL, MSSQL, PostgreSQL, MariaDB and Oracle databases

Hello fellow B4X'ers, Here is some example code for connecting your B4J projects to 5 different types of database engines, this tutorial is for learning purposes only and nothing else. Disclaimer: This code with some minor changes may also work in B4A. MySQL and MSSQL connectors definitely do...

www.b4x.com

Enjoy...

 

[Richard Phipps]

I really appreciate your reply but I only use b4a...is there something which works without alteration with B4a?

 

[Erel]

The two popular options are:
1. Direct connection with JdbcSQL.
2. Indirect connection with jRDC2 (better in most cases).

 

[Star-Dust]

Can some please point me to the latest link for how to connect to my mysql database remotely. I currently connect via a vb.net desktop application

I have read a lot but there seems to be a lot of old threads which I am unsure which is current

I have already download the addional library jdbcsql

Thanks

[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

 

[josejad]

jRDC2 is the recommended way, but you need to have a VPS to run the jRDC2 .jar file. Where are you hosting your mysql db? In a server where you can just access some kind of cpanel or phpmyadmin, or in a server where you have full access?

[B4XPages] jRDC2 + MySql CRUD + Login

Hi all: I'm starting (at last) to work with B4XPages, so I've started to adapt the B4XPages + B4XDrawer example. I think I’ve seen more examples with php + mysql, but no projects with Jrdc2. Maybe the dummy data and the UI are too basic, but you can get some ideas. What do we need? - A...

www.b4x.com

 

[Richard Phipps]

jRDC2 is the recommended way, but you need to have a VPS to run the jRDC2 .jar file. Where are you hosting your mysql db? In a server where you can just access some kind of cpanel or phpmyadmin, or in a server where you have full access?

[B4XPages] jRDC2 + MySql CRUD + Login

Hi all: I'm starting (at last) to work with B4XPages, so I've started to adapt the B4XPages + B4XDrawer example. I think I’ve seen more examples with php + mysql, but no projects with Jrdc2. Maybe the dummy data and the UI are too basic, but you can get some ideas. What do we need? - A...

www.b4x.com

Hello and sorry for delay in repaying...not sure what a VPS is

I host my Db with fast hosts...I have no control over what they have there end. Alternatively is there hosting third party who offer everything I need.. off the shelf?

 

[DonManfred]

Alternatively is there hosting third party who offer everything I need.. off the shelf?

Search google for VPS to know what it is and even to find Providers who offer VPS.