Connecting to MS SQL 2005 from iPhone App

[raziiq]

Hi there.

i have a MS SQL database on the DiscountASP.net. I was wondering is there anyway i can access my MS SQL database through Xcode (Objective C) in an iPhone app?

[Chuck]

Do you have an ODBC provider available to you? If so then yes. You will want to check the documentation of your IPHONE software stack.

[raziiq]

Thanks for the reply, i searched the internet and got to know that i can access that database from iphone app using webservices. I can create a webservice but dont know how to host that on DiscountAsp.net, is there any tutorial on how to do that?

[wisemx]

I don't have an iPhone but the on-line SQL Server tool DASP provides does work from my Motorola Droid x2.

[Chuck]

Thats the good news, you would deploy it just as you would any other standard asp.net application.