COPC32 activeX control made use of for SCADA development as well as advancement. You can produce SCADA system (Graphic monitoring & & control, Trending, Alarm system, and also a lot more. )within your favorite shows IDE such as Visual Fundamental 6.0, Visual Studio.Net (VB.Net, C#),
and VBA (MS Excel, Word, & hellip;-RRB-. COPC32 1.7 full summary COPC32 activeX control made use of for SCADA development as well as development. You can create SCADA system (Graphic keeping an eye on & & control, Trending, Alarm, and also extra.) within your favorite shows IDE such as Aesthetic Fundamental 6.0, Visual Studio.Net (VB.Net, C#), and also VBA (MS Excel, Word, & hellip;-RRB-. COPC32 Trail variation will certainly stop working after a hr. You have to reactivate program to run it once more.
This example shows how to logging OPC information in to MS SQL Server 2014 Express using COPC32 and Aesthetic Studio 2015 Express.
- MS SQL Web Server/ MS SQL Server Express
- Aesthetic Studio 2015 Express (download below)
- COPC32 (it is not totally free, download and install trial right here). And also you need to setting up COPC32.
- OPC Server
My data source name as well as table’& rsquo; s column revealed “below. & ldquo; id & rdquo; column is auto increment.Read here COPC32 Download At our site
MS SQL Server, circumstances name revealed. It is MS SQL Web Server on same PC of my Visual Workshop. Then I can use “& ldquo; (neighborhood)& rdquo; as recommendation name in manuscript. If your instance name is something like “& ldquo; ACER \ SQLEXPRESS & rdquo;, then you could use & ldquo;(
neighborhood)\ SQLEXPRESS & rdquo;. Download OPC Information logging example
project(135kb)Open up downloaded and install project as well as see to it you have insert COPC32 control on Toolbox 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 Web Server on COPC32 ‘& lsquo; s residential or commercial property page.
As well as OPC tags.
In Timer2’& rsquo; s code, getting OPC data right into worldwide variable v( 0) to v( 2) (see downloaded and install instance code, will see worldwide variable stated). And also show data on labels.
Personal Sub Timer2_Tick(sender As Item, e As EventArgs) Handles Timer2.Tick
For i = 0 To 2
v(i) = Axcopc1.GetVl(i)
Label1.Text = v( 0 ). ToString()
Label2.Text = v( 1 ). ToString()
Label3.Text = v( 2 ). ToString()
I have usage covering to call SQLCMD.exe with SQL command to place OPC information in to MS SQL table.
Exclusive Below Timer1_Tick(sender As Item, e As EventArgs) Handles Timer1.Tick
Covering(“& ldquo; C: \ Program Documents \ 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) worths (” & & rdquo; & & v(0) “& & ldquo; “, & rdquo;””& v(1)& & ldquo;, & rdquo; &
v(2) & & ldquo;, getdate ())& rdquo; & rdquo; & rdquo;-RRB- End Below When argumment– S=Web Server Name “(Please note that if your SQL Web server has & ldquo; \ SQLEXPRESS & rdquo; after computer system name after that you require to use (neighborhood)\ SQLEXPRESS ), –– d = Database Name, –– Q = SQL query/command. Instance over usage SQL Insert command to put v( 0 ), v( 1 ), v( 2) as well as current day time right into table t1 at associated column.
You need to examining path of SQLCMD.exe in your system as well as change to over script.
After running job, OPC data logged right into MS sQL Web server.