Jeg får følgende fejlmeddelelse når jeg kører et script der viser indholdet
af en access-database:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 97 Driver] '(unknown)' isn't 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.
/flc/lagersalg.asp, line 44
Scriptet jeg kører ser sådan ud:
<%
Dim DB, DBSti, SQL, rs, produkt
Set DB = Server.CreateObject("ADODB.Connection")
DBSti = "DBQ=" & Server.Mappath("DB/lager.mdb")
DB.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBSti
SQL = "select * from lager ORDER By pris, produkt"
Set rs = db.Execute (SQL)
If not rs.eof then
Response.Write ""
Do until rs.eof
Produkt = rs("Produkt")
Response.Write "<table border='0' cellspacing='1'
cellpadding='4' width=''>"
Response.Write "<tr>"
Response.Write "<td width=300 valign=top
bgcolor='#565F70'>"
Response.Write "<a href=""vis_lagersalg.asp?ID=" &
rs("ID") & """><b>" & Produkt & "</b></a>"
Response.Write "<td width=40 align=center valign=top
bgcolor='#565F70'><b>" & rs("antal") & "</b>"
Response.Write "<td bgcolor='#565F70' width=100
valign=top align=center><b>" & rs("pris") & ",-</b>"
Response.Write "</td></tr></table>"
rs.movenext
Loop
End if
%>
Hvor sætning 44 er:
DBSti = "DBQ=" & Server.Mappath("DB/lager.mdb")
Er der noget der skal installeres på serveren?
--
Esben