聊天背吃鸡图片大全:Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

来源:百度文库 编辑:高考问答 时间:2024/05/04 18:46:16
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
程序
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>

<body>
<% set conn=server.CreateObject("adodb.connection")
conn.open "driver={microsoft acess driver (*.mdb)}; dbq="&server.MapPath("db1.mdb")
%>
<% exec="select * from guestbook"
set rs=server.CreateObject("adodb.recordset")
rs.open exec,conn,1,1
%>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<% do while not rs.eof%>
<tr>
<td><%=rs("name")%></td>
<td><%=rs("tel")%></td>
<td><%=rs("message")%></td>
<td><%=rs("time")%></td>
</tr>
<% rs.movenext
loop %>
</table>
</body>
</html>
我用的 xp系统, acess数据库

conn.open "driver={microsoft access driver (*.mdb)}; dbq="&server.MapPath("db1.mdb")

少了一个“C”

将<% set conn=server.CreateObject("adodb.connection")
conn.open "driver={microsoft acess driver (*.mdb)}; dbq="&server.MapPath("db1.mdb")
%> 这句换成:<%
db_path="db1.mdb"
set conn=server.createobject("adodb.connection")
connstr="provider=microsoft.jet.oledb.4.0;data source="&server.mappath(db_path)
conn.open connstr
%>
还有你得检查一下数据库的属性是否设为了"只读",试试吧