CFMX 7 Getting Bogus DB Error

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default CFMX 7 Getting Bogus DB Error

    Since upgrading to CFMX 7 two weeks ago I have been getting a sporadic database
    error on pages that work 99% of the time. Error is: Error Executing Database
    Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
    Microsoft Access Driver] Operation must use an updateable query.

    Code has not been changed or modified in any way since upgrade and only fails
    2 -3 times per day. Database in question is Microsoft Access. Happens on
    different pages, including a login page with this code:
    update tbl_security_password set
    access_date='#dateformat(now(),"mm/dd/yyyy")#',
    browser='#cgi.http_user_agent#'
    where userid='#form.userid#'


    mooresm Guest

  2. Similar Questions and Discussions

    1. Bogus Code
      I lose the right hand side of my weight-conversation table when viewed through the browser. The code for this table has been taken from a free-code...
    2. Bogus error messages re Perl/lib/CORE/ includes
      Hi, Every now and then I get errors like the following when trying to compile a perl extension (perl 5.8, Win32): ...
    3. /var/mail BOGUS files
      Hi all Linux gurus ! I have on my email server a series of BOGUS files . It's a solaris 9 box with sendmail 8.10.12 My mailboxes ( /var/mail )...
    4. This is such a bogus article
      http://support.microsoft.com/default.aspx?scid=kb;en-us;306165 -- George Hester __________________________________
    5. ftp connects even if address is bogus
      Running a firewall or parent controls software? -- Ken Wickes This posting is provided "AS IS" with no warranties, and confers no rights. ...
  3. #2

    Default Re: CFMX 7 Getting Bogus DB Error

    Is CGI.HTTP_USER_AGENT defined in those instances where the update fails? I know this does not match the error message, but it might be the issue.
    jdeline Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139