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

P

persianpowerman1

Active Member
Licensed User
Longtime User
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??
 
Sort by date Sort by votes

barx

Well-Known Member
Licensed User
Longtime User
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?
 
Upvote 0
P

persianpowerman1

Active Member
Licensed User
Longtime User
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 ??
 
Upvote 0
P

persianpowerman1

Active Member
Licensed User
Longtime User
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!?
 
Upvote 0

LucaMs

Expert
Licensed User
Longtime User



"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
 
Upvote 0
P

persianpowerman1

Active Member
Licensed User
Longtime User
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??
 
Upvote 0

LucaMs

Expert
Licensed User
Longtime User
persianpowerman1 said:
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??
Click to expand...

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
 
Upvote 0

barx

Well-Known Member
Licensed User
Longtime User
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.
 
Upvote 0

barx

Well-Known Member
Licensed User
Longtime User
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
 
Upvote 0
P

persianpowerman1

Active Member
Licensed User
Longtime User
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
 
Upvote 0

barx

Well-Known Member
Licensed User
Longtime User
You can just use the online instance. you use a client like mysql front on your PC to to access / admin it.
 
Upvote 0

Beja

Expert
Licensed User
Longtime User
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)
 
Upvote 0
P

persianpowerman1

Active Member
Licensed User
Longtime User
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???
 
Upvote 0

barx

Well-Known Member
Licensed User
Longtime User
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.
 
Upvote 0
P

persianpowerman1

Active Member
Licensed User
Longtime User
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
 
Upvote 0

barx

Well-Known Member
Licensed User
Longtime User
I'm with you on this one Erel. I got lost a long time ago...
 
Upvote 0
P

persianpowerman1

Active Member
Licensed User
Longtime User
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
 
Upvote 0
You must log in or register to reply here.
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…