save into server

[visualhome2005]

i have two computers network connected....one is com1 and other is com2...
i m using com1..if i save then i want to store in only in com2..and when i open from another computer the database frm com2 should be displayed from com1...

 Dim cn As New SqlConnection("server=localhost;database=attendance1;uid=sa;password=;")

i think just the declaration would do that...but i m not doint that...can anyone help me..thanks

[mickey_pt]

I really doesn't understand what you're saying?!

[visualhome2005]

i m using com1...if i use program from com2 then i dn get the record saved from com1...

[jmcilhinney]

As the name suggests, when you specify "localhost" as the server you are referring to the local machine. If you want to refer to a SQL Server instance on a different machine then you have to specify the name of that machine as the server in h the connection string.

[mickey_pt]

You're saying that you'll have an application in several machines, and when you save the data in one of them, that data will be available for everyone?

If it's that, the connection string can't be refered as localhost, it must be something like this:

Data Source=IP\SQLINSTANCENAME;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;