receive internal error 500

Author	Thread
receive internal error 500
Posted in tutorial: An ASP Tutorial to create your own News Letter
· 007chick Joined: 8 Jan 2003 Total Posts: 1	receive internal error 500 Posted: 8 Jan 2003 hi, i receive this error when trying to submit an email address, any ideas on how to fix this problem? HTTP 500.100 - Internal Server Error - ASP error Internet Information Services -------------------------------------------------------------------------------- Technical Information (for support personnel) Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /mail_ac.asp, line 24 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Page: POST 24 bytes to /mail_ac.asp POST Data: email=lalala@yahoo.com Time: Wednesday, January 08, 2003, 10:11:35 AM More information:
· Faisal Khan Joined: 24 Sep 2002 Total Posts: 547	Re: receive internal error 500 Posted: 15 Feb 2003 Yes, you are receiving it because the database doesn't have WRITE permission for the user IUSR_MACHINENAME. Just give the database ( or the container folder ) READ and WRITE permission for the user IUSR_MACHINENAME ( substitute MACHINENAME with the name of your local computer ), and it should work. Faisal Khan. Stardeveloper.com
· tedhatano Joined: 20 Aug 2003 Total Posts: 1	Re: receive internal error 500 Posted: 20 Aug 2003 Yes, you are receiving it because the database doesn't have WRITE permission for the user IUSR_MACHINENAME. Just give the database ( or the container folder ) READ and WRITE permission for the user IUSR_MACHINENAME ( substitute MACHINENAME with the name of your local computer ), and it should work. ______________ Could you explain how to do it? I am an absolut beginner! Thank you very much.
· Cryix Joined: 28 Aug 2003 Total Posts: 2	Re: receive internal error 500 Posted: 28 Aug 2003 I'm having a similar problem. I have an asp form that is linked to a SQL Server database through an ODBC connection. I can retrieve information out of it for searches, but i cant seem to insert a new record into it using my form. It calls the asp script but then i get a 500 error. Ive tried disabling the friendly error message thing as suggested elsewhere on the site, but when i do that, i end up with just a blank page when it goes to my asp page. Any thoughts?
· Cryix Joined: 28 Aug 2003 Total Posts: 2	Re: receive internal error 500 Posted: 28 Aug 2003 I am having a similiar problem. I am trying to submit a form to an MS SQL database using golive asp. When i hit the submit button, it processes a form called ado.actions6.asp and i get a 500 error. Ive tried turning off the friendly error reporting and when i do, i just get a blank page. As far as i can tell, i have full permission for the username im using to access the database. Any help would be appreciated