02 dec Produce OPC Data Logger with COPC32 and also Aesthetic Studio 2015 Express
COPC32 activeX control used for SCADA creation and also development. You can develop SCADA system (Graphic checking & & control, Trending, Alarm, and also more. )within your preferred shows IDE such as Visual 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 used for SCADA development and also advancement. You can develop SCADA system (Graphic keeping track of & & control, Trending, Alarm system, and more.) within your favored programs IDE such as Visual Basic 6.0, Aesthetic Studio.Net (VB.Net, C#), as well as VBA (MS Excel, Word, & hellip;-RRB-. COPC32 Path variation will quit working after a hr. You have to reactivate program to run it again.
This instance shows how to logging OPC information in to MS SQL Server 2014 Express utilizing COPC32 and also Visual Workshop 2015 Express.
- MS SQL Web Server/ MS SQL Server Express
- Aesthetic Workshop 2015 Express (download below)
- COPC32 (it is not complimentary, download and install trial right here). And also you need to mounting COPC32.
- OPC Web server
My data source name as well as table’& rsquo; s column shown “below. & ldquo; id & rdquo; column is automobile increment.follow the link freewindows10download.com At our site
MS SQL Web server, instance name revealed. It is MS SQL Web Server on very same PC of my Visual Workshop. After that I can utilize “& ldquo; (neighborhood)& rdquo; as recommendation name in manuscript. If your instance name is something like “& ldquo; ACER \ SQLEXPRESS & rdquo;, then you might make use of & ldquo;(
local)\ SQLEXPRESS & rdquo;. Download and install OPC Data logging instance
task(135kb)Open downloaded and install project and also make sure you have insert COPC32 control on Tool kit of Visual Studio.
3 label utilized to show OPC tags worth with Timer2 every 1 sec. Timer1 has logging script functioning every 5 sec.
Define OPC Web Server on COPC32 ‘& lsquo; s residential property web page.
As well as OPC tags.
In Timer2’& rsquo; s code, getting OPC information into global variable v( 0) to v( 2) (see downloaded example code, will see worldwide variable declared). As well as also show information on labels.
Private Below 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 use shell to call SQLCMD.exe with SQL command to put OPC data in to MS SQL table.
Personal Below Timer1_Tick(sender As Object, e As EventArgs) Manages Timer1.Tick
Shell(“& ldquo; C: \ Program Files \ Microsoft SQL Server \ Client SDK \ ODBC \ 110 \ Tools \ Binn \ SQLCMD.exe -S (neighborhood) -d test -Q “”& ldquo; & rdquo; insert right 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 Call “(Please keep in mind that if your SQL Server has & ldquo; \ SQLEXPRESS & rdquo; after computer name after that you require to utilize (local)\ SQLEXPRESS ), –– d = Database Call, –– Q = SQL query/command. Instance above usage SQL Insert command to put v( 0 ), v( 1 ), v( 2) and also current date time into table t1 at relevant column.
You have to examining course of SQLCMD.exe in your system as well as replace to over manuscript.
After running job, OPC data logged right into MS sQL Server.