Microsoft Office Access Database Engineerror '80004005'
'C:\Users\mkrout\Documents\Ideadudes_be.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/CustomerList.asp, line 13
<html>
<head>
<title>ADO First Test</Title>
<body>
<b>Here is a listing of all records in the Customers Database of Ideadudes.mdb!</b>
<hr>
<%
Dim strConnect
strConnect = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath("./ideadudes.mdb")
Response.Write strConnect
Set CustomersConn= Server.CreateObject("ADODB.Connection")
CustomersConn.Open strConnect
Set CustomersRS = CustomersConn.Execute("Select * From Customers")
%>
<p> Connecting to Access with OLe Connection</p>
<table border="1">
<%
Do While Not CustomersRS.EOF
%>
<tr>
<td><%=CustomersRS.Fields(1).Value %></td>
<td><%=CustomersRS.Fields(2).Value %></td>
</tr>
<%
CustomersRS.MoveNext
Loop
%>
<%
CustomerRS.Close
Set CustomerRS = Nothing
CustomersConn.Close
Set CustomersConn = Nothing
%>
</body>
</html>
This is just sample that I am working on. This is frustrating. As you can see I am pulling th information from the server using Server.MapPath. But, this keeps coming up and I can not find where it is coming from. This is Classic ASP running on IIS 7 on Windows Server 2008 SP2. Now I know there are easier ways of doing this with .Net and I wish I could use it but the client I am working with does not want to make the jump at this point. So, I need to figure this out.
Trying to get reaccumulated to ASP after spending time in ASP.Net.
Can someone please help me?
Thanks,
Michael W Krout, MCSE, MCTS, MCITP, MCT
michael@ideadudes.biz