By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,333 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,333 IT Pros & Developers. It's quick & easy.

How to use a sql server database on LAN network using VB 2008

P: 11
Hi, could anyone help me....

I've already installed VB and sql server express 2008. I've created a database in the sql server and connected the database to VB project which works fine. My problem is... how to use this VB project on a LAN network. If I complete the project using the database which is on my hard drive, how Could I build this project and put it on the network, so as other users using the project to update the database.

Pls guide or refer me to any site where I could continue working on the project.
Jul 13 '12 #1
Share this Question
Share on Google+
6 Replies


PsychoCoder
Expert Mod 100+
P: 465
Going that route I would check out SQL Compact. You can embed the database into your application.
Jul 13 '12 #2

P: 11
Thanks bro for replying but how the can each user connected to that project and update the database. I've copied the database to the folder and share the project folder on the LAN... the forms are load but not the data from the database. One main thng I've installed sql server only on my pc and not on others....
Jul 13 '12 #3

PsychoCoder
Expert Mod 100+
P: 465
If you're wanting multiple users to connect to the same DB then you're going to need a hosted SQL database
Jul 14 '12 #4

P: 11
How to use a hosted SQl Database on a LAN Network????
Jul 14 '12 #5

P: 75
use your connection string and set the right hosted, hmm.

Data Source=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;

just like that if im not mistaken .
Jul 15 '12 #6

P: 11
I've done as u said, when I ran it from my computer it works but after building the project. I launched the Vb Application on another computer found on the network, the connection string failed to response. my connection string is like that:
Dim connetionString As String
Dim cnn As SqlConnection
connetionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\DBMS_DataS ource\DBMS_Database.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
cnn = New SqlConnection(connetionString)
Try
cnn.Open()
MsgBox("Connection Open ! ")
cnn.Close()
Catch ex As Exception
MsgBox("Can not open connection ! ")
End Try

The question is how other computers on the network will locate my computer database location???

Pls any suggestion....
Jul 15 '12 #7

Post your reply

Sign in to post your reply or Sign up for a free account.