Click here to Skip to main content
11,920,353 members (54,382 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.


Posted 11-Jul-13 0:49am
Rate this: bad
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.
Rate this: bad
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.
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
Please Sign up or sign in to vote.

Solution 2

Yes, you needs to use web services, as far as i know.
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
0 OriginalGriff 415
1 phil.o 170
2 Dave Kreskowiak 155
4 F-ES Sitecore 130
0 OriginalGriff 6,778
1 KrunalRohit 4,495
2 Sergey Alexandrovich Kryukov 3,203
3 George Jonsson 2,805
4 Suvendu Shekhar Giri 2,181

Advertise | Privacy | Mobile
Web02 | 2.8.151120.1 | Last Updated 31 Jul 2013
Copyright © CodeProject, 1999-2015
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