Need Ideas

micky

Lifetime Supporting Member
Join Date
Aug 2003
Location
DeRidder, La
Posts
83
I have an application where we have a truck loading program written in Visual Basic. The truck loading program issues a permissive to a Reliance plc on whether it is OK for the truck to load or not, the permissive is used for the loading pumps, etc. We are in the process of changing out the reliance to GE 90-30, and are looking for ways for the VB program to read/write the permissive as in the old reliance. We also are using Intouch 9.5 as the SCADA system, if there any ideas as to maybe using Intouch as a go between. I came across this product but don’t know how well it will work http://www.ingeardrivers.com/ge_activex/ge_activex.htm
 
The ActiveX control will work and allow you to write the data directly from the VB app into the memory of the 90-30. If this is acceptable, you should only have to modify the VB app to point to the memory location that you want to change. Is the Wonderware also hitting the 90-30? If it is, are you talking via Ethernet or RS485? If you are using Ethernet, two devices hitting the port should not be a problem. If you are talking RS485, then two devices on the same network and timing may be an issue.

If this is the case, a cleaner solution would be to setup a small SQL DB table that the VB app and the Wonderware can hit. Then, using SQL instructions with InTouch, you could check the table and when the VB app sets the bit or writes the word that says everything is OK, Intouch would set the appropriate bit in the PLC.

Hopefully, you will be talking Ethernet and the ActiveX control will work for you. I would be a lot less code.

Regards
 
If I go the SQL route would there be any problems if I poll the database every second. If there are no problems going this way it'll be alot cheaper than going with the ActiveX control.

Intouch and the PLC are communicating over ethernet.
 
It should not be a problem to hit the SQL DB every second, especially if the InTouch and VB app reside on the same PC or server. Going this route will require much more code, though. Not only will you have to program the InTouch app to hit the DB with SQL statements, you will also need to be able to use ADO or ADO.net, depending on the version of VB you are using.. Not to mention, you will also have to configure the SQL DB table.

If you already have the VB 6.0 or VB.net and the SQL DB, it would be cheaper than the ActiveX control, but it is a task that will take some time and effort. The quickest, easiest way out is to spend the money and get the VB ActiveX.Control.

Good Luck
 
My experience with Access is that it would be a bad idea. Access just isn't optimized for speed like SQL Server is and if you are connecting to the data base remotely, you could have even worse perfomance. The good thing is that the DB table would not be very large, so you could write the code and build the Access DB and give it a try. With ADO or ADO.net, switching to a SQL DB after the code has already been written would be relatively easy as long as you have designed both data bases properly. In fact, it may be as simple as changing your connection string in VB, depending upon how you write the code and develop both data bases. I still like you ActiveX idea!
 
OK thanks for the suggestions 🍻, I will probaly go the ActiveX route beacuase of ease and the time saved programming will pay for cost of activex.
 

Similar Topics

Hi all. I am writing a program in RS Logix 5000. I have 8 pieces of support equipment that are exactly the same. They supply high pressure water...
Replies
4
Views
1,763
hi! Background on me: Self learned programmer mostly on LOGO, s7-1200, regular HMIs and WinCC Flexible 2008 Runtime. Only smaller projects. The...
Replies
20
Views
4,185
Need some ideas as to how to do a "for each" loop to check what box is measured. Hello, I need some help in understanding the appropriate...
Replies
4
Views
3,943
Hey fellas, I'm looking for ideas. I've been asked to look into creating a system that will measure the length of panels cut by our flying cut...
Replies
14
Views
6,926
Hi all I'm after some ideas for some new PLC projects. We are running S5 95U and S7 313C plcs. I have classes doing everything from basic PLC's...
Replies
12
Views
8,876
Back
Top Bottom