ASP http 500 error... what in the name of...?!!!!!..

[Roel018]

Hi all,

Normally this kind of code works for me, but I guess i'm overseeing somthing (in the code)..

I have a database named passwords.mdb in the webroot\accessdata folder and a simple asp file named addpass.asp in the webroot\start\visitors\register\asp folder.

Now, the addpass.asp looks like this:


<%
Dim DBConn, strDB, strInsertSQL, strUserid, strSecuritycode


strDB = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../../../../accessdata/passwords.mdb")

strUserid=Request.form("flash_userid")
strSecuritycode=Request.form("flash_securitycode")

strInsertSQL="Insert Into tempdata (userid,securitycode) Values ('" & strUserid & "','" & strSecuritycode & "')"

Set DBConn = Server.CreateObject("ADODB.Connection")
DBConn.Open strDB
DBConn.execute strInsertSQL
response.write "temporarypasswritten=confirmed"

DBConn.close
Set DBConn=Nothing
%>

However when I send a webroot\start\visitors\register\asp\addpass.asp?flash_userid=blabla&flash_securitycode=blabla to my browser I get a http 500 internal server error !!!!...

I have allready tried to replace the value for the strDB variable to: Provider=Microsoft.Jet.OLEDB.4.0; etc. but that doesn't seem to work either....

Please please please help me !
Thnx !
Roel

 

[Roel018]

(By the way: the name of the table in my database passwords.mdb is indeed "tempdata" ;-)

Roel

 

[jeepxo]

500 error eh...10 bucks says the IUser account doesn't have permissions on the folder where the database is.

&quot;Every day is like a precious gift, you have to make it count&quot; James Birrell 1993-2001

 

[Roel018]

SOLVED !!!!!!

I've solved the problem myself actually.....

it should be var = Request("flash_userid")
instead of Request.form("flash_userid")

Thanks anyway !

Cheers
Roel