How to access the SQL Server2005 data on Mac OS using webservices in Objective C

Discussion in 'Mac Programming' started by netrapalg, Mar 25, 2010.

  1. netrapalg macrumors newbie

    Joined:
    Dec 14, 2009
    #1
    Hi Everybody,
    I want to access the MSSQL DB through objective C.nowadays I dont have any option to connect the MSSQL Database. So I want to know that can i use the Webservices to access the MSSQL Database in objective C.
    Plz reply, its very helpful to me.


    Regards
    Netra Pal
     
  2. Cromulent macrumors 603

    Cromulent

    Joined:
    Oct 2, 2006
    Location:
    The Land of Hope and Glory
    #2
    Sure. If you have a web service running on the server that already access the database you just need to make sure that it exposes the functionality you need and then the web service can act as an intermediary for you.

    Obviously using a web service to access the database is going to be several orders of magnitude slower than doing it directly so make sure that you do not use it as your only method of communication. Plus you'll also need to take into account the security of the transmitted data, meaning you'll probably want to use an SSL certificate.

    You could also just use the UNIX ODBC driver to access it as well if you would rather go with a more traditional method.
     
  3. Alkiera macrumors regular

    Joined:
    Mar 11, 2008
    #3
    The 4th link in google search pointed to another person asking this, who got a reply to check out http://www.freetds.org/ I've used that library in the past to access ms SQL server from odd environments, like PERL; so I can vouch for it. It's more C than Obj-C, but should work just fine.
     

Share This Page