#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2010
    Posts
    2
    Rep Power
    0

    Wink 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?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2005
    Posts
    340
    Rep Power
    48
    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/ip...p-service.html
    ColdFusion Ninja 4 Hire!
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2011
    Posts
    2
    Rep Power
    0

    Thumbs up RE: SQL Server iPhone Interaction


    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
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2011
    Posts
    15
    Rep Power
    0

    SQL Server Iphone interaction


    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?
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2011
    Posts
    2
    Rep Power
    0
    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).

    Originally Posted by wyandavidson
    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?
  10. #6
  11. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2011
    Posts
    15
    Rep Power
    0

    SQL server iphone intraction


    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.

IMN logo majestic logo threadwatch logo seochat tools logo