Develop OPC Data Logger with COPC32 and also Visual Workshop 2015 Express

COPC32 activeX control made use of for SCADA production and advancement. You can produce SCADA system (Graphic keeping an eye on & & control, Trending, Alarm, as well as much more. )within your preferred shows IDE such as Aesthetic Basic 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 made use of for SCADA creation as well as growth. You can create SCADA system (Graphic keeping track of & & control, Trending, Alarm system, and also more.) within your preferred programming IDE such as Aesthetic Fundamental 6.0, Visual Studio.Net (VB.Net, C#), and VBA (MS Excel, Word, & hellip;-RRB-. COPC32 Path version will quit working after an hour. You need to reboot program to run it once more.

This example demonstrates how to logging OPC information in to MS SQL Server 2014 Express making use of COPC32 and 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 cost-free, download and install test right here). And you need to installing COPC32.
  • OPC Web server

My database name and table’& rsquo; s column shown “below. & ldquo; id & rdquo; column is car increment.Read more COPC32 At website Articles

MS SQL Server, circumstances name revealed. 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 circumstances name is something like “& ldquo; ACER \ SQLEXPRESS & rdquo;, then you could make use of & ldquo;(

local)\ SQLEXPRESS & rdquo;. Download and install OPC Data logging example

task(135kb)Open up downloaded and install job and make sure you have insert COPC32 control on Toolbox of Visual Workshop.

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

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

As well as OPC tags.

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

Personal Sub Timer2_Tick(sender As Object, e As EventArgs) Manages 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 place OPC data in to MS SQL table.

Exclusive Sub Timer1_Tick(sender As Item, e As EventArgs) Takes Care Of Timer1.Tick
Covering(“& ldquo; C: \ Program Documents \ Microsoft SQL Web Server \ Client SDK \ ODBC \ 110 \ Devices \ Binn \ SQLCMD.exe -S (local) -d examination -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 Name “(Please note that if your SQL Web server has & ldquo; \ SQLEXPRESS & rdquo; after computer system name then you require to make use of (neighborhood)\ SQLEXPRESS ), –– d = Database Name, –– Q = SQL query/command. Example above usage SQL Insert command to place v( 0 ), v( 1 ), v( 2) as well as present day time into table t1 at associated column.

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

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