Gary Croxford
asked on
ASP Not a Valid Path - Microsoft JET Database Engine error '80004005'
Thank you for looking at my question,
I am trying to put together an asp page that lists data from an MS Access database query.
The access database resides in a folder on the server.
I have created a virtual directory that points to the folder in which the database resides and yet, when I load the page to the web browser I get the error message
Microsoft JET Database Engine error '80004005'
'K:\Team Leader\Production Planning\Data\LSA Production.mdb' is not a valid path.
Use the two bits of code below to make the connection:
<%
strconn_ANOD = "PROVIDER=Microsoft.Jet.OL EDB.4.0;DA TA SOURCE=" &_
server.mappath("AnodSched/ LSA Production.mdb") & ";"
%>
<%
Set con = Server.CreateObject("ADODB .Connectio n")
con.Open strconn_ANOD, "", ""
%>
The problem I have is that K:\Team Leader\Production Planning\Data\LSA Production.mdb is the correct path to the database file I need to interrogate.
Any and all help gratefully received.
I am trying to put together an asp page that lists data from an MS Access database query.
The access database resides in a folder on the server.
I have created a virtual directory that points to the folder in which the database resides and yet, when I load the page to the web browser I get the error message
Microsoft JET Database Engine error '80004005'
'K:\Team Leader\Production Planning\Data\LSA Production.mdb' is not a valid path.
Use the two bits of code below to make the connection:
<%
strconn_ANOD = "PROVIDER=Microsoft.Jet.OL
server.mappath("AnodSched/
%>
<%
Set con = Server.CreateObject("ADODB
con.Open strconn_ANOD, "", ""
%>
The problem I have is that K:\Team Leader\Production Planning\Data\LSA Production.mdb is the correct path to the database file I need to interrogate.
Any and all help gratefully received.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.