COPC32 activeX control utilized for SCADA production and development. You can develop SCADA system (Graphic keeping track of & & control, Trending, Alarm system, and more. )within your preferred shows IDE such as Visual Basic 6.0, Aesthetic Studio.Net (VB.Net, C#),
and also VBA (MS Excel, Word, & hellip;-RRB-. COPC32 1.7 full description COPC32 activeX control utilized for SCADA production as well as advancement. You can produce SCADA system (Graphic keeping track of & & control, Trending, Alarm, as well as a lot more.) within your preferred programs IDE such as Aesthetic Basic 6.0, Aesthetic Studio.Net (VB.Net, C#), and also VBA (MS Excel, Word, & hellip;-RRB-. COPC32 Trail version will quit working after an hour. You need to reboot program to run it again.
This instance demonstrates how to logging OPC information in to MS SQL Web server 2014 Express utilizing COPC32 and Visual Studio 2015 Express.
- MS SQL Server/ MS SQL Server Express
- Visual Studio 2015 Express (download here)
- COPC32 (it is not totally free, download and install test right here). And you have to setting up COPC32.
- OPC Web server
My database name and also table’& rsquo; s column revealed “below. & ldquo; id & rdquo; column is auto increment.read about it bitCOPC32 Download from Our Articles
MS SQL Server, circumstances name shown. It is MS SQL Web Server on very same COMPUTER of my Visual Studio. After that I can make use of “& ldquo; (local)& rdquo; as referral name in script. If your circumstances name is something like “& ldquo; ACER \ SQLEXPRESS & rdquo;, after that you might make use of & ldquo;(
regional)\ SQLEXPRESS & rdquo;. Download and install OPC Information logging instance
task(135kb)Open up downloaded project as well as make certain you have insert COPC32 control on Toolbox of Visual Workshop.
3 tag made use of to reveal OPC tags value with Timer2 every 1 sec. Timer1 has logging manuscript working every 5 sec.
Define OPC Server on COPC32 ‘& lsquo; s residential property web page.
Along with OPC tags.
In Timer2’& rsquo; s code, getting OPC data into global variable v( 0) to v( 2) (see downloaded example code, will see worldwide variable declared). As well as likewise show information on labels.
Exclusive Sub Timer2_Tick(sender As Item, e As EventArgs) Manages 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 insert OPC data in to MS SQL table.
Private Sub Timer1_Tick(sender As Item, e As EventArgs) Takes Care Of Timer1.Tick
Covering(“& ldquo; C: \ Program Data \ Microsoft SQL Server \ Customer SDK \ ODBC \ 110 \ Tools \ 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=Server Call “(Please note that if your SQL Server has & ldquo; \ SQLEXPRESS & rdquo; after computer name after that you need to make use of (regional)\ SQLEXPRESS ), –– d = Database Name, –– Q = SQL query/command. Example over use SQL Insert command to place v( 0 ), v( 1 ), v( 2) as well as current day time right into table t1 at associated column.
You have to examining path of SQLCMD.exe in your system and also replace to over script.
After running project, OPC information logged right into MS sQL Web server.