connect database into multiple computer

Question

0.00/5 (No votes)

See more:

i created one application in vb.net 2005 and database is sql.
i want to connect a database into multiple computer and i want to insert a data into multiple computer then how its possible?? please give me solution with example.

Posted 28-Mar-12 2:52am

pradip rupareliya

Updated 28-Mar-12 3:13am

Richard MacCutchan

v2

Add a Solution

Comments

Thilina Chandima 28-Mar-12 9:12am

Please explain your problem in detail manner because I can't understand the real problem. what do you mean by this "i want to connect a database into multiple computer"

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bernhard Hiller · Answer 1 · 2012-03-28T03:09:00

Solution 1

The database stays on one computer, the "server". The other computers ("clients") connect to the database on the server.
In the connection string for the database connection, make sure to use the server's name or IP address. Also make sure to configure the SQL Server to accept connections from other computers than localhost, and check the firewall settings.

Posted 28-Mar-12 3:09am

Bernhard Hiller

Comments

Maciej Los 28-Mar-12 10:19am

My 5- Why? The answer is not optimal. Now, with link to MS support, where OP can read how to configure ms sql server 2005, is optimal.