RE: [android-developers] Re: Android 2.1 & SQL Server
There are several JDBC drivers for SQL Server. One is to use the Microsoft JDBC driver, available off of Microsoft.com. It's a pure-Java driver, meaning it should work on Android, though I haven't tried it. Ted Neward Java, .NET, XML Services Consulting, Teaching, Speaking, Writing http://www.tedneward.com > -Original Message- > From: android-developers@googlegroups.com [mailto:android- > develop...@googlegroups.com] On Behalf Of Mark > Sent: Monday, May 17, 2010 3:36 PM > To: android-developers@googlegroups.com > Subject: RE: [android-developers] Re: Android 2.1 & SQL Server > > Yea, I do mean MS SQL Server. And cant find any help with it. The > problem is > I need to be able to connect and show data from tables in it. > > -Mark > > > -Original Message- > From: android-developers@googlegroups.com > [mailto:android-develop...@googlegroups.com] On Behalf Of Nerdrow > Sent: Monday, May 17, 2010 3:18 PM > To: Android Developers > Subject: [android-developers] Re: Android 2.1 & SQL Server > > You don't mean MS SQL Server, do you? As far as I'm aware there's no > ODBC/JDBC driver (at least none that are public & supported). Android > uses SQLite, there's a few examples in the SDK, it's pretty straight- > forward. > > On May 11, 6:46 am, "Mark" wrote: > > Hello everyone, > > > > Well about 3 weeks ago I switched to a Droid phone from a Windows > phone > (and > > love it). I'm getting into the programming side now. I have a MCSD & > MCSE > > from Microsoft so I know programming. Now my question is. I can't > seem to > > find any information on connecting to a SQL Server DB to retrieve & > add > > data. It was easy on the Windows phone. > > > > Please Help > > > > Mark > > > > -- > > You received this message because you are subscribed to the Google > > Groups "Android Developers" group. > > To post to this group, send email to android- > develop...@googlegroups.com > > To unsubscribe from this group, send email to > > android-developers+unsubscr...@googlegroups.com > > For more options, visit this group > athttp://groups.google.com/group/android-developers?hl=en > > -- > You received this message because you are subscribed to the Google > Groups "Android Developers" group. > To post to this group, send email to android- > develop...@googlegroups.com > To unsubscribe from this group, send email to > android-developers+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/android-developers?hl=en > > -- > You received this message because you are subscribed to the Google > Groups "Android Developers" group. > To post to this group, send email to android- > develop...@googlegroups.com > To unsubscribe from this group, send email to > android-developers+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
RE: [android-developers] Re: Android 2.1 & SQL Server
Thanks A LOT!!! That should help -Mark -Original Message- From: android-developers@googlegroups.com [mailto:android-develop...@googlegroups.com] On Behalf Of Mark Murphy Sent: Monday, May 17, 2010 5:56 PM To: android-developers@googlegroups.com Subject: Re: [android-developers] Re: Android 2.1 & SQL Server Mark wrote: > Any examples out there on getting the service to android. I found one but it > didn't work with a simple hello world web service I am not quite certain what you are asking, so here's a firehose... Android offers two HTTP access options. One is the standard Java HttpUrlConnection and kin. This has been around for a decade-plus. Here are some examples of its use: http://exampledepot.com/taxonomy/term/187 http://exampledepot.com/taxonomy/term/191 Android also has Apache HttpClient 4.x as part of the SDK. This has its own Web site: http://hc.apache.org/httpcomponents-client/ with its own examples: http://hc.apache.org/httpcomponents-client/examples.html The primary Android-specific thing is to add the INTERNET permission to your manifest. Here is a sample Android project for retrieving weather forecasts from the US National Weather Service, using HttpClient: http://github.com/commonsguy/cw-android/tree/master/Service/WeatherPlus/ Here is a sample Twitter client, using HttpClient: http://github.com/commonsguy/cw-andtutorials/tree/master/15-HttpClient/Patch y/ I am fairly certain there are dozens, perhaps hundreds, of other samples on Google Code, GitHub, and elsewhere. -- Mark Murphy (a Commons Guy) http://commonsware.com | http://github.com/commonsguy http://commonsware.com/blog | http://twitter.com/commonsguy _The Busy Coder's Guide to Android Development_ Version 3.0 Available! -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
Re: [android-developers] Re: Android 2.1 & SQL Server
Mark wrote: > Any examples out there on getting the service to android. I found one but it > didn't work with a simple hello world web service I am not quite certain what you are asking, so here's a firehose... Android offers two HTTP access options. One is the standard Java HttpUrlConnection and kin. This has been around for a decade-plus. Here are some examples of its use: http://exampledepot.com/taxonomy/term/187 http://exampledepot.com/taxonomy/term/191 Android also has Apache HttpClient 4.x as part of the SDK. This has its own Web site: http://hc.apache.org/httpcomponents-client/ with its own examples: http://hc.apache.org/httpcomponents-client/examples.html The primary Android-specific thing is to add the INTERNET permission to your manifest. Here is a sample Android project for retrieving weather forecasts from the US National Weather Service, using HttpClient: http://github.com/commonsguy/cw-android/tree/master/Service/WeatherPlus/ Here is a sample Twitter client, using HttpClient: http://github.com/commonsguy/cw-andtutorials/tree/master/15-HttpClient/Patchy/ I am fairly certain there are dozens, perhaps hundreds, of other samples on Google Code, GitHub, and elsewhere. -- Mark Murphy (a Commons Guy) http://commonsware.com | http://github.com/commonsguy http://commonsware.com/blog | http://twitter.com/commonsguy _The Busy Coder's Guide to Android Development_ Version 3.0 Available! -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
RE: [android-developers] Re: Android 2.1 & SQL Server
Any examples out there on getting the service to android. I found one but it didn't work with a simple hello world web service -Mark -Original Message- From: android-developers@googlegroups.com [mailto:android-develop...@googlegroups.com] On Behalf Of Mark Murphy Sent: Monday, May 17, 2010 5:40 PM To: android-developers@googlegroups.com Subject: Re: [android-developers] Re: Android 2.1 & SQL Server Mark wrote: > Yea, I do mean MS SQL Server. And cant find any help with it. The problem is > I need to be able to connect and show data from tables in it. You are best served by writing a Web service (REST-style recommended) and accessing it that way. -- Mark Murphy (a Commons Guy) http://commonsware.com | http://github.com/commonsguy http://commonsware.com/blog | http://twitter.com/commonsguy Android Consulting: http://commonsware.com/consulting -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
Re: [android-developers] Re: Android 2.1 & SQL Server
Mark wrote: > Yea, I do mean MS SQL Server. And cant find any help with it. The problem is > I need to be able to connect and show data from tables in it. You are best served by writing a Web service (REST-style recommended) and accessing it that way. -- Mark Murphy (a Commons Guy) http://commonsware.com | http://github.com/commonsguy http://commonsware.com/blog | http://twitter.com/commonsguy Android Consulting: http://commonsware.com/consulting -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
RE: [android-developers] Re: Android 2.1 & SQL Server
Yea, I do mean MS SQL Server. And cant find any help with it. The problem is I need to be able to connect and show data from tables in it. -Mark -Original Message- From: android-developers@googlegroups.com [mailto:android-develop...@googlegroups.com] On Behalf Of Nerdrow Sent: Monday, May 17, 2010 3:18 PM To: Android Developers Subject: [android-developers] Re: Android 2.1 & SQL Server You don't mean MS SQL Server, do you? As far as I'm aware there's no ODBC/JDBC driver (at least none that are public & supported). Android uses SQLite, there's a few examples in the SDK, it's pretty straight- forward. On May 11, 6:46 am, "Mark" wrote: > Hello everyone, > > Well about 3 weeks ago I switched to a Droid phone from a Windows phone (and > love it). I'm getting into the programming side now. I have a MCSD & MCSE > from Microsoft so I know programming. Now my question is. I can't seem to > find any information on connecting to a SQL Server DB to retrieve & add > data. It was easy on the Windows phone. > > Please Help > > Mark > > -- > You received this message because you are subscribed to the Google > Groups "Android Developers" group. > To post to this group, send email to android-developers@googlegroups.com > To unsubscribe from this group, send email to > android-developers+unsubscr...@googlegroups.com > For more options, visit this group athttp://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
