I am getting the following error.

========================================

Server Error in '/email' Application.

---

Syntax 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

[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(HtmlTextWriter __output, Control parameterContainer) in  D:\web\kyfirewire.com\html\email\install\update_db.aspx:194
 
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +27
   System.Web.UI.Control.Render(HtmlTextWriter writer) +7
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
   System.Web.UI.Page.ProcessRequestMain() +1929

Melanie

This is happening on the install.  I am doing nothing that I know of to cause this.

Melanie

Hi !

Also make sure the Virtual directory name is not mail - on some mail servers   this may  give an error

Thanks
Suhail kaleem
mailyoulike.com