1.现在想通过全局VBS把wincc里的变量数据连接到SQL里面,把这些数据建立数据库.

2.与wincc建立连接的数据CC_btsys_08_12_30_14_00_24,在这里建立了一个used的表

3.在wincc里面的全局VBS里写入了如下脚本(改别人的,还有地方看不明白):
Dim sCon

Dim sSql

Dim oRs

Dim conn

Dim oCom

Dim Con

Dim objTag

Dim HMIRuntime

Con="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CC_111_09_01_06_10_29_08;Data Source=.\WINCC"

Set conn = CreateObject("ADODB.Connection")

conn.ConnectionString = Con

conn.CursorLocation = 3

conn.Open

Set objTag = HMIRuntime.Tags("xx")

sSql="insert into [user] values("&objtag&").read"

Set oRs = CreateObject("ADODB.Recordset")

Set oCom = CreateObject("ADODB.Command")

Set oCom.ActiveConnection = conn

oCom.CommandType = 1

oCom.CommandText = sSql



Set oRs = oCom.Execute



Set oRs = Nothing

conn.Close

Set conn = Nothing
但是总是没有反应:可能是这句有问题.
Set objTag = HMIRuntime.Tags("xx")

sSql="insert into [user] values("&objtag&").read"
到底要怎么改呀????

谢谢大家了;.