COPC32 activeX control utilized for SCADA creation as well as growth. You can produce SCADA system (Graphic keeping an eye on & & control, Trending, Alarm, as well as much more. )within your favored programs 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 complete description COPC32 activeX control utilized for SCADA production and also development. You can produce SCADA system (Graphic checking & & control, Trending, Alarm, and much more.) within your favored programs IDE such as Aesthetic Standard 6.0, Visual Studio.Net (VB.Net, C#), and also VBA (MS Excel, Word, & hellip;-RRB-. COPC32 Route variation will certainly stop working after an hour. You need to reactivate program to run it once again.

This example shows how to logging OPC information in to MS SQL Server 2014 Express making use of COPC32 as well as Aesthetic Studio 2015 Express.

Needs

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

My data source name and table’& rsquo; s column shown “listed below. & ldquo; id & rdquo; column is auto increment.Join Us COPC32 Download for Windows website

MS SQL Server, circumstances name shown. It is MS SQL Server on same COMPUTER of my Visual Workshop. Then I can make use of “& ldquo; (local)& rdquo; as recommendation name in script. If your circumstances name is something like “& ldquo; ACER \ SQLEXPRESS & rdquo;, then you could use & ldquo;(

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

job(135kb)Open up downloaded job and also ensure you have insert COPC32 control on Toolbox of Visual Workshop.

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

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

As well as OPC tags.

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

Private Sub Timer2_Tick(sender As Item, e As EventArgs) Deals With 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 shell to call SQLCMD.exe with SQL command to insert OPC data in to MS SQL table.

Private Sub Timer1_Tick(sender As Object, e As EventArgs) Handles Timer1.Tick
Shell(“& 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 Below When argumment– S=Web Server Call “(Please note that if your SQL Server has & ldquo; \ SQLEXPRESS & rdquo; after computer system name then you need to use (neighborhood)\ SQLEXPRESS ), –– d = Database Call, –– Q = SQL query/command. Example over use SQL Insert command to put v( 0 ), v( 1 ), v( 2) and also present date time right into table t1 at related column.

You need to inspecting course of SQLCMD.exe in your system and also replace to above script.

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

Chia sẻ