rony2006

Communication between 2 PCs

7 posts in this topic

Hello,

Now for communication between 2 PCs (same network) I use something like this:

PC 1 is writing data to a SQL server using Autoit and a sql udf

PC 2 is checking each 1 second if there is some new data in the sql table and if there is new data is showing it in a list. After a while from PC 2 i need to update the data in the database.

 

 

 

Is this a efficient way to make 2 computers to communicate between them? Can I improve this and how?

Share this post


Link to post
Share on other sites



Nobody? I really need some solutions/ideas about this.

Share this post


Link to post
Share on other sites

You can look into the TCPStartup, and other TCP functions in the help file.  I believe that will do what you want.  I had looked into it at one point, but just opted to use an ini file on a network drive since I wasn't sharing too much information.


Share this post


Link to post
Share on other sites

The problem is that from multiple computers I send and store data to a mysql server. Then I have another computer that checks 1 time per x seconds if there is a new entry in the database and what is that new entry.

Is not something like client-server to be able to use TCP. 

What is the best way to accomplish this?

Share this post


Link to post
Share on other sites

Sounds like that computer that checks 1 time per x seconds would be setup as the TCP server/listener and the other computers would simple connect and send to it when needed, thus it would no longer check and instead will simply wait for info to be sent in.

 

If that's not going to work for you, then you will have to either stick with the Database, or setup a file on a shared drive.

 

 


Share this post


Link to post
Share on other sites

#6 ·  Posted (edited)

You can also create a network directory where the server side looks for a file, and the client side populates a file.  Then do what you need to do, and clean out the file (from the server side).

Edited by jdelaney

IEbyXPATH-Grab IE DOM objects by XPATH IEscriptRecord-Makings of an IE script recorder ExcelFromXML-Create Excel docs without excel installed GetAllWindowControls-Output all control data on a given window.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now