Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

WinCC and SQL stored procedures

Created by: Darius at: 1/4/2006 10:11 PM (2 Replies)

Rating (1)

Thanks 0

3 Entries

1/4/2006 10:11 PM	Rate (0)
Darius Platinum Member Joined: 9/28/2005 Last visit: 12/3/2024 Posts: 2957 Rating: (243)	Hello, Is there any chance to execute SQL stored procedure from WinCC C ar VB script? Best regards, Darius
	Best regards, Darius
Suggestion To thank Quote Answer

1/5/2006 10:03 AM	Rate (1)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)	Sure. You are best off using a VBS script and use ADO (ActiveX Data Objects) functions to connect to your database and run your stored procedure. If you have not used ADO before then there is masses of information on the internet. There is also a simple example of database access in the WinCC manual. Just do a search for ADO. Regards, Salma

Suggestion To thank Quote Answer

1/23/2006 5:33 PM	Rate (0)
Reuben Posts: 70 Rating: (13)	Hi Here are example PDL files that implement ADO database queries. This one uses C-Script: http://www.allottware.co.za/raweb.dll/Picture?p=ActiveX&x=ActiveX_ADO This one uses VB-script: http://www.allottware.co.za/raweb.dll/Picture?p=ActiveX&x=ADO_VB To call a stored procedure simply replace the "SELECT" statment with "EXECUTE <storedprocedure> [parameters]". Reuben
Reuben Posts: 70 Rating: (13)
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on