Does that get turned off when ever you reboot? I thought I had it sent but anyway I did it again and I get the following:
Microsoft Office Access Database Engine error '80004005'
Unspecified error
/Untitled-1.asp, line 9
Here is my Connection parameters
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_Filters_STRING
MM_Filters_STRING = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\inetpub\wwwroot\db\AirManageFilters.accdb;"
%>
And this is the very simple display that I am try to test.
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include virtual="/Connections/Filters.asp" -->
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows
Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_Filters_STRING
Recordset1_cmd.CommandText = "SELECT * FROM Filters"
Recordset1_cmd.Prepared = true
Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = 10
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<%
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF))
%>
<table width="850" border="0">
<tr>
<td><%=(Recordset1.Fields.Item("Description").Value)%></td>
<td><%=(Recordset1.Fields.Item("Part #").Value)%></td>
<td><%=(Recordset1.Fields.Item("MFG").Value)%></td>
</tr>
</table>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
One thing that is strange is when I try and use the "Server.Mapping" instead of the direct path the connection doesn't work. At least it doesn't like it in the DreamWeaver custome connection string. I was going to work on this next but maybe one thing has to to with the other.
The error that is showing up in the log is:
GET /Untitled-1.asp |9|80004005|Unspecified_error 80 - ::1 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+SLCC1;+.NET+CLR+2.0.50727;+Media+Center+PC+5.0;+.NET+CLR+3.0.04506;+.NET+CLR+1.1.4322) 500 0 0