Flash Forms and Database Integration help

1

Sry if there’s already a question about this but I need help with

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 asp and php though i know plenty about flash and I would like some comments on what to do.

2

bump

3

I have exactly the same question as you.
I am trying to connect to Oracle database.
Howevery i found it difficult as i don’t know what to type for:

Server.CreateObject("[COLOR=red]ADODB.Connection[/COLOR]")

and

conn.Open “[COLOR=red]Driver={Microsoft Access Driver (*.mdb)};” & _
“DBQ=” & MyPath[/COLOR]

What are them respectively and what should i type to connect to oracle??

4

@Papper: I ran a search for that error code. Try digging through some of these
http://www.google.com/search?q=ADODB.Connection.1+(0x800A0BB9)&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official

Off the top I have no idea what’s wrong.

Also you can look through some similiar threads here

@Kailok: sorry i have never connected to oracle, try searching google.

5

but is the script working for you?
i even tried to download the finished files but that didn’t work either :S

6

Thats odd.

my only guess is that you are trying to pass a non value into your database.

this can occur when flash player (made from mx2004 I think) cant find a document called ‘crossdomain.xml’. From memory it looks for this file whenever flash uses loadvariables, sendandload … etc…

search google for:
macromedia crossdomain.xml

I had excactly the same problem recently. this fixed it.