How do i query data from SQL Server 2005/2008 databases to iPhone

Question

Hello,

I am trying to figure out how to utilize exisiting SQL Databases with my iPhone apps.

What i am trying to do, is have a search function. The user inputs a keyword, i would then query my SQL database dependant on the user input and return the results from a database.

How do i do this with the iPhone?

EDIT: I mean SQL Server 2005/2008 databases which are hosted online (remote).

Thanks,

-Mike

Answer 1

You need to write a PROXY PROGRAM to do that. You can't connect directly to SQLServer from iOS.

By proxy I mean a program using some kind of server side technology (IIS, ASP.NET, Java, C#) to connect to SQLServer, and implementing a TCP/IP based protocol (could be HTTP also).

On the iOS side, you need a TCP/IP (or HTTP) client to perform requests to the PROXY PROGRAM. Those request will have the SQL query you want to do in some form of internal encoding you can invent. When PROXY PROGRAM receives a request, it process the SQL query and returns and send results based, again, encoded in some form iOS could decode and process the information.