Click here to Skip to main content
12,255,255 members (62,305 online)
Rate this:
 
Please Sign up or sign in to vote.
Hi, I am new to PhoneGap. I want to access Sql Server Database from android phonegap app. Can anyone tell me how to do this.? Please.

Regards,

Annamalai
Posted 10-Jul-13 23:49pm
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 3

Hi, i finally found the solution. Though many here knows about this, i just want to share how i did. I wrote a webservice in c# which retrieves the data from SQL Server Database. I stored the data from database in datatable and put it JSON format through serializer.

In phonegap, i used jquery ajax to call the webservice. And the webservice has to be deployed in IIS.

Note: In webservice call using jquery ajax, use url with your machine IP address. Dont use "localhost" because while running in emulator it wont work.
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

As far as i know you cannot directly connect to a remote database. You should be hosting a web service that in turn communicate with the SQL Server database.
  Permalink  
Comments
Annamalai09 16-Jul-13 0:21am
   
So, for android app in phonegap, i have to write webservice in java and have to call it from javascript right...????
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Yes, you needs to use web services, as far as i know.
  Permalink  
Comments
Annamalai09 17-Jul-13 4:23am
   
ok.. Thank you.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160426.1 | Last Updated 31 Jul 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100