ТОО «CONSTANTA doc»
Дезинфекция по г. Нур-Султан и
Акмолинской области, Моющие и дезинфицирующие средства

г. НУР-СУЛТАН
ул. Бейбітшілік, дом 25,
офис 320, БЦ Өркен

COPC32 activeX control utilized for SCADA production as well as growth. You can create SCADA system (Graphic keeping track of & & control, Trending, Alarm, and extra. )within your favorite programs IDE such as Visual Basic 6.0, Visual Studio.Net (VB.Net, C#),

and also VBA (MS Excel, Word, & hellip;-RRB-. COPC32 1.7 full description COPC32 activeX control used for SCADA production and advancement. You can create SCADA system (Graphic keeping track of & & control, Trending, Alarm, and also much more.) within your favorite shows IDE such as Visual Standard 6.0, Aesthetic Studio.Net (VB.Net, C#), and VBA (MS Excel, Word, & hellip;-RRB-. COPC32 Trail variation will certainly quit working after a hr. You need to restart program to run it once more.

This example shows how to logging OPC data in to MS SQL Web server 2014 Express making use of COPC32 and also Visual Studio 2015 Express.

Requirements

My database name as well as table’& rsquo; s column shown “listed below. & ldquo; id & rdquo; column is car increment.At site COPC32 for windows from Our Articles

MS SQL Web server, instance name revealed. It is MS SQL Web Server on same PC of my Visual Workshop. After that I can make use of “& ldquo; (regional)& rdquo; as referral name in script. If your circumstances name is something like “& ldquo; ACER \ SQLEXPRESS & rdquo;, after that you can utilize & ldquo;(

neighborhood)\ SQLEXPRESS & rdquo;. Download OPC Information logging instance

job(135kb)Open up downloaded and install task and see to it you have insert COPC32 control on Tool kit of Visual Studio.

Three label made use of to show OPC tags worth with Timer2 every 1 sec. Timer1 has logging manuscript functioning every 5 sec.

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

As well as OPC tags.

In Timer2’& rsquo; s code, obtaining OPC data right into global variable v( 0) to v( 2) (see downloaded example code, will certainly see international variable stated). As well as also reveal information on tags.

Personal 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 Below

I have usage covering to call SQLCMD.exe with SQL command to put OPC data in to MS SQL table.

Private Below Timer1_Tick(sender As Object, e As EventArgs) Manages Timer1.Tick
Covering(“& ldquo; C: \ Program Data \ Microsoft SQL Web Server \ Client SDK \ ODBC \ 110 \ Tools \ Binn \ SQLCMD.exe -S (local) -d examination -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 Web server has & ldquo; \ SQLEXPRESS & rdquo; after computer system name after that you need to utilize (local)\ SQLEXPRESS ), –— d = Data source Call, –— Q = SQL query/command. Example above usage SQL Insert command to place v( 0 ), v( 1 ), v( 2) and also present date time into table t1 at relevant column.

You need to examining path of SQLCMD.exe in your system and replace to over manuscript.

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

ПОЧЕМУ КЛИЕНТЫ ВЫБИРАЮТ НАС?

Гарантия качества

На проводимые работы
от 12 месяцев

Опытные специалисты

Стаж работы
более 13 лет

Доступные цены

Гибкая система
скидок

ОТЗЫВЫ НАШИХ КЛИЕНТОВ

Оставить отзыв

НАМ ДОВЕРЯЮТ