Using Microsoft Access with Lectora
May 4, 2007 12:00 AM
I tried using the sample provided and it doesn't work.This is a simple form designed in Lectora, which is suppose to submit your NT ID, First Name, Last Name and Department to the Microsoft Access database.Am I missing something? I keep getting an Internal Server Error message.Here is my asp code:<%@ Language=VBScript %> <% dim adoConndim rsTestdim strSQLdim sUserIDdim sFirstNamedim sLastNamedim sDepartmentsUserID=Request.form("UserID")' sFirstName=Request.form("FirstName") sLastName=Request.form("LastName") sDepartment=Request.form("Department") Set adoConn = Server.CreateObject("ADODB.Connection") Set rsTest = Server.CreateObject("ADODB.RecordSet") adoConn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;" & "DATA SOURCE=" & Server.MapPath("C:My DocumentsTest.mdb") strSQL = "INSERT INTO Results(UserID,FirstName,LastName,Department) VALUES ( '" & sUserID & "', " & sFirstName & ", " & sLastName & ", " & sDepartment & ")" Set rsTest = Conn.Execute(strSQL) Set rsTest = Nothing adoConn.Close Set adoConn = Nothing%> Edited By: FutureDeveloper on 2007-5-8 10:3:30
Discussions have been disabled for this post