向大家求助一个关于ASP数据库问题
来源:百度知道 编辑:UC知道 时间:2024/05/26 19:59:40
我的数据库是autoDB.mdb,和ASP在同一个文件夹里,代码如下:
<%
StrConnect="Driver={Microsoft Access Driver(*.mdb)};DBQ=autoDB.mdb"
Set objConn=Server.CreateObject("ADODB.Connection")
objConn.Open StrConnect
Set rs=Server.CreateObject("ADODB.RecordSet")
rs.Open "Select adminName,adminPassword from admin",objConn,adOpenForwardOnly
Response.Write rs("adminName")
rs.Close
objConn.Close
%>
为什么我看不到结果呢?望高手指点一下,帮我修改一下,谢谢!
<%
StrConnect="Driver={Microsoft Access Driver(*.mdb)};DBQ=autoDB.mdb"
Set objConn=Server.CreateObject("ADODB.Connection")
objConn.Open StrConnect
Set rs=Server.CreateObject("ADODB.RecordSet")
rs.Open "Select adminName,adminPassword from admin",objConn,adOpenForwardOnly
Response.Write rs("adminName")
rs.Close
objConn.Close
%>
为什么我看不到结果呢?望高手指点一下,帮我修改一下,谢谢!
Set objConn = Server.CreateObject("ADODB.Connection")
StrConnect ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("autoDB.mdb")
objConn.Open StrConnect
set rs = server.createobject("adodb.recordset")
sql = "select adminname,adminpassword from admin"
rs.open sql , objConn , 1 , 1
response.write rs("adminname")
这样再试试看
改成这样看看
rs.Open "Select adminName,adminPassword from admin",objConn,1,1