7 Replies Latest reply on Jul 15, 2009 9:18 AM by martinx

    Problem: erratic success of an entry form to a SQL database.

    martinx

      Problem: erratic success of an entry form to a SQL database.

      Description: ColdFusion 8 form with 169 fields inserts into a SQL database running 2000 SQL. on Windows 2003 server.

      1. Worked consistently between the hours of 8:30am and 1:00pm and then ceases to insert until the next morning.

      2. On July 8, 2009, repeated the same pattern and as a test, tried to enter a record from offsite at 12:20am July 9 to ascertain when the application would again successfully insert a record. The entry form succeeded!

      3. At 7:38am July 9 the entry failed.

      4. No error message, simply returns the last successful entry.

       

      Any ideas?