Help For Flash Forms and Database Integration

[clemi]

Hi to everybody.
I found this source file on this site at the page http://www.kirupa.com/developer/actionscript/forms_database.htm

but the form do not work...

someone can help me? Can you take a look to understand what's wrong?
thank you so much.
Clemi

[joran420]

does your server have ASP? and do you have a microsoft access Database setup? i have neither ASP or microsoft access....so cant help much

[Digitalosophy]

^ If the above it true...

Make sure your database path if correct.


MyPath=Server.MapPath("example.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & MyPath


If that is correct then make sure your Flash URL is correct.


on(press){
loadVariablesNum("http://yourSite.com/processForm.asp",0,"post");
}


On top of that your should use LoadVars() - that tutorial was written 4 years ago.

edit: Moved to server side

[clemi]

I use Flash 8.
I tried all the possible combination but it do not work.
I tried also the original source file but it do not work
I don't know if I forgot something in the vars or on the asp...
can you check the file source I attached?
thnks

this is my asp code:

<%@language = "VBScript" %>
<%
strFirst = Request.Form("fname")
strLast = Request.Form("lname")
strEmail = Request.Form("email")
strAddress = Request.Form("address")
strZip = Request.Form("zip")
strCountry = Request.Form("country")
strPhone = Request.Form("phone")

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, Address, Zip, Country, Phone) VALUES ('"&strFirst&"','"&strLast&"','"&strEmail&"','"&strAddress&"','"&strZip&"','"&strCountry&"','"&strPhone&"')"
conn.Execute(SQL)
%>



and my Flash URL on the submit botton is:

on(press){
loadVariablesNum("http://nobraingroup.com/processForm.asp",0,"post (http://nobraingroup.com/nobraingroup/processForm.asp)");
}

[clemi]

...

[Digitalosophy]

Well if I visit http://nobraingroup.com/nobraingroup/processForm.asp directly I get bounced back to the root of the server which is weird.

Do a hello world asp file and see if your server at least runs ASP. Not sure what else to see you at this point.

[clemi]

hello world asp file? what is it?

just to Know...you have check all the structure of the flash file and the access file?
because maybe the mistake is there?

[Digitalosophy]

The files from the tutorial work.