About Boster Sibande Expertise I can answer questions in the following areas: ASP.Net, VB.Net, C#.Net, Microsoft Access and SQL Server. These are the technologies I use in my day-to-day work. As such, I am very confident and happy to assist
Experience I have two years experience with ASP.Net
Organizations UNDP
Education/Credentials Currently studying MSc. in IT
Expert: Boster Sibande Date: 1/11/2007 Subject: Setting up client / server VB.net application & SQL Server
Question Hi,
I'm new to vb.net & asp.net but am very experienced in vb6 & classic asp. I've also done many tutorials with VB.net & ASP.net. I'd like to learn how to set up a VB.net application with SQL Server installed on a seperate computer from the VB.net client application. Is there any demonstration client/server projects on the web that could walk me through this? My web host is too expensive to set up a SQL Database on it so I'd like to do it on one of my home computers.
Thanks in advance
Jeff
Answer What you need to do is change the server name in the connection string, add a port number and include "Network Library=dbmssocn"
For example using ADO.Net OleDB you can create a connection as follows:
Dim dbconn as OleDbConnection
dbconn = New OleDbConnection("Network Library=dbmssocn;Provider=sqloledb;server=xxx.xxx.xxx.xxx,1433;uid=myname;pwd=mypass;database=northwind")
dbconn.Open()
Where xxx.xxx.xxx.xxx is your home computer's IP address.
Of course you have to open the SQL server TCP/IP ports to the internet on your DB server.
