SQL Server Iphone interaction

ey guys:
Do you guys know any iphone app which interact with SQL Server through XML. which can give me the idea how to interact with SQL Server through XML?

looks like you will need to write a web service that exposes the data and then interface with this from the iPhone across the network.

http://www.iphonedevsdk.com/forum/i...ap-service.html

Hi mandyshri and Master__Chief, do a web search for "iPhone ODBC SDK" --using the industry standard Open Database Connectivity (ODBC) saves weeks of coding and on 29 August 2011, Microsoft announced it's going to replace OLEDB in SQLServer with pure ODBC.







Disclaimer: we may benefit from this tip

Hey guys:
Do you guys know any iphone app which interact with SQL Server through XML. which can give me the idea how to interact with SQL Server through XML?

XML inside the database has too much (server-side) overhead to support transaction processing, it's mainly appropriate for batch/offline processing and infrequent bulk transfers (import/export) between different databases/products/systems. When XML is running in the SQLServer, the SQLServer will begin to get slower and slower as more and more concurrent users are added, so that all connected users (not just the most recent connections) receive miserable performance.

The alternative is to always interact with SQLServer using its high-speed binary ODBC interface (or one of its proprietary APIs). You can do that remotely from the iPhone using an SDK, or you can custom code a web-service that translates your own GET/PUT requests into ODBC/proprietary database calls (so that when you hit the tipping point, the most recent transactions will have to wait to get on the database, but the already connected users will not suddenly slow to a crawl trying to get their result set).

Hi all

Users of hosted Drake Tax Software always have the most up to date information about their data and files. By taking services from the Drake Tax Software host, users remain updated even if their work is spread across multiple locations.

All your comment for iphone development are welcome.

Thanks in advance.