Click here to Skip to main content
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 11-Jul-13 0:49am
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 OriginalGriff 315
1 Jochen Arndt 190
2 DamithSL 125
3 PIEBALDconsult 110
4 Garth J Lancaster 90
0 OriginalGriff 5,790
1 DamithSL 4,601
2 Maciej Los 4,012
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,195


Advertise | Privacy | Mobile
Web01 | 2.8.141220.1 | Last Updated 31 Jul 2013
Copyright © CodeProject, 1999-2014
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