yntax error in INSERT INTO statement.

Description: An unhandled exception occurred during the execution of

the current web request. Please review the stack trace for more

information about the error and where it originated in the code.



Exception Details: System.Runtime.InteropServices.COMException: Syntax

error in INSERT INTO statement.



Source Error:











Line 192:

Line 193:con.Open(constr)

Line 194:res.Open(s1, con)

Line 195:con.close()

Line 196:con = nothing





Source File: C:\Accounts\planetha\email\install\update_db.aspx    Line:

194



Stack Trace:











[COMException (0x80040e14): Syntax error in INSERT INTO statement.]

   ADODB.RecordsetClass.Open(Object Source, Object ActiveConnection,

CursorTypeEnum CursorType, LockTypeEnum LockType, Int32 Options)

+0

   ASP.update_db_aspx.__Render__control1(Html TextWriter __output,

Control parameterContainer) in C:

\Accounts\planetha\email\install\update_db.aspx:194

   System.Web.UI.Control.RenderChildren(HtmlT extWriter writer) +27

   System.Web.UI.Control.Render(HtmlTextWrite r writer) +7

   System.Web.UI.Control.RenderControl(HtmlTe xtWriter writer) +243

   System.Web.UI.Page.ProcessRequestMain() +1929

Hi



Ok I moved the site to a new host, Still getting same error.

Can you fix this,otherwise i do not need it, and would like a refund.



Thanks for

Thanks for all your help



Gary