Hi, I downloaded a Flash/ASP contact form system and am trying to use it on my website. The ASP code it is using is:
[asp]
<%@language = “VBScript” %>
<%
strFirst = Request.Form(“fname”)
strLast = Request.Form(“lname”)
strEmail = Request.Form(“email”)
strTelephone = Request.Form(“telephone”)
strMessage = Request.Form(“message”)
Set Mailer = Server.CreateObject(“CDONTS.NewMail”)
Mailer.From= strEmail
Mailer.To= “mirracle4@hotmail.com”
Mailer.Subject=“Database Form”
Mailer.BodyFormat=0
Mailer.MailFormat=0
Mailer.Body = “Hello Your Name Here” & “<br>” & _
“<br>” & _
"My First Name is: " & strFirst & “<br>” & _
"My Last Name is: " & strLast& “<br>” & _
"My E-mail is: " & strEmail & “<br>” & _
"My Phone Number is: " & strTelephone & “<br>” & _
"My Question or Comment is: " & strMessage & “<br>”
Mailer.Send
set Mailer = nothing
'The path to you MS Access DB
MyPath=Server.MapPath(“example.mdb”)
Set conn = Server.CreateObject(“ADODB.Connection”)
conn.Open “Driver={Microsoft Access Driver (*.mdb)};” & _
“DBQ=” & MyPath
SQL = “INSERT INTO contacts (FirstName, LastName, Email, Telephone, Message) VALUES (’”&strFirst&"’,’"&strLast&"’,’"&strEmail&"’,’"&strTelephone&"’,’"&strMessage&"’)"
conn.Execute(SQL)
%>
[/asp]
It came with a Flash file that is supposed to open the ASP file when all the fields are typed in and the submit button is clicked. But after I click submit, a new window pops up with this message:
“Microsoft OLE DB Provider for ODBC Drivers[FONT=Arial][SIZE=2]error ‘80004005’[/SIZE][/FONT]
[FONT=Arial][SIZE=2][Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key ‘Temporary (volatile) Jet DSN for process 0x12cc Thread 0x13e0 DBC 0x162194c Jet’.[/SIZE][/FONT] [FONT=Arial][SIZE=2]/processForm.asp[/SIZE][/FONT][FONT=Arial][SIZE=2], line 29”[/SIZE][/FONT]
But it still sends the email and works. But I was wondering, how can I get rid of that error message and instead of that page opening up, is there a way to just link to another page that I will make that says “your message has been submitted” or something?
If you need to know the actionscript in the flash file it’s on the keyframe and goes like this:
submit_btn.onRelease = function() {
getURL(“http://www.garybmx.com/processForm.asp”, “0”, “POST”);
}
Any help is appreciated. Thanks a lot!
