gclshortt

Modbus TCP Data Logging to Database

3 posts in this topic

Here is a recent post that I would like to share.

Using Visual Basic 2015 we will log three holding registers from the PLC along with time and date into a Microsoft Access Database. We will log every minute into the database with the information that we collect from the PLC via Modbus TCP (Ethernet). All code will be done and shown so you can implement this in your application with different parameters. The information collected in the database can then be distributed or analyzed in the future.

Visual Basic 2015 will be used with the EasyModbusTCP client/server library for .net. We will communicate to an Automation Direct – Do-More PLC. Using the free simulation software of the PLC Designer Software, we will retrieve three values of the Modbus Holding Registers using Modbus TCP. Once we have this information out of the programmable logic controller it will be placed in a Microsoft Access (2010) Database. This will be done by using a SQL command to insert the data.

Read the rest of the post...

Let me know what you think,
Thank you

Garry

http://accautomation.ca/

ModbusTCP MSAccess 010-min.png

ModbusTCP MSAccess 080-min.png

Share this post


Link to post
Share on other sites

Looks like a lot of work with many parts why not use an HMI which already has Database Connectivity.

Share this post


Link to post
Share on other sites

I think that for datalogging to Access (or for that matter a full SQL database application server) this looks good. I agree with Gambit that general datalogging in the HMI is OK, but for applications without HMI's or HMI's without direct database connectivity this looks nice.

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