上海公安局微博乔任梁:Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
来源:百度文库 编辑:神马品牌网 时间:2024/10/04 16:35:10
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数据库
[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
%>
还有你得检查一下数据库的属性是否设为了"只读",试试吧
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4E)
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Microsoft OLE DB Provider for SQL Server 求救~~
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Microsoft OLE DB Service Components 错误 '8000ffff'
Microsoft OLE DB Service Components 错误 '8000ffff'
Microsoft OLE DB Provider for ODBC Drivers (0x80040E2F)
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)