Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004

    Unanswered: Error when submitting to SP from ASP page.

    Hi all.

    ======= ERROR MESSAGE ==================
    Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

    [Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string 'Entry Level 1'.

    /learningcentres/questionnaire/updatequestionnaire.asp, line 279
    =======END MESSAGE =====================

    I get the error message above when submitting to a stored procedure, from an asp page.

    Its a simple update which submits to a stored procedure, but I seem to be getting the error before hitting the SP.

    The error occurs whether there is contents on the submitting page or not, I am also not sure if it is relating to the contents of the field directly before the one which contains the ("Entry Level 1") text, which is a combo box, or another field before it.

    I have checked the contents of the form and even if I leave it blank, as a test, I still get the same error message.

    Does the error message relate to contents, or is it a coding issue?

    Any help would be appreciated.


  2. #2
    Join Date
    Jul 2003
    Sounds like coding.. post the relevant ASP code, and the SP if possible...
    That which does not kill me postpones the inevitable.

  3. #3
    Join Date
    Dec 2003
    Please post the ASP code to call the SP.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts