Develop OPC Information Logger with COPC32 as well as Aesthetic Workshop 2015 Express

COPC32 activeX control made use of for SCADA creation as well as growth. You can produce SCADA system (Graphic keeping an eye on & & control, Trending, Alarm system, and also much more. )within your favorite programs IDE such as Visual Basic 6.0, Aesthetic Studio.Net (VB.Net, C#),

and VBA (MS Excel, Word, & hellip;-RRB-. COPC32 1.7 full summary COPC32 activeX control utilized for SCADA production and also advancement. You can develop SCADA system (Graphic monitoring & & control, Trending, Alarm, and extra.) within your favored shows IDE such as Visual Standard 6.0, Visual Studio.Net (VB.Net, C#), as well as VBA (MS Excel, Word, & hellip;-RRB-. COPC32 Path version will certainly stop working after a hr. You need to reboot program to run it once again.

This instance demonstrates how to logging OPC data in to MS SQL Web server 2014 Express using COPC32 as well as Aesthetic Studio 2015 Express.


  • MS SQL Web Server/ MS SQL Server Express
  • Aesthetic Workshop 2015 Express (download here)
  • COPC32 (it is not free, download and install trial right here). And you need to setting up COPC32.
  • OPC Web server

My data source name and table’& rsquo; s column revealed “listed below. & ldquo; id & rdquo; column is automobile increment.At site from Our Articles

MS SQL Server, instance name shown. It is MS SQL Web Server on very same PC of my Visual Studio. Then I can use “& ldquo; (local)& rdquo; as referral name in manuscript. If your instance name is something like “& ldquo; ACER \ SQLEXPRESS & rdquo;, then you might make use of & ldquo;(

regional)\ SQLEXPRESS & rdquo;. Download OPC Information logging example

project(135kb)Open up downloaded and install project as well as see to it you have insert COPC32 control on Toolbox of Visual Workshop.

3 label utilized to reveal OPC tags worth with Timer2 every 1 sec. Timer1 has logging script working every 5 sec.

Specify OPC Server on COPC32 ‘& lsquo; s residential or commercial property page.

In addition to OPC tags.

In Timer2’& rsquo; s code, getting OPC information into international variable v( 0) to v( 2) (see downloaded example code, will see global variable declared). And also reveal information on tags.

Personal Sub Timer2_Tick(sender As Things, e As EventArgs) Handles Timer2.Tick
For i = 0 To 2
v(i) = Axcopc1.GetVl(i)

Label1.Text = v( 0 ). ToString()
Label2.Text = v( 1 ). ToString()
Label3.Text = v( 2 ). ToString()
End Below

I have use shell to call SQLCMD.exe with SQL command to place OPC information in to MS SQL table.

Exclusive Sub Timer1_Tick(sender As Item, e As EventArgs) Manages Timer1.Tick
Covering(“& ldquo; C: \ Program Documents \ Microsoft SQL Web Server \ Customer SDK \ ODBC \ 110 \ Devices \ Binn \ SQLCMD.exe -S (regional) -d examination -Q “”& ldquo; & rdquo; insert into t1(v1, v2, v3, Time_Date) worths (” & & rdquo; & & v(0) “& & ldquo; “, & rdquo;””& v(1)& & ldquo;, & rdquo; &

v(2) & & ldquo;, getdate ())& rdquo; & rdquo; & rdquo;-RRB- End Below When argumment– S=Server Name “(Please note that if your SQL Web server has & ldquo; \ SQLEXPRESS & rdquo; after computer system name then you require to use (local)\ SQLEXPRESS ), –– d = Data source Name, –– Q = SQL query/command. Instance above usage SQL Insert command to place v( 0 ), v( 1 ), v( 2) and current date time into table t1 at associated column.

You need to checking course of SQLCMD.exe in your system and also replace to above script.

After running project, OPC data logged into MS sQL Server.

Leave a Reply

Your email address will not be published. Required fields are marked *

Copyright Care For All 2020. All rights reserved.