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

[netrapalg]

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

 

[Cromulent]

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

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.

 

[Alkiera]

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.