plcforum.uz.ua

International PLC Forum
It is currently Sat Jan 20, 2018 9:55 pm

All times are UTC + 3 hours


Forum rules


Please click here to view the forum rules



Post new topic Reply to topic  [ 5 posts ] 
Author Message
PostPosted: Sun Nov 20, 2016 8:09 am 

Joined: Sun Nov 20, 2016 6:19 am
Posts: 1
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.


Top
 Profile  
 
PostPosted: Tue Jan 09, 2018 3:23 pm 

Joined: Wed Dec 16, 2015 11:17 pm
Posts: 16
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.


Top
 Profile  
 
PostPosted: Tue Jan 09, 2018 4:29 pm 
Site Admin

Joined: Thu Feb 16, 2006 6:25 pm
Posts: 3119
Location: Russia
Connection between s7-1200 and sql server via "User program" ?
OPC
https://support.industry.siemens.com/cs/document/38051469/with-wincc-how-can-you-access-tags-of-the-s7-1200-and-the-s7-1500-controllers
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


Top
 Profile  
 
PostPosted: Wed Jan 10, 2018 10:24 am 

Joined: Wed Dec 16, 2015 11:17 pm
Posts: 16
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


Top
 Profile  
 
PostPosted: Wed Jan 10, 2018 1:33 pm 
Site Admin

Joined: Thu Feb 16, 2006 6:25 pm
Posts: 3119
Location: Russia
https://www.mhj-tools.com/comdrvs7/
Download the demo version: Demo ComDrvS7 V6 (ZIP)
with many examples in english language.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC + 3 hours


Who is online

Users browsing this forum: Alex22, Google [Bot], smedly_w and 17 guests


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

Search for:
Jump to:  
Powered by International PLCforum® Forum Software © PLCforum
Mobile version