Hi,
I have downloaded a very simple ASP tutorial at this site
[size=3][font=Times New Roman]http://www.kirupa.com/developer/actionscript/forms_database.htm[/font][/size]
showing how to work with asp and access databases. It though gives me an error message that I cannot figure out how to come around:
ADODB.Connection.1[font=Times New Roman][size=3] [/size][/font][font=Arial][size=2]error ‘800a0bb9’[/size][/font][font=Times New Roman][size=3] [/size][/font]
[font=Arial][size=2]The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.[/size][/font] [font=Arial][size=2]/processForm.asp[/size][/font][font=Arial][size=2], line 12[/size][/font]
It seems as if the database cannot open ?
In case you should have any suggestions I will welcome them since I have now been working with this for 5-6 days now. Please note I am new to ASP so if you could be specific in your answer it would be appreciated a lot.
best regards
The ASP script:
<%@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)
%>
