Can we access MS SQL 2005 from the website ...
-
Hi there! I am hosting my website on a web-host which gives support for ASP.NET. But I don't have a MS SQL2005 resource in that account.... I have a MS SQL DB hosted on another server. Can I somehow get data from this MS SQL server...... Thank you.
-
Hi there! I am hosting my website on a web-host which gives support for ASP.NET. But I don't have a MS SQL2005 resource in that account.... I have a MS SQL DB hosted on another server. Can I somehow get data from this MS SQL server...... Thank you.
Just point your connection string to the server on the network. People do this all the time. I wrote an article about setting up asp.net on .net 2.0 to point to different sql servers in different environments. http://www.codeproject.com/useritems/SingleWebConfigFile.asp[^] Anyway, you can see some examples of connection strings there. Hope that helps. Ben