UC知道请教高人VBScript语言中如何连接Access数据库?
来源：百度知道 编辑：UC知道 时间：2024/09/28 06:38:32
最好写一个实例,比如数据库在D:\修改\tai\t\Database目录下有一数据库datadb.mdb,其中有一名为book的表,表中字段有ID和name,请帮忙编写一段VBScript代码读取ID的值出来.谢谢!
<%
set conn = createobject("adodb.connection")
ConStr="Driver={Microsoft Access Driver (*.mdb)};dbq=D:\修改\tai\t\Database\datadb.mdb"
conn.open ConStr
set rs = createobject("adodb.recordset")
rs.open "select * from book ",conn, 3, 1, &H0001
reponse.write "ID, NAME" & "<BR>"
Do Until rs.EOF
reponse.write rs("ID") & "," & rs("NAME") & "<BR>"
rs.MoveNext
Loop
rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
%>
<script language=vbscript>
set conn = createobject("adodb.connection")
ConStr="Driver={Microsoft Access Driver (*.mdb)};dbq=D:\修改\tai\t\Database\datadb.mdb"
conn.open ConStr
set rs = createobject("adodb.recordset")
rs.open "select * from book where i