I am getting the error

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 8: Incorrect syntax near 'm'.
/members/addart_process.asp, line 6

<%
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "dsn","sa","password"
mySQL = "INSERT INTO dbo.article (ArticleTitle,ArticleCont,ArticleDate,ArticleAutho r)"
mySQL = mySQL & " VALUES ('" & request.form("ArticleTitle") & "','" & request.form("ArticleCont") & "','" & request.form("ArticleDate") & "','" & request.form("ArticleAuthor") & "')"
oConn.execute (mySQL)
oConn.close
response.Redirect("../done.asp") %>

Any help would be much appreciated.

Thank you,
Jon Turlington

__________________
Thank you,
Jon Turlington

Are you inserting a value that has single quotes in it? For example, does the Article Title data have a ' in it? I've seen that error occur from this. It may help to do a:

Response.Write("mySQL") and look at the sql at the screen, and post that.

If that is the problem, you have to do replace(request.form("ArticleTitle"), "'", "''"). SQL will interpret two '' as one '.

Brian

For some reason the just started working again no clue.

Thank you,
Jon Turlington