Inserting data in MDB via Flash and ASP

programming
1

Hi guys,

I have been trying to create a database which I humbly followed by one of Kirupa’s tutorial. It is the Database Integration using Flash, ASP and Microsoft Access (MDB). I really frustrated because I can’t get it to work and honestly speaking, I have been trying for almost 2 months now. Any help would be greatly appreciated.

Here is my ASP code:

<%@language = “VBScript” %>
<%

strRaffles = Request.Form(“raf”)
strDiscovery = Request.Form(“dis”)
strMarket = Request.Form(“mar”)

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

SQL = “INSERT INTO noc (raf, dis, mar) VALUES (’”&strRaffles&"’,’"&strDiscovery&"’,’"&strMarket&"’)"
conn.Execute(SQL)
%>

In Flash, I have a button that has this code:

on (press) {
loadVariablesNum("…/nocbridge.asp", 0, “POST”);
}

I have read another forum that suggests instead using variables for the input boxes, use instance name. So I did.

I don’t know what I am doing wrong and values aren’t passed in the MDB file nor any rows are being added.

Please help as i am very near to give up on this :frowning:

Thank you very much.