This is an example found here:
http://www.w3schools.com
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("northwind.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Select * from Customers", conn
The following information was found here:
http://www.4guysfromrolla.com/webtech/121799-1.shtml
For example, if you had an ASP script running in the /Inc directory, which had the physical path C:\InetPub\wwwroot\Inc, the following two lines:
Response.Write Server.MapPath("somefile.txt") & "<BR>"
Response.Write Server.MapPath("/somefile.txt")
Would produce different output. The first line would use the current directory's physical path as the path for somefile.txt, and would output C:\InetPub\wwwroot\Inc\somefile.txt. The second line of code, due to the beginning forward slash, would use the root physical path, producing C:\InetPub\wwwroot\somefile.txt as the output.