First off, thank you all very much for your suggestions, I'm amazed at how quickly you got back to me. Now, to answer some of your questions to help you help me.
>Help me understand which way data is going between the database and the PLC. Do you know which direction the data transfer is failing ?
Data is going in both directions, the PLC reads and writes data to the database. And from what we can tell the majority of the dropped packets are when the PLC logic writes information to the database, however, less frequently we sometimes have a small problem with database reads on the PLC.
>What kind of driver is the database using to interface to the PLC-5?
Homebrew by our vendor, and they're saying "Until you clean up your network, we refuse to look at our software as the potential source for the problem" (basically turning this into a support ****ing match). I'd hopefully like to try everyone's suggestions so I can place it back in their laps.
>How can you tell that the ethernet interface is "dropping packets and not re-transmitting them"?
I use Network Solutions "Sniffer" software to sniff out dropped/runt packets, connection errors, transport errors, etc.
>Is the ethernet onboard the PLC 5, or is it a module of its own, mounted to the right side, in the rack/chassis?
It's the onboard AUI connector with an AUI to 10Bt tranceiver (which has been replaced multiple times).
>Also, check to make sure the rack/chassis is properly grounded.There is a threaded stud on the far right side.
Engineers are looking at that as we speak, I will update you when I hear from them. I asked them to check all grounding.
>Make sure that your routing uses smart switching and not just hubs.
>Last thing, 80% of all problems on networks are caused by a poor
connection, runs that are too long or too noisy, in other words
related to the physical medium.
The building and all the equipment is less the 6 months old. Our network core is two Cisco Catalyst 6509's connected to multiple Cisco Catalyst 2948xl's via redundant gigabit fiber. The entire network was certified by Krone (our cable vendor) for Catagory 6 less then 6 months ago. All of the equipment in question is isolated on a Layer 3 switched VLan. This is why I am having a hard time believeing this is a network issue. But the vendor is saying dropped packets are indicative of a poor network (again, the support ****ing match).
I am currently looking into some of the solutions you have provided me with. My next step is to sniff out the network and send the data to one of our head network engineers to pick apart, he might see something I don't. I do appreciate all your suggestions as I think the vendor is "picking on me" because of my limited to non-existant PLC knowledge, and ever little bit of information I get from you and try is one more thing I can say "I checked that..." to.
As I find more information I will post in here. Once again, thank you for all your help.
Bradley D. Walter