Android Question How do I to practice with an ONLINE DB??

[persianpowerman1]

guys...
i am making a DB in MS Access... which i will read and write to via my android app...

but i want it to be an ONLINE db... so any idea how to go about this???
like a server where i can load it for free and try accessing it too??

 

[barx]

hmmm, for an access db you will have to create an asp script to interface with it as Access is not a server based database. Can't you use a MySQL db?

 

[persianpowerman1]

hey man.. thanx for the reply... and the knowledge. .. i never knew that
ive only used Access till today. . and since it has the option of viewing and building its data in its own environment.. i never looked at other options. ..
ok.. so may be i should download MySql and give it a try... does it have a develop environment to build tables etc it in.. or will i have to do that via executing code ??

 

[persianpowerman1]

hey buddy... dam confused now!!
I went and found the download page... ie.. http://dev.mysql.com/downloads/

but which one am i suppose to download?!?!?... hahahaaa

My requirements...
1.I am looking to build a simple DB application... possibly access it from my phone via the internet when its possibly on some server...

2.Also i have windows XP here on my computer.. so i want to practice with it on my computer via the emulator too...

3.And lastly... if i need to check it with my Android phone... is it possible to have the DB on my phones hard disk .. while the app on my same phone reads or writes to it... or then do i require a MySql for android .. or it wont work??

sorry man if this sounds stupid.. but im so dam confused!?

 

[LucaMs]

hey buddy... dam confused now!!
I went and found the download page... ie.. http://dev.mysql.com/downloads/

but which one am i suppose to download?!?!?... hahahaaa

My requirements...
1.I am looking to build a simple DB application... possibly access it from my phone via the internet when its possibly on some server...

2.Also i have windows XP here on my computer.. so i want to practice with it on my computer via the emulator too...

3.And lastly... if i need to check it with my Android phone... is it possible to have the DB on my phones hard disk .. while the app on my same phone reads or writes to it... or then do i require a MySql for android .. or it wont work??

sorry man if this sounds stupid.. but im so dam confused!?

"but i want it to be an ONLINE db"

You need to search a good Client/Server (db) tutorial.

On XP there is IIS (web server), then you need SQLServer (db server), then your app (db client), then... i'm so damn confused too

 

[persianpowerman1]

buddy... thats not helping ...

i have used VB + MsAccess.. but am totally lost here... pls help... cant understand... do i install it on my comp?.. on my phone?... use the freeMysql domains...??? how?? what??

 

[LucaMs]

buddy... thats not helping ...

i have used VB + MsAccess.. but am totally lost here... pls help... cant understand... do i install it on my comp?.. on my phone?... use the freeMysql domains...??? how?? what??

I don't know your "freeMysql domain"... may be you can "convert" your Access DB to MySql (to start!).
On your phone you must use SQLite (convert again!)

Wait for a better help

 

[barx]

OK, A little explanation.

MySQL is a server based database system. i.e it needs to run as a server. This is best done on a web based server. By that I mean a web host. Practically all web hosts servers will support MySQL databases.

You can, if you wish, run your own local server. I have found the easiest way to do this is to use WAMP (google it). This server setup is a little more tricky than a Access DB, but they are a lot better system.

As for admin, generally you use a front end called PHPMyAdmin which will be provided by the host company. There are other ways to admin though. I tend to use MySQL Front.

 

[persianpowerman1]

ok... now i have clarity. .. much more.. thanx man!

great help.. im on much better ground to read up on it now

 

[barx]

One thing I forgot to mention is, MySQL db cannot be run on an android device. You would have to sync the data to a SQLite db on the device for offline use.

There is a library available for b4a to connect to MySQL but I have never tried it.

Lastly, if you are wanting to have a go with a MySQL db, and not storing masses of data, I could set you one up for you to play with on one of my hosting accounts if you don't have such resources available. The host is pretty slow, but it will work ok.

Good luck buddy

 

[persianpowerman1]

yeah man! thats a killer.. lemme do some reading and feel worthy of playing around ... and will ask u then.. that'll be really great ))

but... does that still mean i have to install MySql on my Windows pc... right?

have already read thru most stuff.. should be good in a day or two...
do i need to get Msql Workbench too?.. seems to make stuff easier

 

[barx]

You can just use the online instance. you use a client like mysql front on your PC to to access / admin it.

 

[Beja]

You can still use MS mdb online.. all you need is ASP and Windows server on the Internet.. ask your ISP to
host you on Windows platform (not Linux)

 

[persianpowerman1]

thanx beja!

ok.. but now i am on the threshold of "What to do next.. and how to"

I've made a small DB on a free mysql hosting site... how do i connect/read/write to that DB via my emulator/deviceApp???

Please explain me this... cz for some reason im not able to solve the RDC... does anyone have an easy example... etc???

 

[barx]

Try the mySQL library. I've not used RDC so cannot comment on that, sorry.

As for any php scripts, these must be place in the web space of the host, a free db host probably doesn't offer such web space. Is it Just the DB they provide. Again, never used free hosting stuff.

 

[persianpowerman1]

no luck with the MySql Lib..

started on RDC...got the server working... but none of the examples work... (some animal proj.. and some population/country proj)... both failed...

totally stumped! how do i go ahead now?!... waiting for Erels reply on one of the Errors i posted

 

[Erel]

Which error? You posted in 5 different threads.

 

[barx]

I'm with you on this one Erel. I got lost a long time ago...

 

[persianpowerman1]

its... cool... dont wana trouble you guys...
i'll build a small project... and then post it... you guys can tell me how to get around it over there( in the project itself)

thanx sorry for the trouble if i couldnt get some stuff thats obvious to you guys...

YO!han
will post it later .. in a while