Develop OPC Information Logger with COPC32 and also Aesthetic Workshop 2015 Express

COPC32 activeX control utilized for SCADA production and also growth. You can produce SCADA system (Graphic keeping track of & & control, Trending, Alarm, and extra. )within your preferred programs IDE such as Visual Fundamental 6.0, Aesthetic Studio.Net (VB.Net, C#),

as well as VBA (MS Excel, Word, & hellip;-RRB-. COPC32 1.7 full description COPC32 activeX control utilized for SCADA development as well as development. You can produce SCADA system (Graphic keeping an eye on & & control, Trending, Alarm, and a lot more.) within your favorite programming IDE such as Visual Basic 6.0, Aesthetic Studio.Net (VB.Net, C#), and also VBA (MS Excel, Word, & hellip;-RRB-. COPC32 Route version will certainly stop working after a hr. You have to reactivate program to run it again.

This example shows how to logging OPC information in to MS SQL Web server 2014 Express making use of COPC32 as well as Aesthetic Workshop 2015 Express.


  • MS SQL Server/ MS SQL Server Express
  • Visual Workshop 2015 Express (download right here)
  • COPC32 (it is not complimentary, download and install test below). And you have to mounting COPC32.
  • OPC Web server

My database name and also table’& rsquo; s column shown “listed below. & ldquo; id & rdquo; column is automobile increment.follow the link At our site

MS SQL Web server, circumstances name shown. It is MS SQL Server on same COMPUTER of my Visual Workshop. Then I can utilize “& ldquo; (neighborhood)& rdquo; as recommendation name in manuscript. If your instance name is something like “& ldquo; ACER \ SQLEXPRESS & rdquo;, then you could use & ldquo;(

local)\ SQLEXPRESS & rdquo;. Download and install OPC Information logging instance

job(135kb)Open downloaded and install job and make certain you have insert COPC32 control on Tool kit of Visual Studio.

Three label used to show OPC tags worth with Timer2 every 1 sec. Timer1 has logging script functioning every 5 sec.

Define OPC Web Server on COPC32 ‘& lsquo; s residential property web 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 certainly see global variable stated). And additionally show information on tags.

Private Below 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 Below

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

Exclusive Below Timer1_Tick(sender As Object, e As EventArgs) Deals With Timer1.Tick
Shell(“& ldquo; C: \ Program Data \ Microsoft SQL Server \ Customer SDK \ ODBC \ 110 \ Tools \ Binn \ SQLCMD.exe -S (local) -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 Below When argumment– S=Server Name “(Please note that if your SQL Server has & ldquo; \ SQLEXPRESS & rdquo; after computer name then you need to utilize (local)\ SQLEXPRESS ), –– d = Database Name, –– Q = SQL query/command. Instance over usage SQL Insert command to place v( 0 ), v( 1 ), v( 2) as well as current date time into table t1 at related column.

You have to checking course of SQLCMD.exe in your system as well as change to over manuscript.

After running task, OPC data logged into MS sQL Web server.