Android development assistance

S

stoymigo

Senior Member
Joined
Dec 11, 2008
Messages
975
Reaction score
26
Hi guys, I need some assistance, this might rescue me from legacy visual basic.

Can you send me a tutorial link/or recommend a book that will help me connect an android phone to a ms sql db. Of course I will look at this this weekend, but if you can recommend a tutorial that might speed me up it will help me because I'd like to show the company owner a demo, and I might start learning mobile development if I can show something.

Plus I'm studying & doing other work on the side so any advice/tutorial that has helped you learn this faster will help me a lot.

Even a recommendation of dev environment will help, I have eclipse installed btw.
Thanks
 
Why not just a website (asp.net) to ms sql. It will save you a bunch of hassle to setting up your android dev environment, writing and deploying your app. You can then just access the the site from your android phone.

If you want a native app I would recommend rather using web api/web service that runs on your server and your app to connect to it rather than the app connect to the db directly.
 
nfbs said:
Why not just a website (asp.net) to ms sql. It will save you a bunch of hassle to setting up your android dev environment, writing and deploying your app. You can then just access the the site from your android phone.

If you want a native app I would recommend rather using web api/web service that runs on your server and your app to connect to it rather than the app connect to the db directly.
Click to expand...

Could not have said it any better. I would go with option 2 first first though, then option 1.
 
The reason you can't find tutorials that link mobiles directly to a db server is that it it's such a bad idea, security wise, nobody would risk their reputation by showing how its done.

The db should be behind a web server at the very least.

If your db is hosted on a server that is accessible through a wifi router(also a bad idea ) then it's just a case of connecting over wifi as if it was a normal network connection. However, I don't know if Android allows peer to peer networking. Check the docs/google. If Android doesn't then there is good reason for that :)
 
You can include normal Java JAR's in your android application, so something like this might work:
http://stackoverflow.com/questions/...s-jdbc-driver-with-ms-sql-server-2008-express
Note, I have not tested anything like this myself. In general, go for the Java access from a Linux system path when searching for help on the internet.

Also, you can connect to an internal DB on the network over Wifi, so yes, Wifi is your friend in this case. Trying to get you your DB over the phone's internet connection may be beyond tricky. Long term, directly connecting from the phone to a database is probably not such a good design, but I guess it might be OK for a demo.
 
stoymigo said:
Hi guys, I need some assistance, this might rescue me from legacy visual basic.

Can you send me a tutorial link/or recommend a book that will help me connect an android phone to a ms sql db. Of course I will look at this this weekend, but if you can recommend a tutorial that might speed me up it will help me because I'd like to show the company owner a demo, and I might start learning mobile development if I can show something.

Plus I'm studying & doing other work on the side so any advice/tutorial that has helped you learn this faster will help me a lot.

Even a recommendation of dev environment will help, I have eclipse installed btw.
Thanks
Click to expand...

bad idea. just develop a web application.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X