How do l connect 2 databases on 2 different pcs for access by 2 C# desktop apps on the different pcs?

Question

0.00/5 (No votes)

See more:

I am trying to use the distributed databases concept. I have 3 different C# windows forms applications, each on a PC. Each app is accompanied by a database respective to it. However, the 3 applications need to share some data which should be available to the others as soon as it is entered on one. How do l connect them such that even if one is off, there is no disruption to availability of data for the others. I am new to the concept of DDBMS

What I have tried:

I have tried to follow steps from some articles but l cannot get through. I actually need a step by step guide of instructions that l can practically implement.

Posted 5-Apr-22 7:43am

Royal Kusikwenyu

Updated 8-May-22 23:51pm

Maciej Los

v2

Add a Solution

Comments

Maciej Los 5-Apr-22 14:33pm

Not enough details!
1) Does all databases are placed on single PC?
2) What DBMS?
3) Does all databases are available in LAN/WAN?

Dave Kreskowiak 5-Apr-22 18:14pm

Without knowing anything about the database engine in use or the databases themselves, it's impossible to answer your question.

PIEBALDconsult 5-Apr-22 20:30pm

Any way you like.

Richard Deeming 6-Apr-22 3:50am

You need to use a server DBMS like SQL Server / Oracle / MariaDB / etc.

You will need a central server which all three PCs access. And that server needs to be on and running for your applications to access the database.

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)

Sni.DelWoods · Answer 1 · 2022-05-08T23:51:00

This is a classic client/server issue.
You have several application instances which use the same database.

This could be basically done with nearly all types of database.
If the chosen database (or DBMS) is a good choice depends on how intensive the database is used and how often data changes.

The safest choice is to a DBMS like SQL Server, MySQL or others (shoudl run on a 24/7 server).
The unsafe way is to use a desktop database like MS Access (or maybe SqLite, client access the database file via SMB share). I you can live with the fact that user could overwrite data and you have very little data writes that works (e.g. 5 Users work edit only their on records).

Under bad circumstances the database file could be corrupted. To minimize that risk you could set a flag on the record if a user opens the record for edit (IsLocked=true) and remove the flag if the record is saved (IsLocked=false). Beware not to run into a deadlock.

For futher information search for client-server-database or microsoft access client server application)