Develop OPC Data Logger with COPC32 as well as Aesthetic Studio 2015 Express

COPC32 activeX control utilized for SCADA development and also development. You can develop SCADA system (Graphic checking & & control, Trending, Alarm, and extra. )within your favorite programs IDE such as Visual Standard 6.0, Aesthetic Studio.Net (VB.Net, C#),

as well as VBA (MS Excel, Word, & hellip;-RRB-. COPC32 1.7 complete summary COPC32 activeX control utilized for SCADA production as well as advancement. You can develop SCADA system (Graphic checking & & control, Trending, Alarm, and much more.) within your favorite programs IDE such as Aesthetic Standard 6.0, Visual Studio.Net (VB.Net, C#), and VBA (MS Excel, Word, & hellip;-RRB-. COPC32 Path variation will certainly stop working after a hr. You have to reboot program to run it once again.

This example demonstrates how to logging OPC data in to MS SQL Server 2014 Express utilizing COPC32 as well as Aesthetic Workshop 2015 Express.


  • MS SQL Web Server/ MS SQL Server Express
  • Aesthetic Studio 2015 Express (download below)
  • COPC32 (it is not free, download and install test below). As well as you have to installing COPC32.
  • OPC Web server

My database name and also table’& rsquo; s column shown “listed below. & ldquo; id & rdquo; column is vehicle increment.More Here At our site

MS SQL Web server, instance name revealed. It is MS SQL Server on same PC of my Visual Workshop. After that I can make use of “& ldquo; (regional)& rdquo; as recommendation name in manuscript. If your circumstances name is something like “& ldquo; ACER \ SQLEXPRESS & rdquo;, after that you can use & ldquo;(

neighborhood)\ SQLEXPRESS & rdquo;. Download and install OPC Data logging instance

job(135kb)Open up downloaded and install project and also ensure you have insert COPC32 control on Tool kit of Visual Workshop.

Three label made use of to show OPC tags value with Timer2 every 1 sec. Timer1 has logging script functioning every 5 sec.

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

Along with OPC tags.

In Timer2’& rsquo; s code, obtaining OPC data right into worldwide variable v( 0) to v( 2) (see downloaded and install instance code, will see global variable declared). As well as additionally show information on labels.

Personal Sub Timer2_Tick(sender As Item, e As EventArgs) Manages 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 Sub

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

Exclusive Below Timer1_Tick(sender As Object, e As EventArgs) Handles Timer1.Tick
Shell(“& ldquo; C: \ Program Data \ Microsoft SQL Web Server \ Customer SDK \ ODBC \ 110 \ Devices \ Binn \ SQLCMD.exe -S (neighborhood) -d test -Q “”& ldquo; & rdquo; insert right into t1(v1, v2, v3, Time_Date) values (” & & rdquo; & & v(0) “& & ldquo; “, & rdquo;””& v(1)& & ldquo;, & rdquo; &

v(2) & & ldquo;, getdate ())& rdquo; & rdquo; & rdquo;-RRB- End Sub When argumment– S=Web Server Name “(Please keep in mind that if your SQL Web server has & ldquo; \ SQLEXPRESS & rdquo; after computer system name after that you need to use (local)\ SQLEXPRESS ), –– d = Database Call, –– Q = SQL query/command. Instance over use SQL Insert command to put v( 0 ), v( 1 ), v( 2) and also existing date time into table t1 at associated column.

You have to inspecting path of SQLCMD.exe in your system and change to above manuscript.

After running task, OPC information logged into MS sQL Server.

Leave a Comment

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