Sry if there’s already a question about this but I need help with http://www.kirupa.com/developer/actionscript/forms_database.htm
This is what I got in the asp file:
<%@language = "VBScript" %>
<%
strFirst = Request.Form("fname")
strLast = Request.Form("lname")
strEmail = Request.Form("email")
strMessage = Request.Form("message")
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, Message) VALUES ('"&strFirst&"','"&strLast&"','"&strEmail&"','"&strMessage&"')"
conn.Execute(SQL)
%>
but when I get to this page from the swf form i get this error:
[COLOR=#000000][FONT=verdana]
Error Type:
ADODB.Connection.1 (0x800A0BB9)
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
/processForm.asp, line 11
[/FONT][/COLOR]
And line 11 is
conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
so i guess it’s something wrong with that line.
I’m new to this and I would like some comments on what to do.