plc.myforum.ro

maersk · Member 3 Joined: 17 Aug 2014 Posts: 891

How do you access an SQL database in WinCC Runtime Advanced using a script?
https://support.industry.siemens.com/cs/document/61883659/how-do-you-access-an-sql-database-in-wincc-runtime-advanced-using-a-script-?dti=0&lc=en-BR
SQL databases are accessed in WinCC Runtime Advanced by means of scripts, except when archiving tags or messages.

In order to access an SQL database, there must be a database created in the SQL server.
WinCC Runtime Advanced acts as an SQL client.

Note
An SQL database cannot be accessed from a Windows CE-based panel (a Comfort Panel, for example).

Requirements
SQL server1
SQL data source must be created in Windows 7.
WinCC Advanced ES or WinCC Professional ES
WinCC Runtime Advanced
1) The SQL server used must also be released for the operating systems (that are also released for WinCC Runtime Advanced).

https://support.industry.siemens.com/cs/attachments/61883659/61883659_WinCC_RuntimeAdv_access_SQL_via_script_DOCU_en.pdf
https://support.industry.siemens.com/cs/attachments/61883659/61883659_WinCC_RuntimeAdv_access_SQL_via_script_PROJ.zip

maersk · Member 3 Joined: 17 Aug 2014 Posts: 891

How do you log tags and messages with WinCC Advanced V11 in an SQL database?
https://support.industry.siemens.com/cs/document/61886098/how-do-you-log-tags-and-messages-with-wincc-advanced-v11-in-an-sql-database-?dti=0&lc=en-BR

https://support.industry.siemens.com/cs/attachments/61886098/61886098_WinCC_Adv_Archivierung_SQL_Datenbank_en.pdf
https://support.industry.siemens.com/cs/attachments/61886098/Project_2012-07-19.zip
The screens and downloads were created with WinCC Advanced V11 SP2.

gert · Member 3 Joined: 02 Jan 2015 Posts: 645

How do you access an SQL database in WinCC Runtime Advanced using a script?
https://support.industry.siemens.com/cs/document/61883659/
SQL databases are accessed in WinCC Runtime Advanced by means of scripts, except when archiving tags or messages.

To access an SQL database, it must have been created in the SQL server.
The WinCC Runtime Advanced functions as an SQL client.
Note
An SQL database cannot be accessed from a Windows CE-based panel (a Comfort Panel, for example).
Requirements
SQL server1), Microsoft SQL Server 2014, for example
SQL data source has been created
WinCC Advanced ES or WinCC Professional ES
WinCC Runtime Advanced V14 or higher
1) The SQL server used must also be released for the operating systems (that are also released for WinCC Runtime Advanced).

How to create a Microsoft SQL database is described in for V11 TIA
https://support.industry.siemens.com/cs/document/61886098/
https://support.industry.siemens.com/cs/attachments/61886098/61886098_WinCC_Adv_Archivierung_SQL_Datenbank_en.pdf
https://support.industry.siemens.com/cs/attachments/61886098/Project_2012-07-19.zip

Download
https://support.industry.siemens.com/cs/attachments/61883659/61883659_WinCC_RuntimeAdv_access_SQL_via_script_DOCU_en.pdf
https://support.industry.siemens.com/cs/attachments/61883659/61883659_WinCC_RuntimeAdv_access_SQL_via_script_PROJ.zip