none
Having issue adding and updating access data base using asp front end RRS feed

  • Question

  • I am having problem updating or adding data in access using asp code I get HTTP 500 error. But when I select something for display it has not problem processing that command. I have tested the insert statement that is generated in the ASP by putting it in SQL Query in Access, it works.

    Please help

    Tuesday, August 30, 2011 5:56 AM

Answers

  • Hello Jessy,

    As Paul said, could you please post your update code here? And more I quoted some explaination of HTTP Error 500:

    Introduction

    The Web server (running the Web Site) encountered an unexpected condition that prevented it from fulfilling the request by the client (e.g. your Web browser or our CheckUpDown robot) for access to the requested URL.

    This is a 'catch-all' error generated by the Web server. Basically something has gone wrong, but the server can not be more specific about the error condition in its response to the client. In addition to the 500 error notified back to the client, the Web server should generate some kind of internal error log which gives more details of what went wrong. It is up to the operators of the Web server site to locate and analyse these logs.

    500 errors in the HTTP cycle

    Any client (e.g. your Web browser or our CheckUpDown robot) goes through the following cycle when it communicates with the Web server:

    • Obtain an IP address from the IP name of the site (the site URL without the leading 'http://'). This lookup (conversion of IP name to IP address) is provided by domain name servers (DNSs).
    • Open an IP socket connection to that IP address.
    • Write an HTTP data stream through that socket.
    • Receive an HTTP data stream back from the Web server in response. This data stream contains status codes whose values are determined by the HTTP protocol. Parse this data stream for status codes and other useful information.

    This error occurs in the final step above when the client receives an HTTP status code that it recognises as '500'. Frank Vipond. September 2010.

    Fixing 500 errors - general

    This error can only be resolved by fixes to the Web server software. It is not a client-side problem. It is up to the operators of the Web server site to locate and analyse the logs which should give further information about the error.

    Fixing 500 errors - CheckUpDown

    Please contact us (email preferred) whenever you encounter 500 errors on your CheckUpDown account. We then have to liaise with your ISP and the vendor of the Web server software so they can trace the exact reason for the error. Correcting the error may require recoding program logic for the Web server software, which could take some time.

    Could you tell us if you use your IIS?

    I hope this can help you.

     

    Have a nice day,


    Jackie Sun [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Wednesday, August 31, 2011 6:18 AM
    Moderator

All replies

  • Unfortunately, the HTTP 500 error is very common and generic and doesn't help much in identifying the issue. Can you post the update code that you believe is failing? 


    Paul ~~~~ Microsoft MVP (Visual Basic)
    Tuesday, August 30, 2011 1:53 PM
  • Hello Jessy,

    As Paul said, could you please post your update code here? And more I quoted some explaination of HTTP Error 500:

    Introduction

    The Web server (running the Web Site) encountered an unexpected condition that prevented it from fulfilling the request by the client (e.g. your Web browser or our CheckUpDown robot) for access to the requested URL.

    This is a 'catch-all' error generated by the Web server. Basically something has gone wrong, but the server can not be more specific about the error condition in its response to the client. In addition to the 500 error notified back to the client, the Web server should generate some kind of internal error log which gives more details of what went wrong. It is up to the operators of the Web server site to locate and analyse these logs.

    500 errors in the HTTP cycle

    Any client (e.g. your Web browser or our CheckUpDown robot) goes through the following cycle when it communicates with the Web server:

    • Obtain an IP address from the IP name of the site (the site URL without the leading 'http://'). This lookup (conversion of IP name to IP address) is provided by domain name servers (DNSs).
    • Open an IP socket connection to that IP address.
    • Write an HTTP data stream through that socket.
    • Receive an HTTP data stream back from the Web server in response. This data stream contains status codes whose values are determined by the HTTP protocol. Parse this data stream for status codes and other useful information.

    This error occurs in the final step above when the client receives an HTTP status code that it recognises as '500'. Frank Vipond. September 2010.

    Fixing 500 errors - general

    This error can only be resolved by fixes to the Web server software. It is not a client-side problem. It is up to the operators of the Web server site to locate and analyse the logs which should give further information about the error.

    Fixing 500 errors - CheckUpDown

    Please contact us (email preferred) whenever you encounter 500 errors on your CheckUpDown account. We then have to liaise with your ISP and the vendor of the Web server software so they can trace the exact reason for the error. Correcting the error may require recoding program logic for the Web server software, which could take some time.

    Could you tell us if you use your IIS?

    I hope this can help you.

     

    Have a nice day,


    Jackie Sun [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Wednesday, August 31, 2011 6:18 AM
    Moderator
  • Hi Jessy, how's your issue? I'm writing to check the status of your issue, if you have any updates, please feel free to let me know.

     

    Have a good day,


    Jackie Sun [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, September 5, 2011 6:48 AM
    Moderator