PhoneGap with SQL Server

Question

0.00/5 (No votes)

See more:

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

Annamalai09

Add a Solution

4 solutions

Solution 2

Yes, you needs to use web services, as far as i know.

Posted 16-Jul-13 22:20pm

Srinivas Kalabarigi

Comments

Annamalai09 17-Jul-13 4:23am

ok.. Thank you.

Solution 4

I develop a plugin to connect with an external SQL Server directly without any services, here is the link

GitHub - SergioDosSantos/cordova-plugin-sqlserver: Cordova Plugin to connect to SQL Server without services[^]

Posted 29-Sep-17 19:30pm

Sergio dos Santos

Updated 29-Sep-17 19:41pm

Comments

OriginalGriff 30-Sep-17 1:44am

Reopening a 4 year old question - particularly one marked solved - to post links to your work is a bad idea: it looks a lot like rep point farming which we count as abuse. That can get your account banned from the site, so you do need to be careful.
In this case, I don't think it is intended that way, so I won't start the process, but I would strongly suggest that you don't do it again, as our more trigger happy members will not be so lenient...

Member 14615882 11-Feb-20 16:09pm

Does anyone know how to connect phonegap app to online hosting mysql database....i tried its working while creating the app
But after building the app its not working...

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Srinivas Kalabarigi · Accepted Answer · 2013-07-15T07:33:00

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.

Posted 15-Jul-13 7:33am

Srinivas Kalabarigi

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...????

Annamalai09 · Accepted Answer · 2013-07-30T20:17:00

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.

PhoneGap with SQL Server

4 solutions

Solution 1

Solution 3

Solution 2

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us