Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Reading/Writting to SQL DataBase from WinCC V11

Created by: Sardar99 at: 1/5/2012 10:00 AM (5 Replies)

Rating (4)

Thanks 8

6 Entries

1/5/2012 10:00 AM	Rate (0)
Sardar99 Posts: 13 Rating: (0)	Dear Zein Could you tell me, How and Where I can insert, update, delete ...etc, I mean writing quires to SQL database tables from TIA Portal Wincc professional V11, I have tried in Rciepe but in Recipes just put the data in CSV files not SQL database files, also in Recipe can not put data by ODBC, do you have any suggestion, or could you send me a sample project of reading & writing SQL database from Wincc Professional V11 ? best regards
Sardar99 Posts: 13 Rating: (0)	Last edited by: CS Moderator at: 1/5/2012 10:41 PM new subject after splitting /tf/WW/en/Posts/56540#top
Suggestion To thank Quote Answer

1/5/2012 3:16 PM	Rate (4)
Zein Bronze Member Joined: 5/27/2009 Last visit: 2/11/2025 Posts: 122 Rating: (8)	Hi, when i worked with Data Base Connections i did it with WinCC V7.0 SP1 using Visual Basic Scripts i haven't used the WinCC version you told me i don't know if there ir also an Option for making scripts. But anyway i send u an example. Attachment ScriptBD.zip (2527 Downloads)

Suggestion To thank Quote Answer
This contribution was helpful to 7 thankful Users billwest playerslight gbs GarryT MrPaiva tamnk AutoGen_3305849

5/24/2012 6:03 PM	Rate (0)
prado911 Posts: 1 Rating: (0)	Hi!!! Do you speak spanish ¿? I see your example in this thread, and a see some parameters in spanish I need to do someting like you do. You can help me ¿? Thx Muchas gracias
prado911 Posts: 1 Rating: (0)
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users playerslight

5/25/2012 10:28 AM	Rate (0)
Tweety Posts: 3037 Rating: (192)	Hello, You can use this tool in the following FAQto export archiv data to a csv file. Export of WinCC / CAS Archive Data using the WinCC OLE DB Provider Tweety
Tweety Posts: 3037 Rating: (192)
Suggestion To thank Quote Answer

10/11/2013 11:26 PM	Rate (0)
gesasaes Regular Member Joined: 9/9/2011 Last visit: 11/11/2024 Posts: 2 Rating: (0)	Hi , you can see this SIEMENS example ,it's very useful for reading and writing database from wincc v11 . https://support.automation.siemens.com/WW/llisapi.dll?func=cslib.csinfo&objId=55018679&nodeid0=28919804&load=content&lang=es&siteid=cseus&aktprim=0&objaction=csview&extranet=standard&viewreg=WW

Suggestion To thank Quote Answer

1/28/2021 1:40 PM	Rate (0)
lesther roque Experienced Member Joined: 8/18/2014 Last visit: 2/13/2025 Posts: 59 Rating: (0)	I hope it will work. Thanks

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Related topics by keywords:

TIA WinCC Prof System functions/Scripting

Follow us on