Solved

Transferring data between computers using Access Database or Socket?

Posted on 2012-03-22
6
265 Views
Last Modified: 2014-11-12
I need to transfer data between 20 computers on a LAN.  The data consists of about 500 characters and each computer "sends" the data about once every minute to various other computers on the LAN.  I'm thinking about doing it using an Access database in this way:

* Each user checks a table in a central database frequently.
* If one computer wants to send data to another, he puts data in the other user's table.
* When a user finds data in his table he uses it.

Will using this method with 20 computers all on a local LAN be ok?  Or would that cause any lag?

I realize I could use socket programming for this, but, for reasons not worth going into, I don't want to change any firewall settings on any of the computers.
0
Comment
Question by:pdering
  • 3
  • 2
6 Comments
 
LVL 20

Expert Comment

by:BuggyCoder
ID: 37754407
no need to use database here, its simple broadcasting a message on lan.
Here is a link to help you:-
http://www.codeproject.com/Articles/326868/Send-receive-messages-in-LAN-with-broadcasting
0
 

Author Comment

by:pdering
ID: 37754679
If I use  UDP broadcasting then I could need to open ports on the computers firewalls correct?
0
 
LVL 20

Accepted Solution

by:
BuggyCoder earned 500 total points
ID: 37754689
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:pdering
ID: 37755090
Can WCF queued messaging be installed completely programatically?
0
 
LVL 20

Expert Comment

by:BuggyCoder
ID: 37755802
yes just follow the examples and host your service in your application....
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 37756361
Or why not Amazon Simple Queue Service

Amazon Simple Queue Service (Amazon SQS):
http://aws.amazon.com/sqs/

AWS SDK for .NET here:
http://aws.amazon.com/sdkfornet/

It will probably be free to use for you and will, of course, work from any location with Internet access.

/gustav
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now