UC知道ASP数据库出错
来源：百度知道 编辑：UC知道 时间：2024/06/08 08:01:27
路径正确，打开网页只有“数据库连接出错”字样，CONN文件代码如下:
<%
starttime=timer()
DB = "data/data.mdb"
ConnStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath(db)
On Error Resume Next
Set conn = Server.CreateObject("ADODB.Connection")
conn.open ConnStr
If Err Then
err.Clear
Set Conn = Nothing
Response.Write "数据库连接出错。"
Response.End
End If
%>
<%
starttime=timer()
DB = "data/data.mdb"
ConnStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath(db)
On Error Resume Next
Set conn = Server.CreateObject("ADODB.Connection")
conn.open ConnStr
If Err Then
err.Clear
Set Conn = Nothing
Response.Write "数据库连接出错。"
Response.End
End If
%>
On Error Resume Next
ConnStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath(db)
Set conn = Server.CreateObject("ADODB.Connection")
conn.open ConnStr
If Err Then
err.Clear
Set Conn = Nothing
Response.Write "数据库连接出错。"
Response.End
End If
看你的DB的数径对不对
<%
set conn=server.createobject("adodb.connection")
conn.provider="microsoft.jet.oledb.4.0;"
conn.open server.mappath("data\data.mdb")
%>
链接数据库代码
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
连接字串中不要存在空格，只有data Source处有一个空格