Produce OPC Data Logger with COPC32 as well as Visual Workshop 2015 Express

COPC32 activeX control made use of for SCADA development as well as growth. You can create SCADA system (Graphic checking & & control, Trending, Alarm system, as well as extra. )within your preferred shows IDE such as Aesthetic Standard 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 made use of for SCADA development and also advancement. You can develop SCADA system (Graphic keeping track of & & control, Trending, Alarm system, and also much more.) within your favorite programming IDE such as Aesthetic Fundamental 6.0, Aesthetic Studio.Net (VB.Net, C#), and also VBA (MS Excel, Word, & hellip;-RRB-. COPC32 Route version will stop working after a hr. You have to reactivate program to run it once again.

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

Requirements

  • MS SQL Web Server/ MS SQL Web Server Express
  • Visual Studio 2015 Express (download here)
  • COPC32 (it is not totally free, download test here). And you need to setting up COPC32.
  • OPC Web server

My data source name as well as table’& rsquo; s column shown “below. & ldquo; id & rdquo; column is automobile increment.Read here free COPC32 download At our site

MS SQL Web server, circumstances name shown. It is MS SQL Server on very same COMPUTER of my Visual Studio. After that I can make use of “& ldquo; (local)& rdquo; as reference name in manuscript. If your instance name is something like “& ldquo; ACER \ SQLEXPRESS & rdquo;, after that you could utilize & ldquo;(

regional)\ SQLEXPRESS & rdquo;. Download and install OPC Information logging example

job(135kb)Open up downloaded task and also ensure you have insert COPC32 control on Tool kit of Visual Studio.

Three tag utilized to show OPC tags worth with Timer2 every 1 sec. Timer1 has logging script working every 5 sec.

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

Along with OPC tags.

In Timer2’& rsquo; s code, getting OPC information right into international variable v( 0) to v( 2) (see downloaded and install instance code, will certainly see worldwide variable proclaimed). As well as also show information on tags.

Personal Below Timer2_Tick(sender As Things, 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 Below

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

Private Sub Timer1_Tick(sender As Things, e As EventArgs) Takes Care Of Timer1.Tick
Covering(“& ldquo; C: \ Program Documents \ Microsoft SQL Server \ Client SDK \ ODBC \ 110 \ Tools \ Binn \ SQLCMD.exe -S (regional) -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 system name after that you need to utilize (neighborhood)\ SQLEXPRESS ), –– d = Data source Call, –– Q = SQL query/command. Example above usage SQL Insert command to place v( 0 ), v( 1 ), v( 2) and also current date time into table t1 at associated column.

You need to checking course of SQLCMD.exe in your system and change to above script.

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

Deja una respuesta

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *