发布于 2008-11-03 10:50:03
0楼
肯定可以啦。下面是我用的VBS代码,直接复制就能连接上,具体怎么操作你就自己写SQL语句来操作数据表。
Dim cn,rs,sql
Dim dsource
Set dsource=HMIRuntime.Tags("@DatasourceNameRT")
dsource.Read
dsource.Value =Mid(dsource.value,1,Len(dsource.value)-1)
Set cn = CreateObject("ADODB.Connection")
Set rs=CreateObject("ADODB.Recordset")
strcn="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog='"+ dsource.Value +"';Data Source=.\WINCC"
cn.ConnectionString=strcn
cn.open