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

COPC32 activeX control used for SCADA development and growth. You can produce SCADA system (Graphic keeping an eye on & & control, Trending, Alarm, and also much more. )within your favorite shows IDE such as Visual Basic 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 used for SCADA production and advancement. You can create SCADA system (Graphic monitoring & & control, Trending, Alarm, as well as a lot more.) within your preferred programming IDE such as Aesthetic Standard 6.0, Visual Studio.Net (VB.Net, C#), as well as VBA (MS Excel, Word, & hellip;-RRB-. COPC32 Route variation will stop working after a hr. You have to reactivate program to run it once again.

This instance demonstrates how to logging OPC data in to MS SQL Server 2014 Express using COPC32 and also Visual Workshop 2015 Express.

Demands

MS SQL Server/ MS SQL Web Server Express
Aesthetic Workshop 2015 Express (download right here)
COPC32 (it is not free, download and install trial here). As well as you have to installing COPC32.
OPC Server

My data source name and also table’& rsquo; s column revealed “listed below. & ldquo; id & rdquo; column is auto increment.Read more COPC32 Free At website Articles

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

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

project(135kb)Open up downloaded task and ensure you have insert COPC32 control on Toolbox of Visual Workshop.

3 tag made use of to reveal OPC tags worth with Timer2 every 1 sec. Timer1 has logging manuscript functioning every 5 sec.

Define OPC Web Server on COPC32 ‘& lsquo; s home web page.

As well as OPC tags.

In Timer2’& rsquo; s code, getting OPC information into global variable v( 0) to v( 2) (see downloaded example code, will certainly see worldwide variable declared). And likewise show information on labels.

Private Below Timer2_Tick(sender As Things, e As EventArgs) Manages Timer2.Tick
For i = 0 To 2
v(i) = Axcopc1.GetVl(i)
Next

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

I have usage covering to call SQLCMD.exe with SQL command to insert OPC data in to MS SQL table.

Private Below Timer1_Tick(sender As Object, e As EventArgs) Manages Timer1.Tick
Covering(“& ldquo; C: \ Program Documents \ Microsoft SQL Server \ Customer SDK \ ODBC \ 110 \ Tools \ Binn \ SQLCMD.exe -S (regional) -d test -Q “”& ldquo; & rdquo; insert right 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 Sub When argumment– S=Web Server Call “(Please keep in mind that if your SQL Web server has & ldquo; \ SQLEXPRESS & rdquo; after computer name after that you need to utilize (neighborhood)\ SQLEXPRESS ), –– d = Data source Name, –– Q = SQL query/command. Instance above use SQL Insert command to place v( 0 ), v( 1 ), v( 2) as well as existing day time right into table t1 at related column.

You have to inspecting course of SQLCMD.exe in your system as well as change to over script.

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