Solved

Connecting a Visual Basic .Net program to an SQL Server over the internet

Posted on 2004-09-06
4
283 Views
Last Modified: 2010-04-23
Hello all.

I'm in charge of maintaining a program written in VB .Net. Currently it connects to an SQL Server 2000 database which resides on a server on our LAN.

Is it possible to allow the program to connect to the database via the internet? The server is connected to the internet and has a fixed ip address. Programming-wise, what are the changes needed?

Hope somebody can point me in the right direction.

Thanks.
0
Comment
Question by:sis5
4 Comments
 
LVL 37

Accepted Solution

by:
gregoryyoung earned 63 total points
ID: 11993510
I would highly not recommend doing this as it will open your database up to the world, instead I would use remoting to broker objects back to the client over the internet. This way you don't have to open your sql server up to the world ...  esp considerring the recent worms which have targetted sql server.

but if you insist upon doing it, all you would need to do is change the connection string change the server= to the ip address.
0
 
LVL 70

Assisted Solution

by:Éric Moreau
Éric Moreau earned 62 total points
ID: 11995119
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

837 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question