I am using SQL Server 2005. How can I retrieve data from live server through the Internet using VB.Net 2005?

Tags:
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?
ASKED: March 18, 2008  3:15 PM
UPDATED: March 18, 2008  5:48 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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 <a href=”http://www.connectionstrings.com/?carrier=sqlserver2005″>here</a>.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following