1 Reply Latest reply on Dec 1, 2008 3:57 PM by jcrossfield

    ODBC SequeLink error on INSERT ... QUERY FAILED

    jcrossfield

      Title

      ODBC SequeLink error on INSERT ... QUERY FAILED

      Your post

      Hi I have an .asp site that queries our Filemaker database hosted on FMS9 Adv and it usually runs fine without problems.  However about twice a day a random user gets the following error:  MICROSOFT OLE DB Provider for ODBC Drivers error "80004005" 

      [DataDirect][ODBC SequeLink Drive][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker] Query Failed

      This error occurs on an INSERT statement on the Set rsInfo = oConn.execute(strSQL). I don't see anything wrong in the code and it works successfully on dozens of instances of the same event each day.

      Please let me know if you have any ideas or need any more clues. Thank you for your time!<!--  POLLS  --><!--  FILES  --><!--  SIGNATURE  -->

        • 1. Re: ODBC SequeLink error on INSERT ... QUERY FAILED
          jcrossfield
            

          I found out what the problem was, and came up with a workaround solution, but I am running into this problem again but with a different error code in another query and I'm still looking for a workaround....

           

          Anyway, this error was caused by a date field in the query using a 10 digit date...in other words a "mm/dd/yyyy" date crashes the query, which is why this just started popping up at the end of the year...  9/31/2008 in the query is ok  but 10/31/2008 crashes the query. I do not know why...any ideas?