Member Avatar for balor

I have this kind of error: (and i can't seem to solve this)
Error Type:
Server.MapPath(), ASP 0172 (0x80004005)
The Path parameter for the MapPath method must be a virtual path. A physical path was used.
/proj/save.asp, line 12

this is my code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%
Dim Conn
Dim Rs
Dim sql

Set Conn = Server.CreateObject("ADODB.Connection")
Set Rs = Server.CreateObject("ADODB.Recordset")

Dim cat
cat = request.form("category")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("c:/db1.mdb")
sql= "Select description, date, by FROM "&cat


Rs.CursorType = 2
Rs.LockType = 3

Rs.Open sql, Conn

Rs.AddNew
Rs.Fields("description") = Request.Form("description")
Rs.Fields("ddate") = Request.Form("ddate")
Rs.Fields("by")= Request.Form("by")

Rs.Update
Rs.Close
Set Rs = Nothing
Set Conn = Nothing
%>

  • 2 Contributors
  • 1 Reply
  • 154 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by william_stam
Member Avatar for william_stam

thats not too much of a problem.

iis isnt configured properly.

1. Click Start, click Administrative Tools, and then click Internet Information Services (IIS) Manager.
2. Double-click your computer name in the left pane, and then double-click Web Sites.
3. Locate the Web site and directory that houses the ASP application.
4. Right-click the application site or directory, and then click Properties.
5. Select Home Directory, and then click Configuration.
6. Click Options, and then click to select the Enable Parent Paths check box.
7. Click OK two times

your on iis 6 (windows server 2003?) its by default disabled

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.