WINCC - SQL instructions

Join Date
Apr 2003
Location
Belgium
Posts
434
Hi folks,

I'm using wonderware for several years and I must say that it works
OK. Now I switched companies so I also had to switch from
wonderware(intouch) to wincc.
With intouch you could use standard SQL instructions en connect
easely to a (industrial)SQL-database. Is this also possible with
wincc? Is it build in or do I need to buy somekind of an add-in?

Rudi Frederix
 
Well, WinCC supports VBA/VBScript, so you can use ADO to connect up to any Native (ADO) driver or ODBC Driver database... SQL Server, Oracle, (SyBase is Native to WinCC), MySQL, etc.

For simple demo scripts, take a look at
http://www.wincc.net/


Actually, thinking about WonderWare's InSQL (If that is the intermediary) and the WonderWare SQL Script extensions, you do have a bit of a learning curve if you haven't used ADO before.

It's really not all that hard though, just confusing. Note that if you do go the VBS/VBA approach, be sure, be sure, be sure to use ADO (ActiveX Data Objects) and not RDO or VBSQL. I'm serious. VBSQL is very annoying (and old), RDO you cannot legally use unless you have one of Microsofts Enterprise Developer Studio Licenses, and both RDO and VBSQL have some very nasty evil things hiding in the code if you aren't careful. ADO is much much smoother.

There is an excellent book from Microsoft Press on interfacing Visual Basic 6.0 to SQL Server, though I can't think of the name or author right now :(
 
Last edited:

Similar Topics

Hello all! I have a problem with data logging from winCC to SQL server. I am trying to write a single variable type "Real" to SQL server. The...
Replies
9
Views
2,645
I'm little stucked and ask for small help from one with little more experience of vb script. So, I have alarm control window Control1[Alarm...
Replies
3
Views
1,470
Hi all, I'm trying to connect WinCC Pro to SQL server through OBDC. Everything is okie, I'm able to transfer number, DateTime and even a direct...
Replies
2
Views
1,435
I am new to WinCC and have limited experience with SQL servers and databases, but I have been presented with a problem with the overwriting of...
Replies
1
Views
1,286
Kindly, while trying to install Siemens Pcs7 Wincc v6, we got a message that "SQL Server 2000 Service Pack 3a" need to be installed from a CD...
Replies
0
Views
1,327
Back
Top Bottom