RATE THIS ANSWER
0
Click to Vote:
- 0
0
Last Answered:
Mar 18 2008 5:48 PM GMT
by Mrdenny
You can create a website with VB.Net and then pull information from your database by specifying your DB server in the connection string.
You will find an example of how to do this
here.
Hope this helps,
Joelle
In addition you will also need to have the firewall opened to allow connections to the database. Most hosting providers won't like to do this as it is a very large security hole to allow direct access to a SQL Server from the Internet. A more secure method would be to create a web service on a web server running behind the firewall. That web service would then log into the database. Your .NET application could then connect to the web service over HTTPS and pass in the request which the web service could then handle and return the data to you.
Using a web service is a little more complex of a solution than just connecting directly to the database, but it is a much more scalable and secure solution.
SQL Server 2005, VB.NET 2005, Visual Basic 2005
I am using SQL Server 2005. How can I retrieve data from live server through the Internet using VB.Net 2005? 
