Develop OPC Information Logger with COPC32 and Aesthetic Studio 2015 Express

COPC32 activeX control used for SCADA production and advancement. You can develop SCADA system (Graphic keeping an eye on & & control, Trending, Alarm, and also extra. )within your favored programs IDE such as Aesthetic Standard 6.0, Visual Studio.Net (VB.Net, C#),

as well as VBA (MS Excel, Word, & hellip;-RRB-. COPC32 1.7 full summary COPC32 activeX control utilized for SCADA production as well as growth. You can produce SCADA system (Graphic keeping an eye on & & control, Trending, Alarm system, and a lot more.) within your preferred programming IDE such as Visual Standard 6.0, Visual Studio.Net (VB.Net, C#), and VBA (MS Excel, Word, & hellip;-RRB-. COPC32 Path variation will stop working after an hour. You have to reactivate program to run it again.

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

Requirements

• MS SQL Web Server/ MS SQL Web Server Express
• Visual Workshop 2015 Express (download right here)
• COPC32 (it is not complimentary, download and install test below). As well as you have to setting up COPC32.
• OPC Server

My data source name as well as table’& rsquo; s column revealed “below. & ldquo; id & rdquo; column is auto increment.you can find more here COPC32 free download from Our Articles

MS SQL Web server, instance name shown. It is MS SQL Web Server on same PC of my Visual Studio. After that I can utilize “& ldquo; (neighborhood)& rdquo; as recommendation name in script. If your instance name is something like “& ldquo; ACER \ SQLEXPRESS & rdquo;, then you might utilize & ldquo;(

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

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

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

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

In addition to OPC tags.

In Timer2’& rsquo; s code, getting OPC data into international variable v( 0) to v( 2) (see downloaded example code, will certainly see global variable declared). As well as also show data on tags.

Exclusive Below Timer2_Tick(sender As Object, e As EventArgs) Handles Timer2.Tick
For i = 0 To 2
v(i) = Axcopc1.GetVl(i)
Following

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

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

Exclusive Below Timer1_Tick(sender As Things, e As EventArgs) Handles Timer1.Tick
Covering(“& ldquo; C: \ Program Data \ Microsoft SQL Server \ Customer SDK \ ODBC \ 110 \ Devices \ Binn \ SQLCMD.exe -S (local) -d test -Q “”& ldquo; & rdquo; insert 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 Call “(Please note that if your SQL Web server has & ldquo; \ SQLEXPRESS & rdquo; after computer name then you require to utilize (regional)\ SQLEXPRESS ), –– d = Database Name, –– Q = SQL query/command. Example over use SQL Insert command to place v( 0 ), v( 1 ), v( 2) and present date time right into table t1 at relevant column.

You have to inspecting path of SQLCMD.exe in your system and replace to above script.

After running job, OPC information logged into MS sQL Web server.