可以改成
set ac=new Connection
set res = new recordset
res.open "insert into Server(ID,NAME) values('100011','zq')",ac, adOpenStatic, adLockReadOnly, adCmdText
还可以写成
set ac=new Connection
ac.Execute "insert into Server(ID,NAME) values('100011','zq')"
Uses the Command object to Execute the SQL statements for the result without row(s) returned.
Uses the Command object to Open the SQL statements for the result with row(s) returned.