Connection between s7 1200 and sql server

[shakil385]

Hello dear, I need to connect my PLC s7 1200 with sql database to get plc tags value bt i
cannot convert them on datablock and even facing problems to configure sql block.
Can anybody give me sample program.

[aliuta2000]

Hello,
i am aslo new in this area for connection between PLC and SQL server.
I have succeded to Instal and to configure Microsoft SQL 2014 express.I havecreated succesfull databes and table inside.
If there is somebody with experince to give an TIA V 13/ V14 example of connection , will be greate .

Thank you in advance.

[CoMod]

Connection between s7-1200 and sql server via "User program" ?
OPC
https://support.industry.siemens.com/cs ... ontrollers
or direct acess to s7-1200/s7-1500/s7-300/s7-400 via Profinet https://www.mhj-tools.com/comdrvs7/
https://www.youtube.com/watch?v=o7BKYhf3Sys

[aliuta2000]

Yes, i am curious if there is any chance for direct connection S71200/1500/S7-300/400 to a server for reading /writting to DB .

i have seen it is possible via WinCC, are few examples, but i have senn some movies where are direct connection to a DB.

Is more interesting direct connection.
If you/ somebody else have some example, this i am intereste to learn.
Thank you in advance

[CoMod]

https://www.mhj-tools.com/comdrvs7/
Download the demo version: Demo ComDrvS7 V6 (ZIP)
with many examples in english language.

[Answers to FAQs]

https://support.industry.siemens.com/cs ... /109779336
Connecting a S7-1200 / S7-1500 to a SQL Database

Code: Select all

https://support.industry.siemens.com/cs/document/109779336/connecting-a-s7-1200-s7-1500-to-a-sql-database