Create OPC Data Logger with COPC32 and Aesthetic Studio 2015 Express

COPC32 activeX control made use of for SCADA development and also development. You can develop SCADA system (Graphic keeping track of & & control, Trending, Alarm, as well as a lot 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 1.7 full summary COPC32 activeX control utilized for SCADA creation and advancement. You can produce SCADA system (Graphic monitoring & & control, Trending, Alarm system, as well as more.) within your favorite programming IDE such as Aesthetic Fundamental 6.0, Aesthetic Studio.Net (VB.Net, C#), as well as VBA (MS Excel, Word, & hellip;-RRB-. COPC32 Path variation will stop working after an hour. You need to restart program to run it again.

This example demonstrates how to logging OPC data in to MS SQL Server 2014 Express making use of COPC32 and also Visual Studio 2015 Express.

Demands

  • MS SQL Web Server/ MS SQL Web Server Express
  • Aesthetic Studio 2015 Express (download right here)
  • COPC32 (it is not complimentary, download test here). As well as you need to installing COPC32.
  • OPC Server

My data source name and table’& rsquo; s column revealed “below. & ldquo; id & rdquo; column is auto increment.More Here bitCOPC32 Download At our site

MS SQL Web server, circumstances name revealed. It is MS SQL Server on exact same COMPUTER of my Visual Studio. After that I can utilize “& ldquo; (local)& rdquo; as recommendation name in script. If your circumstances name is something like “& ldquo; ACER \ SQLEXPRESS & rdquo;, then you can make use of & ldquo;(

regional)\ SQLEXPRESS & rdquo;. Download OPC Data logging example

project(135kb)Open up downloaded and install task and make certain you have insert COPC32 control on Tool kit of Visual Workshop.

Three tag used to reveal OPC tags value with Timer2 every 1 sec. Timer1 has logging script functioning every 5 sec.

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

In addition to OPC tags.

In Timer2’& rsquo; s code, obtaining OPC information right into global variable v( 0) to v( 2) (see downloaded example code, will certainly see international variable proclaimed). As well as additionally show information on labels.

Private Sub Timer2_Tick(sender As Things, e As EventArgs) Takes Care Of 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 usage shell to call SQLCMD.exe with SQL command to place OPC data in to MS SQL table.

Personal Sub Timer1_Tick(sender As Item, e As EventArgs) Takes Care Of Timer1.Tick
Covering(“& ldquo; C: \ Program Files \ Microsoft SQL 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=Server Call “(Please note that if your SQL Server has & ldquo; \ SQLEXPRESS & rdquo; after computer name then you require to utilize (neighborhood)\ SQLEXPRESS ), –— d = Data source Call, –— Q = SQL query/command. Example over usage SQL Insert command to place v( 0 ), v( 1 ), v( 2) and current date time right into table t1 at associated column.

You have to inspecting course of SQLCMD.exe in your system and also change to above script.

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

Понравилась статья? Поделиться с друзьями:
Добавить комментарий

;-) :| :x :twisted: :smile: :shock: :sad: :roll: :razz: :oops: :o :mrgreen: :lol: :idea: :grin: :evil: :cry: :cool: :arrow: :???: :?: :!: