import pyodbc
import snap7
from snap7.util import *
# Create a connection to the PLC
plc = snap7.client.Client()
plc.connect('192.168.xxx.xxx', 0, 1)
# Read the value of MW10 & MW20
result = plc.read_area(snap7.types.Areas['MK'], 0, 10, 2)
result1 = plc.read_area(snap7.types.Areas['MK'], 0, 20, 2)
# Convert the result to a Python integer
mw10 = snap7.util.get_int(result, 0)
mw20 = snap7.util.get_int(result1, 0)
# Print the value of MW10
print(mw10)
print(mw20)
plc.disconnect()
# Connect to the database
conn = pyodbc.connect('Driver={SQL Server};'
'Server=YOUR SERVER NAME;'
'Database=DBNAME;'
'Trusted_Connection=yes;')
cursor = conn.cursor()
cursor.execute("INSERT INTO TABLENAME(column1, column2) VALUES (?, ?)", (mw10, mw20,))
conn.commit()
DON'T COPY BELOW LINES
FIRST INSTALL SNAP7 LIBRARY BY EXECUTING BELOW COMMAND IN 'CMD'
pip install python-snap7
IT IS TESTED SCRIPT....