<div>
<br />
Where do you want to have the database - on the phone or on the server? And which database?
</div>



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

<div>
<br />
1. For database on the Android device, there is full sqlite support. See here:<br />
&nbsp;<br />
&nbsp; &nbsp; <a href="http://developer.android.com/guide/topics/data/data-storage.html#db" rel="ugc">http://developer.android.com/guide/topics/data/data-storage.html#db</a><br />
<br />
&nbsp; &nbsp; Or you can use db4o:<br />
<br />
&nbsp; &nbsp; <a href="http://www.db4o.com/android/" rel="ugc">http://www.db4o.com/android/</a><br />
<br />
2. For connecting to mysql, see this:<br />
<br />
<a href="http://downloadandroid.info/2010/05/how-to-connect-to-mysql-database/" rel="ugc">http://downloadandroid.info/2010/05/how-to-connect-to-mysql-database/</a><br />

</div>



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 [http://developer.android.com/guide/topics/data/data-storage.html#db]

    Or you can use db4o:

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

2. For connecting to mysql, see this:

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


<div>
The database is locate on a web server and it is going to be SQL 2005 
</div>


The database is locate on a web server and it is going to be SQL 2005

<div>
<div class="content wysiwyg-content">
Hi there, <br />
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 &quot;Hello World&quot;, 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. <br />
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?<br />
Thanks, <br />
COHFL
</div>
</div>


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

Connect to a database SQL preferible

Android is a mobile operating system developed by Google, based on the Linux kernel and designed primarily for touchscreen mobile devices such as smartphones and tablets. Android's user interface is based on direct manipulation, using touch gestures that loosely correspond to real-world actions, such as swiping, tapping and pinching, to manipulate on-screen objects, along with a virtual keyboard for text input. In addition to touchscreen devices, variants of Android are also used on notebooks, game consoles, digital cameras, televisions, automobiles and other electronics. Applications are usually developed in Java programming language using the Android software development kit (SDK), but other development environments are also available, including Delphi, Ruby and Visual Studio (using C++).