Hello, I am starting to learn ASP and I ran into a problem that is completley stumping me. I can not figure out what is wrong! I keep on getting a "500 Internal server error"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
' Declaring variables
Dim Date, News, sql_insert
' Receiving values from Form
Date = (Request.Form("Date"))
News = (Request.Form("News"))
data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
sql_insert = "insert into News (Date, News) values ('" & _Date & "', '" & News & "')"
' Creating Connection Object and opening the database
Set con = Server.CreateObject("ADODB.Connection")
' Done. Close the connection
Set con = Nothing
Response.Write "All records were successfully entered into the database."
if you could please email me at email@example.com
or respond to this post with anything that could be wrong with this.