Click here to Skip to main content
11,715,043 members (62,408 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 Sergey Alexandrovich Kryukov 530
1 Richard MacCutchan 275
2 Maciej Los 259
3 ManasKumarM 155
4 Frankie-C 115
0 Sergey Alexandrovich Kryukov 775
1 CHill60 415
2 Richard MacCutchan 405
3 Maciej Los 389
4 OriginalGriff 320


Advertise | Privacy | Mobile
Web04 | 2.8.150901.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