Android Question I want an example in connecting b4a with mysql online .. Thanks

[AlfaizDev]

https://www.b4x.com/android/forum/t...ation-of-rdc-remote-database-connector.61801/

I have implemented the example on the local server and works fine
We want even a small example of this library running on an online server

 

[Erel]

The client code is exactly the same. Just need to update the url to the correct address.

 

[AlfaizDev]

What should I change in this code in the client code?

Private const rdcLink As String = "http://xxx.xxx.x.x:17178/rdc"

What about config file and b4j application
I need more detail

 

[josejad]

I need more detail

We need more details too to help you

Where will you run your mysql server? And where will you run you jRDC2 server?

Your jRDC2 server must point to your MySql server (in the config file). If they are in the same computer (VPS), you will have something like:

JdbcUrl=jdbc:mysql://localhost:3306?characterEncoding=utf8

If they are in different computers, it should be something like:

JdbcUrl=jdbc:mysql://yourserverip:3306?characterEncoding=utf8

The client code (your app), must point to your jRDC2 server...

Maybe this post be usefull to you:

https://www.b4x.com/android/forum/threads/how-to-connect-to-mysql-database.98619/#post-623279
https://www.b4x.com/android/forum/threads/server-run-a-server-on-a-vps.60378/#post-423579

 

[AlfaizDev]

We need more details too to help you

Where will you run your mysql server?

On my free hosting
Server: sql12.freemysqlhosting.net

And where will you run you jRDC2 server?

That's what I want to know
Do I have to run jRDC2 on a computer even if I want to connect online

I want to connect online directly
And the use of servers are all online only
And connect to it through b4a
Do without computer Is this possible in this library

 

[josejad]

Do without computer Is this possible in this library

No. jRDC2 is a middleware server.
If you want yo connect directly to your MySQL server you need to use another way.

https://www.b4x.com/android/forum/threads/connect-android-to-mysql-database-tutorial.8339/

 

[AlfaizDev]

No. jRDC2 is a middleware server.
If you want yo connect directly to your MySQL server you need to use another way.

https://www.b4x.com/android/forum/threads/connect-android-to-mysql-database-tutorial.8339/

Thank you very much for the help
I will use the other way you referred me