Can any one suggest me the best way to connect to a remote SQL server using
the internet.
The option that I know is: Use of remote IP address to connect. Is there any
other options availabe to access the SQL server like using ASP pages or some
thing else. ?
I want to ensure that the connection is stable and the speed is good.
If you can suggest me any site where I can look for optimising SQL Server on
the internet, it would be useful.
FYI - I am using VB as the Front End.
Thanks and Regards,
PeriHey Peri,
I have used SQL Server 2000 with Visual Basic 6.0, Visual Basic.Net and ASP.
Net. All you really have to do is when you use for example an ADO connection
, pass the server's ip instead of its name. If it is located with your netwo
rk you can use the servers
name. You don't really need any special settings on the server. Just make su
re it has a public ip and no firewall is blocking any ports. There is a port
that SQL uses but I am not totally sure which one it is. ]
Danny Cabrera
dcabrera@.medstarholdings.com
System Programmer
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment