Android Question Connect to remote DB, ElevateDB.

[vecino]

Hi, the manufacturer does not have JDBC driver.
Does anyone know how to connect?
Thank you.

 

[ronell]

https://www.b4x.com/android/forum/threads/httputils2-web-services-are-now-even-simpler.18992/

 

[vecino]

Hi.
Thanks for your help.
Does that mean that it is necessary to install a web server to access the database?
Thank you.

 

[ronell]

you need php webservice to access the db

 

[DonManfred]

I´m not sure a webservice will help as the Manufacturer does only provide a windows DLL. No java ODBC

 

[vecino]

So, is it not possible to connect in any way?

 

[Erel]

You will not be able to access it directly.

 

[karld]

I had a project that needed to pull from a database. I setup a php webpage that handles the request as a go between.

For security I just send a token to the php page that tells it to run a pre-configured SQL query. That way there is no chance
of someone doing an SQL Injection.

I return the data as JSON.

 

[vecino]

Thank you all.
Then I understand that it is the manufacturer's fault.
Because they have no alternative method to access their databases.
That is a problem.

 

[vecino]

I had a project that needed to pull from a database. I setup a php webpage that handles the request as a go between.
For security I just send a token to the php page that tells it to run a pre-configured SQL query. That way there is no chance
of someone doing an SQL Injection.
I return the data as JSON.

Hi.
Is this method suitable for any database?

 

[DonManfred]

Is this method suitable for any database?

If php is able to connect to the db...
Most probably you can not connect to the mentioned DB based on the answers here.

 

[karld]

If php is able to connect to the db...
Most probably you can not connect to the mentioned DB based on the answers here.

True...

 

[vecino]