pdering
asked on
Transferring data between computers using Access Database or Socket?
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.
* 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.
ASKER
If I use UDP broadcasting then I could need to open ports on the computers firewalls correct?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Can WCF queued messaging be installed completely programatically?
yes just follow the examples and host your service in your application....
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
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
Here is a link to help you:-
http://www.codeproject.com/Articles/326868/Send-receive-messages-in-LAN-with-broadcasting