The error I am getting is:
Server.MapPath()[FONT=Arial][SIZE=2]error ‘ASP 0173 : 80004005’[/SIZE][/FONT]
[FONT=Arial][SIZE=2]Invalid Path Character[/SIZE][/FONT]
[FONT=Arial][SIZE=2]/helpmail/processForm.asp[/SIZE][/FONT][FONT=Arial][SIZE=2], line 20[/SIZE][/FONT] [FONT=Arial][SIZE=2]An invalid character was specified in the Path parameter for the MapPath method. [/SIZE][/FONT]
[FONT=Arial]Line20: MyPath=Server.MapPath(“http://www.cincinnati.enq/advertising/onlineAdCounter.mdb”)[/FONT]
[FONT=Arial][/FONT]
[FONT=Arial]The submit button AS:[/FONT]
on(press){
getURL(“http://www.shopatcincinnati.com/helpmail/processForm.asp",0,"post”);
}
My ASP script:
<%@language = "VBScript" %>
<%
strFirst = Request.Form("Name")
strLast = Request.Form("Advertiser")
strEmail = Request.Form("TypeAd")
strLast = Request.Form("Date")
strMessage = Request.Form("OnlineAdTypes")
strMessage = Request.Form("NonAdCustomOnline")
Response.Write(strName) & "<br>"
Response.Write(strAdvertiser) & "<br>"
Response.Write(strTypeAd) & "<br>"
Response.Write(strDate) & "<br>"
Response.Write(strOnlineAdTypes) & "<br>"
Response.Write(strNonAdCustomOnline)
MyPath=Server.MapPath("http://www.cincinnati.enq/advertising/onlineAdCounter.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & MyPath
SQL = "INSERT INTO onlineAdCounter (Name, Advertiser, TypeAd, Date, OnlineAdTypes, NonAdCustomOnline) VALUES ('"&strName&"','"&strAdvertiser&"','"&strTypeAd&"','"&strDate&"','"&strOnlineAdTypes&"' ,'"&strNonAdCustomOnline&"')"
conn.Execute(SQL)
%>
The Access DB resides on an intranet
The ASP script is where all our ASP scripts reside, an external server
[FONT=Arial]My form[/FONT]
http://www.cincinnati.enq/advertising/artistForm.html