Solved

Connect to a database SQL preferible

Posted on 2011-02-18
4
1,155 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 17

Expert Comment

by:Dejan Pažin
ID: 34932528

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
ID: 34937005

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
ID: 34951502
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
ID: 34951872

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn different types of Android Layout and some basics of an Android App.
If you use the Google Now Launcher, as an aftermarket add on, have a Samsung Note 5 and are worried about power consumption be wary of using the ultra power saving mode.  Here is what happened to me when I made the mistake of trying this out...
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.
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…

623 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