Professional Web Applications Themes

Database update using asp - Macromedia Dynamic HTML

Having a problem getting my database to update from a registration page. Database connected - have insert record set - check new username and if fail go to regfail.asp. - validate form. When I put in an existing person in the database it will go to regfail.asp, but when I put in a new name and information. I just get HTTP 500 error. Website running on Win2003, I do not have complete control over the server. Had to let someone else put the database in and setup the DNS for it. My login page is working using the database....

  1. #1

    Default Database update using asp

    Having a problem getting my database to update from a registration page.
    Database connected - have insert record set - check new username and if fail go
    to regfail.asp. - validate form. When I put in an existing person in the
    database it will go to regfail.asp, but when I put in a new name and
    information. I just get HTTP 500 error.

    Website running on Win2003, I do not have complete control over the server.
    Had to let someone else put the database in and setup the DNS for it. My login
    page is working using the database.

    Maysee42 Guest

  2. #2

    Default Re: Database update using asp

    Turn off friendly HTTP error messages in Internet Explorer:

    Tools > Internet Options > Advanced and uncheck Show friendly HTTP error
    messages

    Then post the exact error you are getting.

    --
    Ken Ford
    Adobe Community Expert - Dreamweaver
    Fordwebs, LLC
    http://www.fordwebs.com


    "Maysee42" <com> wrote in message
    news:frutd1$i1h$macromedia.com... 

    Ken Guest

  3. #3

    Default Re: Database update using asp

    Ok here is the exact error.

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
    query.

    /spl/library/Registration.asp, line 161


    Maysee42 Guest

  4. #4

    Default Re: Database update using asp

    http://livedocs.adobe.com/dreamweaver/8/using/31_trou2.htm#79031

    http://www.adobe.com/go/tn_18984

    --
    Ken Ford
    Adobe Community Expert - Dreamweaver
    Fordwebs, LLC
    http://www.fordwebs.com


    "Maysee42" <com> wrote in message
    news:fs0ls0$elk$macromedia.com... 

    Ken Guest

Similar Threads

  1. Read Point of Sale database and update server database
    By turtle in forum Macromedia ColdFusion
    Replies: 4
    Last Post: July 20th, 09:41 PM
  2. update database
    By JPrice in forum Coldfusion Database Access
    Replies: 6
    Last Post: July 9th, 08:44 PM
  3. Update Database
    By dlp1s in forum Dreamweaver AppDev
    Replies: 8
    Last Post: June 28th, 04:03 PM
  4. update from between database
    By Thomas in forum ASP.NET General
    Replies: 2
    Last Post: July 28th, 11:52 PM
  5. Update on SQL database with stored procedures in another SQL database
    By M in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 23rd, 06:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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