 |
plc.myforum.ro
PLCs users www.plc.myforum.ro!
|
| View previous topic :: View next topic |
| Author |
Message |
valz
Member 3
Joined: 26 Jul 2015
Posts: 771
|
 Posted: 10/11/2022 18:11 Post subject: Connecting a S7-1200 PLC / S7-1500 PLC to a SQL Database |
 |
|
Connecting a S7-1200 PLC / S7-1500 PLC to a SQL Database
https://support.industry.siemens.com/cs/document/109779336/
The Tabular Data Stream protocol (TDS) gives you the ability to establish a direct connection with a Microsoft SQL server. Using TDS, you can log in to an SQL server database and transmit SQL instructions. In this way it is possible to read data from the database, or send them to the database for storage.
Based on the "Open User Communication blocks" (TCON, TSEND, TRCV and TDISCON), S7-1500 PLCs and S7-1200 PLCs can emulate the TDS protocol and establish a connection to a Microsoft SQL server. By using the SQL statements "insert into", "update" and "select" you can store data in the database, update and read data from the database.
Downloads
https://support.industry.siemens.com/cs/attachments/109779336/109779336_SQL_DOC_en_V31.pdf
Project for TIA Portal V17
https://support.industry.siemens.com/cs/attachments/109779336/109779336_LSQL_CODE_V31.zip
Library for TIA Portal V17
https://support.industry.siemens.com/cs/attachments/109779336/109779336_LSQL_LIBRARY_V31.zip
Sources for TIA Portal V15.1 and V16
https://support.industry.siemens.com/cs/attachments/109779336/109779336_LSQL_SOURCES_V31.zip |
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
Fa-ti si tu propriul forum GRATUIT, pe www.myforum.ro |
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
