• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1165
  • Last Modified:

Connect to a database SQL preferible

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
COHFL
Asked:
COHFL
  • 3
1 Solution
 
Dejan PažinHead of SW DevelopmentCommented:

Where do you want to have the database - on the phone or on the server? And which database?
0
 
Dejan PažinHead of SW DevelopmentCommented:

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
 
COHFLAuthor Commented:
The database is locate on a web server and it is going to be SQL 2005
0
 
Dejan PažinHead of SW DevelopmentCommented:

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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now