rony2006 Posted September 12, 2017 Share Posted September 12, 2017 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? Link to comment Share on other sites More sharing options...
rony2006 Posted September 13, 2017 Author Share Posted September 13, 2017 Nobody? I really need some solutions/ideas about this. Link to comment Share on other sites More sharing options...
BigDaddyO Posted September 13, 2017 Share Posted September 13, 2017 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. Link to comment Share on other sites More sharing options...
rony2006 Posted September 13, 2017 Author Share Posted September 13, 2017 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? Link to comment Share on other sites More sharing options...
BigDaddyO Posted September 13, 2017 Share Posted September 13, 2017 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. Link to comment Share on other sites More sharing options...
jdelaney Posted September 13, 2017 Share Posted September 13, 2017 (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 September 13, 2017 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. Link to comment Share on other sites More sharing options...
junkew Posted September 14, 2017 Share Posted September 14, 2017 Looks like just a timestamp column you need and do on pc2 just a sql changed after timestamp query. Maybe better is to have a column processed yes/no The other PC's doing things are not relevant to have direct communication with. FAQ 31 How to click some elements, FAQ 40 Test automation with AutoIt, Multithreading CLR .NET Powershell CMDLets Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now