Connecting a Visual Basic .Net program to an SQL Server over the internet
Posted on 2004-09-06
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.