Solved

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

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

Assisted Solution

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Upating rows of DataTable for each Selected Item of a Listbox 3 38
Events in static methods 3 50
Getfiles in vb.net 28 42
Visual Studio 2013 Shortcut (VB) 4 33
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 …
If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

947 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

18 Experts available now in Live!

Get 1:1 Help Now