Solved

Connect to a database SQL preferible

Posted on 2011-02-18
4
1,146 Views
Last Modified: 2012-05-11
Hi there,
I have done some research on how to develop Android apps but there a few gaps that i would like to cover. I have create "Hello World", Textbox integration and all that good stuff. But now i need to some how hook it up to a SQL database and have a login and things like that. I read that a direct connection to SQL is not possible for some reason which at the end make some sort of sense.
My question is how can i connect to a SQL database if web service is the way to go is there a good tutorial that points me to the right direction? What would be the best practices?
Thanks,
COHFL
0
Comment
Question by:COHFL
  • 3
4 Comments
 
LVL 17

Expert Comment

by:Dejan Pažin
Comment Utility

Where do you want to have the database - on the phone or on the server? And which database?
0
 
LVL 17

Expert Comment

by:Dejan Pažin
Comment Utility

1. For database on the Android device, there is full sqlite support. See here:
 
    http://developer.android.com/guide/topics/data/data-storage.html#db

    Or you can use db4o:

    http://www.db4o.com/android/

2. For connecting to mysql, see this:

http://downloadandroid.info/2010/05/how-to-connect-to-mysql-database/
0
 

Author Comment

by:COHFL
Comment Utility
The database is locate on a web server and it is going to be SQL 2005
0
 
LVL 17

Accepted Solution

by:
Dejan Pažin earned 500 total points
Comment Utility

In that case, go for the solution no. 2 in the first post.


Or, you can try jtds driver and connect with that:

http://jtds.sourceforge.net/

That would of course be simpler, but I've never tried it. Some people claim it works:

http://stackoverflow.com/questions/2379237/android-with-sql-server-2008
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

A short article about problems I had with the new location API and permissions in Marshmallow
You should read OS supplied guidelines before developing. I can't stress that enough. The guidelines will help you understand the reasons mobile app developers do what they do.  Apple is very particular when they review appstore submissions.
This video is in connection to the article "The case of a missing mobile phone (https://www.experts-exchange.com/articles/28474/The-Case-of-a-Missing-Mobile-Phone.html)". It will help one to understand clearly the steps to track a lost android phone.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now