Printable View
Thank for looking My Question !!
I have a question that is:
Our company Have a Wan network ( We Have the lease line) So Can anybody have know about that answer Me that Can I use Visual Basic connect to sql on the Wan network ? If The answer is OK so what about the speed ?
Thanks advance !
Yes you can connect to an SQL Server on the network by passing the IP address in :
The 4040 bit is the port number for the IP address. As for the speed, works like a charm - I've had no problems with my webservers connecting & you won't see a difference between a local or network SQL server.Code:"Provider=sqloledb; Data Source=255.255.225.0,4040; Network Library=DBMSSOCN; Initial Catalog=Database1; UID=UserName; pwd=Password"
Regards,
Alex