Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

iOS App - Database connection

Posted on 2014-02-11
1
Medium Priority
?
486 Views
Last Modified: 2014-02-11
I have a hosted database server, and a ASP.net app that connects to it.

How do I connect to the same DB using an IOS app? I need to obtain login credentials and perform a few inserts and updates on a few tables.
0
Comment
Question by:proginc
1 Comment
 
LVL 16

Accepted Solution

by:
Surendra Nath earned 2000 total points
ID: 39851541
in the iOS end, I suggest you to create a web-api from asp.net and expose it to the iOS, instead of the mobile user trying to connect to SQL directly.

from iOS pass on the credentials to the web-api, and in the web-api (in your server), connect to SQL using the SQL Authenticaiton instead of the windows authentication, once you validated that the user using your api is a valid user.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     Intro      In this article, I will show you how to parse a JSON in Swift using an open source library called SwiftyJSON (https://github.com/SwiftyJSON/SwiftyJSON). If you haven't heard of a JSON before, it stands for JavaScript Object Notation…
No other job is as rewarding and demanding as building an iPhone app is. It is not really in the hands of the developer for the success of an iPhone app. Many factors operate jointly for every iOS application's success in the market.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
Integration Management Part 2

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question