看了好多关于数据库的帖子,还是没搞好WinCC与普通数据库连接问题.
具体问题如下:
(1)自己建的数据库(Test) 及表格(user)
可运行的过程中 Set oRs = oCom.Execute 没有通过,一直找不出原因
请前辈指点
(2)数据库位于fdsf\WinCC下代码如下:给看下
Dim sCon
Dim sSql
Dim oRs
Dim conn
Dim oCom
Dim Con

Con="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Test;Data Source=.\WINCC"
Set conn = CreateObject("ADODB.Connection")
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
sSql="insert into user values (4,'dd')"
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