I'm trying to pass variables from one application (lectora) into a simple access database. The database is named n395eval.mdb and the DSN connection on the web server is named MyTable_dsn.dsn. I keep getting 500 errors when trying to pass the simple variables. I made sure the database was modifiable to all "users". Can anyone see anything obvious in my code below?

<%@ Language=VBScript %>
<%

DIM score
DIM time
DIM date
DIM title

'Get the parameters posted from the lectora test titled "Final"'

score=Request.form("Final_Score")
time=Request.form("VarElapsedTime")
date=Request.form("VarCurrentDate")
title=Request.form("VarCurrentTitleName")


'First create Connection and Recordset objects'

    Set MyConn =Server.CreateObject("ADODB.Connection")

    MyConn.Open "DSN=c:\program files\common files\odbc\data sources\myTable_dsn"

    Set Rs = Server.CreateObject("ADODB.RecordSet")




'Now, create the SQL statement'

    sSQL = "INSERT INTO MAIN(Score,time,date,title) VALUES ( '" & score & ", " & time & ", " & date & ", '" & title & ")"



'Execute the SQL statement, and set the recordset object to the result of this execution. We obtain the resulting records in Rs object'

    Set Rs = MyConn.Execute(sSQL)

'Close the Recordset object and destroy it'
    Set Rs = Nothing

'Release the resources for connection object'

    MYConn.Close
    Set MyConn = Nothing
%>

Thank you in advance for any input!
D'sarge

Hi there,

What error do you get exactly? A 500 error is quite generic an can be caused by a lot of problems...

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hello Imar,

The exact message I'm receiving is:

Unable to post test data to host, cannot submit results! Server returned HTTP response code: 500 for URL: http://numdet01/courses/test/ironv2/submit.asp

The http path is correct. Thank you for helping me with this!!

Regards,
Dennis

Strange, I have never seen that error before.

Can you show us a trimmed version of the code from the initial page with the form elements, and the ASP you post to and that must insert the data in the database?

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Stay by Tricky (Track 1 from the album: Vulnerable) What's This?

Hello Imar,

I figured out my problem. Some of my column names in access were reserved variables. Once I changed the name to something like current_time instead of time, it worked fine.

Thank you for the input!!

Best Regards,
Dennis