Well, if it was my database, and I had my business data in it, I wouldn't expose my SQL Server directly to the internet. So given that, I'd front the SQL server with either a web service or a remote object.
The SQLXML web service is a cool idea, and performs well in certain scenarios, but again - it's a scary proposition exposing your SQL server directly to the internet. Greg Reinacker Reinacker & Associates, Inc. http://www.rassoc.com http://www.rassoc.com/gregr/weblog/ -----Original Message----- From: The DOTNET list will be retired 7/1/02 [mailto:[EMAIL PROTECTED]] On Behalf Of Avi Nahir Sent: Saturday, June 08, 2002 7:33 AM To: [EMAIL PROTECTED] Subject: Repost: SQL Server over the Internet Hi all, I now understand how to use ADO.Net using a local database in my WinForm: I have a DataAdapter, DataSet, DataGrid etc. My question is: How do I scale up to an Internet scenario using SQL Server? I speak about Internet scenario meaning that it's not Intranet - my users are ordinary around the world users (i.e. no domains, Windows login etc). I understand I have the following options: 1. Set the IP address in the connection string. 2. Write a Web Service. 3. Use remoting. (http://www.dotnet247.com/247reference/a.aspx? u=http://www.csharphelp.com/archives/archive272.html) 4. Use SQLXML Web Service(http://groups.google.com/groups? q=ado.net+sql+server+internet&start=30&hl=en&lr=&selm=%23H%24urh8lBHA.18 52% 40tkmsftngp07&rnum=33) Any suggestions what to use? Tradeoffs? Good articles or books on the subject? thanks! You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
