Solved

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

Posted on 2004-09-06
4
277 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
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…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

813 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now