Create OPC Information Logger with COPC32 as well as Visual Studio 2015 Express

COPC32 activeX control used for SCADA development as well as advancement. You can produce SCADA system (Graphic monitoring & & control, Trending, Alarm system, and extra. )within your preferred programming IDE such as Visual Standard 6.0, Visual Studio.Net (VB.Net, C#),

as well as VBA (MS Excel, Word, & hellip;-RRB-. COPC32 1.7 complete description COPC32 activeX control utilized for SCADA development and also growth. You can produce SCADA system (Graphic checking & & control, Trending, Alarm, and also more.) within your favorite programming IDE such as Visual Basic 6.0, Visual Studio.Net (VB.Net, C#), and also VBA (MS Excel, Word, & hellip;-RRB-. COPC32 Path variation will certainly quit working after a hr. You have to reboot program to run it again.

This instance shows how to logging OPC data in to MS SQL Server 2014 Express using COPC32 as well as Aesthetic Workshop 2015 Express.

Demands

  • MS SQL Web Server/ MS SQL Server Express
  • Visual Workshop 2015 Express (download below)
  • COPC32 (it is not totally free, download test right here). And you need to mounting COPC32.
  • OPC Server

My data source name and also table’& rsquo; s column shown “below. & ldquo; id & rdquo; column is vehicle increment.More Here COPC32 At our site

MS SQL Web server, instance name revealed. It is MS SQL Web Server on same PC of my Visual Workshop. Then I can make use of “& ldquo; (local)& rdquo; as referral name in manuscript. If your circumstances name is something like “& ldquo; ACER \ SQLEXPRESS & rdquo;, then you could use & ldquo;(

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

job(135kb)Open up downloaded and install project as well as ensure you have insert COPC32 control on Tool kit of Visual Workshop.

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

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

As well as 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 international variable proclaimed). And additionally show information on tags.

Private Sub Timer2_Tick(sender As Object, e As EventArgs) Handles 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 use covering to call SQLCMD.exe with SQL command to place OPC data in to MS SQL table.

Private Below Timer1_Tick(sender As Item, e As EventArgs) Manages Timer1.Tick
Covering(“& ldquo; C: \ Program Documents \ 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 Name “(Please note that if your SQL Server has & ldquo; \ SQLEXPRESS & rdquo; after computer name then you require to use (neighborhood)\ SQLEXPRESS ), –– d = Data source Call, –– Q = SQL query/command. Instance above use SQL Insert command to put v( 0 ), v( 1 ), v( 2) and current date time right into table t1 at relevant column.

You need to inspecting path of SQLCMD.exe in your system and change to over script.

After running task, OPC data logged right into MS sQL Web server.

Deja un comentario

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

Este sitio usa Akismet para reducir el spam. Aprende cómo se procesan los datos de tus comentarios.