28,409
社区成员




<%
Db = "\\192.168.15.2\db\oa.mdb" '这里需要改成你自己的数据库路径
ConnStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & db
Set Conn = Server.CreateObject("ADODB.Connection")
Set Rs=Server.CreateObject("ADODB.RecordSet")
Conn.Open ConnStr
Sql = "Select * From test" '对OA数据库的TEST表操作
Rs.Open Sql,Conn,1,3
Response.Write Rs("id") '读取ID字段的值
Rs.Close
Set Rs = Nothing
%>