th1nker

The problem lies in Kepware's data logger for me. It only allows me to list a single table in SQL to log to. In order to log to another one, or even another database, we had to get an OPC DA driver which basically uses one OPC server to communicate to the PLCs and write to SQL, and another OPC DA server to monitor the tags from the first one, and log data to a second SQL server. We're still trying to get it working. We've tried numerous solutions, and each one has caused some kind of problems. For instance, when we had multiple instances of Kepware running with clone channels and devices, it caused communication issues on the main Kepware server pretty much as soon as we started runtime. OPC DA looks like the only way we can log to more than one mySQL server using Kepware without messing up any connections. I'll report back if/when we get OPC DA to properly work, just in case anybody has a similar issue in the future.

Thanks for the response! Unfortunately, I'm a coop student at a corporation and they already have standards up. It would be next to impossible for someone in my position to recommend PeakHMI to my superiors.

Hi guys, I was wondering if it is possible to have a single OPC server that logs data to two separate databases? I currently have Kepware communicating with a couple dozen PLCs and logging the data to MYSQL. I'm trying to find a way to log data to two separate databases so that one can be used to simulate and test changes. Originally, we had two instances of Kepware, each running from a unique computer, trying to communicate to each PLC, but the OMRON machines using the FINS Ethernet driver didn't like that and kept getting the "not responding" error on one of the instances of Kepware. With this in mind, I'm trying to find out what the best way to log data from each PLC to two separate databases. Any ideas? Thanks in advance for the help.

Hey guys, we have several servers running Kepware monitoring PLCs at several different divisions. Everything worked fine up until we connected a second instance of Kepware to one of our divisions so that we can test changes and simulate them without affecting our database. To clarify, the first instance of Kepware communicates with our database, the second instance of Kepware, which communicates with the same PLCs also communicates with a temporary database used to analyze changes. As soon as we would Start Runtime on the second Kepware, the first would lose connection to all the OMRON Plcs using the FINS Ethernet driver. Since OMRON uses UDP, I'm concerned that it isn't capable of communicating with two instances of Kepware. Do any of you know if it is possible and what a possible issue could be? Thanks for your time! Edit: Just some additional info, both instances of Kepware are running on separate machines, and the errors I got were "not responding" errors. Individually, both kepware instances worked perfectly, but one would always cause the other to stop working properly. I was just informed that were taking an alternate approach. I no longer need this information but do not know how to delete this thread =( Sorry.