FLASH -> ASP -> MS-Access : PLEASE HELP

[cloud7]

i just read an old thread in this forum.
but it was posted last year.

[webmasterworld.com...]

anyone knows about this topic?
becoz i tried out his codings, but it doesnt work.

i need to connect my flash to a DB, through an asp file.
this is wat my asp looks like.

<% Language = "VBScript" %>

<%

Dim conn
Dim rs
Dim query

'Create a connection odject
Set adoCon = Server.CreateObject("ADODB.Connection")
Set adoRec = Server.CreateObject("ADODB.Recordset")

'Open connection to the database driver
strCon="DRIVER={Microsoft Access Driver (*.mdb)};"

'Open Connection to database
strCon = strCon & "DBQ=" & Server.MapPath("studDB.mdb")

'Initalise the strSQL variable with an SQL statement to query the database
strSQL = "INSERT INTO information VALUES('" & Request("name_out") & "', '" & Request("admin_out") & "', '" & Request("group_out") & "', " & Request("score") & ");"

adoCon.Open strCon

'Write to the database
adoCon.Execute(strSQL)

'Reset Sever Objects
Set adoCon = Nothing

%>

in my flash, there are 4 textfield variables.
name_out
admin_out
group_out
score

i placed this coding at the last frame.

loadVariables ("studDB.asp", "0", "GET");

can anyone tell me wats wrong?

[aspdaddy]

I tried this a while back, so flash may support it now, but the only way I got it work was reading from a text file or the querystring.

One solution I used in an ASP script works :

1 - detete the text file temp
2 - qry the database
3 - save the data to text file temp

The page loads and the flash object reads values from temp using loadVaraible()