Public Function conntemp()
Dim conn As New ADODB.Connection '---->把这两行放到前面,做为一个公共变量,否则,你一退出这个子程序这两个变量就没有了!
Dim rs As New ADODB.Recordset '---->
conn.Open "dsn=mssql;uid=sa;pwd=;"
rs.Open "select * from sys_user_zz", conn, 1, 3
rp.Write "<h2>" & rs.RecordCount & "</h2>"
rp.Write "<h1>database connection is already created</h1>"
conntemp = rs -> 改为 Set conntemp = rs
End Function
Dim conn As New ADODB.Connection '---->把这两行放到前面,做为一个公共变量,否则,你一退出这个子程序这两个变量就没有了!
Dim rs As New ADODB.Recordset '---->
conn.Open "dsn=mssql;uid=sa;pwd=;"
rs.Open "select * from sys_user_zz", conn, 1, 3
rp.Write "<h2>" & rs.RecordCount & "</h2>"
rp.Write "<h1>database connection is already created</h1>"
conntemp = rs -> 改为 Set conntemp = rs
End Function
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货