Click here to Skip to main content
11,577,388 members (59,652 online)
Rate this: bad
good
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 at 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 at 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 DamithSL 180
1 Afzaal Ahmad Zeeshan 125
2 OriginalGriff 115
3 Richard MacCutchan 100
4 Abhinav S 90
0 OriginalGriff 820
1 Sergey Alexandrovich Kryukov 681
2 Abhinav S 528
3 F-ES Sitecore 420
4 Suvendu Shekhar Giri 375


Advertise | Privacy | Mobile
Web03 | 2.8.150603.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