# Flash Forms and Database Integration help

**URL:** <https://forum.kirupa.com/t/flash-forms-and-database-integration-help/185434>\
**Category:** Uncategorized\
**Created:** [April 13, 2006, 11:21am UTC](https://forum.kirupa.com/t/flash-forms-and-database-integration-help/185434 "2006-04-13T11:21:55Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Papper](https://avatars.discourse-cdn.com/v4/letter/p/958977/32.png) [@Papper](https://forum.kirupa.com/u/Papper)\
**Post date:** [April 13, 2006, 11:21am UTC](https://forum.kirupa.com/t/flash-forms-and-database-integration-help/185434/1 "2006-04-13T11:21:55Z")

</div>

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

> **[kirupa.com - Flash Forms and Database Integration](https://www.kirupa.com/developer/actionscript/forms_database.htm)**
>
> Learn how to use Flash and ASP to send data from a form to a database.

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.

---

<div class="post-metadata">

**Author:** ![Papper](https://avatars.discourse-cdn.com/v4/letter/p/958977/32.png) [@Papper](https://forum.kirupa.com/u/Papper)\
**Post date:** [April 16, 2006, 2:23pm UTC](https://forum.kirupa.com/t/flash-forms-and-database-integration-help/185434/2 "2006-04-16T14:23:37Z")

</div>

_bump_

---

<div class="post-metadata">

**Author:** ![KaiLok](https://avatars.discourse-cdn.com/v4/letter/k/7bcc69/32.png) [@KaiLok](https://forum.kirupa.com/u/KaiLok)\
**Post date:** [April 17, 2006, 1:33pm UTC](https://forum.kirupa.com/t/flash-forms-and-database-integration-help/185434/3 "2006-04-17T13:33:57Z")

</div>

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??

---

<div class="post-metadata">

**Author:** ![Digitalosophy](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/digitalosophy/32/1114_2.png) [@Digitalosophy](https://forum.kirupa.com/u/Digitalosophy)\
**Post date:** [April 17, 2006, 8:27pm UTC](https://forum.kirupa.com/t/flash-forms-and-database-integration-help/185434/4 "2006-04-17T20:27:42Z")

</div>

@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](http://www.google.com/search?q=ADODB.Connection.1+%280x800A0BB9%29&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

> **[kirupaForum](https://www.kirupa.com/forum/search.php?searchid=504145)**
>
> Got a web design/development question or just want to hang out with the most awesome people on the planet? Drop on in!

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

---

<div class="post-metadata">

**Author:** ![Papper](https://avatars.discourse-cdn.com/v4/letter/p/958977/32.png) [@Papper](https://forum.kirupa.com/u/Papper)\
**Post date:** [April 23, 2006, 2:38pm UTC](https://forum.kirupa.com/t/flash-forms-and-database-integration-help/185434/5 "2006-04-23T14:38:36Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![bootiteq](https://avatars.discourse-cdn.com/v4/letter/b/eb9ed0/32.png) [@bootiteq](https://forum.kirupa.com/u/bootiteq)\
**Post date:** [April 25, 2006, 9:13am UTC](https://forum.kirupa.com/t/flash-forms-and-database-integration-help/185434/6 "2006-04-25T09:13:56Z")

</div>

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.