If there is a tutorial on how to do this, please just link it. I have spent some time looking over both this site and Google and have not found a single tutorial.

Anyways, I have the url of a server which host a database, the layout of that database with the names of tables and what the tables have in them, and the userID/password for the server. How do I connect to the server (though the emulator, if it makes a difference) and access the database so I can query it?

I'm not asking for code, just pointers to tutorials, classes to read about, methods which may be of help, ect.

Please and thank you.

I have the same issue here!

Afaik there is no direct way to query a MySql DB for example.
I read once that there is a theoretical way with jdbc drivers. But a
android client -> server -> db architecture is better anyway.
XML as protocol and some php code on a server thats all.
I have a sample code here in the forum .. the thread was
about a simple login or something like that.
If you want to exchange complex oder huge amount of data
i would suggest some investigation in JSON and SOAP or REST.

Greets
Padde

padde wrote:Afaik there is no direct way to query a MySql DB for example.
I read once that there is a theoretical way with jdbc drivers. But a
android client -> server -> db architecture is better anyway.
XML as protocol and some php code on a server thats all.
I have a sample code here in the forum .. the thread was
about a simple login or something like that.
If you want to exchange complex oder huge amount of data
i would suggest some investigation in JSON and SOAP or REST.

Greets
Padde

I switched off my last project because it was getting into SOAP and REST and I wasn't sure what I was doing.

But let me see if I understand you. You are saying that (except in a possible way using jdbc drivers, which I will have to go look up), there is no way to query a database without some php code written on the server that you will use, and have that code query the database for you. That seems really troublesome. Well, maybe if I can find something with the jdbc drivers...

Thanks.

Well.. not necessarily php ... afaik SOAP doesn't need php.
I avoided SOAP too.. but i needed just small data amount
sended back to android.. so i took the less bitter pill and
implemented basic XML protocol with a php file on server
side.

I wish you good luck for your jdbc research!



Greets
Padde