Page 1 of 1

Connection between s7 1200 and sql server

Posted: Sun Nov 20, 2016 5:09 am
by 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.

Re: Connection between s7 1200 and sql server

Posted: Tue Jan 09, 2018 12:23 pm
by 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.

Re: Connection between s7-1200 and sql server

Posted: Tue Jan 09, 2018 1:29 pm
by 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

Re: Connection between s7 1200 and sql server

Posted: Wed Jan 10, 2018 7:24 am
by 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

Re: Connection between s7 1200 and sql server

Posted: Wed Jan 10, 2018 10:33 am
by CoMod
https://www.mhj-tools.com/comdrvs7/
Download the demo version: Demo ComDrvS7 V6 (ZIP)
with many examples in english language.

Connecting a S7-1200 / S7-1500 to a SQL Database

Posted: Tue Jul 09, 2019 6:54 am
by Answers to FAQs
(sfaq) 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
Image