You are not registered yet. Please click here to register!


 
 
plc storereviewsdownloads
This board is for PLC Related Q&A ONLY. Please DON'T use it for advertising, etc.
 
Try our online PLC Simulator- FREE.  Click here now to try it.

New Here? Please read this important info!!!


Go Back   PLCS.net - Interactive Q & A > PLCS.net - Interactive Q & A > LIVE PLC Questions And Answers

Reply
 
Thread Tools Display Modes
Old May 5th, 2003, 09:01 AM   #1
Fritz_frederix
Member
Belgium

Fritz_frederix is offline
 
Fritz_frederix's Avatar
 
Join Date: Apr 2003
Location: Belgium
Posts: 434
WINCC - SQL instructions

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
__________________
We're going to save money, no matter what is costs
  Reply With Quote
Old May 5th, 2003, 09:02 PM   #2
rdrast
Lifetime Supporting Member
United States

rdrast is offline
 
rdrast's Avatar
 
Join Date: Apr 2003
Location: South Carolina Lowcountry
Posts: 5,537
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 by rdrast; May 5th, 2003 at 09:09 PM.
  Reply With Quote
Reply
Jump to Live PLC Question and Answer Forum


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Topics
Thread Thread Starter Forum Replies Last Post
WinCC Flex - Coming Soon!! PLucas LIVE PLC Questions And Answers 21 August 22nd, 2005 08:23 AM
Different WinCC and WinCC server option huynt LIVE PLC Questions And Answers 1 November 15th, 2004 10:13 AM
Wincc & Opc Prince LIVE PLC Questions And Answers 1 September 5th, 2004 07:23 AM
WinCC VBS Fritz_frederix LIVE PLC Questions And Answers 1 May 18th, 2004 02:36 AM
WinCC manual Fritz_frederix LIVE PLC Questions And Answers 1 May 12th, 2003 11:34 AM


All times are GMT -4. The time now is 05:33 AM.


.