你上面的是JScript中的语法,试试看下面的行不行:
var Set myConn = Server.CreateObject("ADODB.Connection");
var ConnectionString = "DRIVER=SQL server;SERVER=NBHC-SZY;CATALOG=mydata;DATABASE=mydata;UID=sa;PWD=sizy";
myConn.Open ConnectionString;var sqlStr = "SELECT * FROM tbm01 WHERE tba011c= comid"
rs = new ActiveXObject("ADODB.RecordSet");
rs.open sqlStr,myConn,3,1,1;最好采用Vbscript语法,如下所示:
Set myConn = Server.CreateObject("ADODB.Connection")
ConnectionString = "DRIVER=SQL server;SERVER=NBHC-SZY;CATALOG=mydata;DATABASE=mydata;UID=sa;PWD=sizy"
myConn.Open ConnectionStringsqlStr = "SELECT * FROM tbm01 WHERE tba011c= comid"
rs = new ActiveXObject("ADODB.RecordSet")
rs.open sqlStr,myConn,3,1,1