Connect iphone to MS SQL Server 2000

[reydan]

Hi,

First of all, I'm not very good with web technologies and databases (I have some general knowledge) so you should explain stuff in a "... for dummies" style . Here's what I have and what I need:

I'm making an iphone application that needs to connect to the client's database and display some info/images from the server.

The database is MS SQL 2000 and I also have ASP.NET available on the server.

How should I approach the problem? I found 2 solutions:
1. Use a SQL library inside the iphone app and connect directly to the database
2. Use a server-side component written in ASP.NET that would act as a proxy between my application and the SQL database. I've read around and saw I could use JSON as a protocol to exchange data between my app and the server-side proxy. Also, connecting and using the SQL database would be much easier in ASP (or at least I think so).

If you have any other solutions please feel free to share.
Personally I like the solution with the server-side proxy.

There is another thing to mention. The users will have to enter a username/password to connect to the database so the solution would have to be somewhat secure.

Thanks for any help

[smithdale87]

the best way would be to use a webservice to do all your database comm, then just have the iphone interact with the webservice

Edit: IMO of course.

[reydan]

Thanks,

Any hints on how I would implement the authentication through the web service?

[smithdale87]

what kind of authentication

[reydan]

The users must enter a username/password in the iphone application in order to have access to the database.

[smithdale87]

You can just send the username/pw to the webservice, authenticate on the serverside, and send back a response to the iphone.

[rajugaddam]

Hi,

I am install the xcode in my windows xp via VMware workstation(snow.IOS) how to connect xcode to sqlserver 2008 in xp.can you just provide the detalis for connection


thanks,
raj