我想问一下在wincc画面上做一个按钮,通过按下该按钮把变量值写入SQL数据库中要怎么做?是不是要对变量值归档后才能写到SQL数据库中?
最佳答案
转帖:
wincc数据库的访问和vb数据库的访问一样,通过odb可直接访问,访问连接字符串用provider=WinCCOLEDBProvider.1;catalog=CC_gz_food_09_07_14_14_54_22R;data source=ComputerName\WinCC
查询语句select 换成是ssql="Tag:R,’archive_test\archive_test1′,’2009-8-19 10:00:00.000′,’2009-8-19 10:59:59.999’" ‘archive_test\archive_test1 分别是归档名称和归档变量
其它都就和vb中访问一样了! 例如:
Dim cnn As String
cnn = "provider=WinCCOLEDBProvider.1;catalog=CC_gz_food_09_07_14_14_54_22R;data source=ComputerName\WinCC"
Set cc1 = CreateObject("adodb.connection")
cc1.ConnectionString = cnn
cc1.CursorLocation = 3
cc1.Open
Dim rst As Object
Set rst = CreateObject("adodb.recordset")
Dim ssql As String
ssql="Tag:R,’archive