How Can I Database From Another Project Using Local Or Lan Connection

Question

0.00/5 (No votes)

See more:

Hello friends,
I create windows application of C# .net and also create setup file.I install setup file for machine(1 and 2).In 1st machine i use database(like Employee).i want to use same database for 2 machine using LAN connection.
Is it possible i install setup in 2 machine but use database use only from 1st machine.
Please help me.plzz..m new here.

Thanks

Posted 28-Apr-15 10:53am

Member 10852141

Add a Solution

Comments

Sascha Lefèvre 28-Apr-15 16:56pm

Which type of database?

Member 10852141 29-Apr-15 9:15am

sql database.(db).please help

3 solutions

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)

Abu Khaleel · Accepted Answer · 2015-04-29T00:28:00

Solution 4

Data Source=Your distination IP,Your port;Network Library=DBMSSOCN;
Initial Catalog=Your Database Name;User ID=Your Username;Password=Your Password;

Example

Data Source=192.168.100.10,1433;Network Library=DBMSSOCN;
Initial Catalog=Employee;User ID=csharp;Password=csharp123;

Hope this will help you...

Posted 29-Apr-15 0:28am

Abu Khaleel

Comments

Member 10852141 29-Apr-15 7:17am

Sir,Its nt working.
i install setup file in 2 machine(1 and 2) both have database but i want to access database from machine 1 for machine 2.machine 2 database is not useful to us.
Sir,i means if i update data from machine 2 it automatic update database of machine 1 also.
please one example how we do it.we use lan connection because its windows application no internet connection available.
plz suggest me briefly

Abu Khaleel 30-Apr-15 14:26pm

Send us your database server name ie mysql or sql server etc. what connection or connection string are you using currently. your machine 1 username on which server is install and machine 2 on which you install the setup file. Beacuse in database server it is necessary to allow remote users.
we will try to find a fine solution for you.

Member 10852141 30-Apr-15 15:12pm

connetionString="Data Source=harshal-pc;Initial Catalog=School;
User ID=harsh;Password=Password"

machine 1 harshal machine 2 atul

Member 11061893 · Accepted Answer · 2015-04-28T20:48:00

Solution 1

yes it is possible u have to include the IP of that system in connection string instead of local server

Posted 28-Apr-15 20:48pm

Member 11061893

Comments

Member 10852141 29-Apr-15 5:26am

Sir,can u give me one simple example.how it work??
i install setup file in 2 machine but i want use only one database(db) using lan connection.plz.one example.how we will written in connection string

Member 11165734 · Accepted Answer · 2015-04-28T21:44:00

Solution 2

yep. Its possible. Use Connection string

Posted 28-Apr-15 21:44pm

Member 11165734

Updated 28-Apr-15 21:45pm

v2

Comments

Member 10852141 29-Apr-15 5:26am

Sir,can u give me one simple example.how it work??
i install setup file in 2 machine but i want use only one database(db) using lan connection.plz.one example.how we will written in connection string

mammu2787 29-Apr-15 7:24am

https://www.connectionstrings.com/sqlconnection/connect-via-an-ip-address/