Response.Redirect Error

Generic 500 Error

[dabrisz]

Created a page to update db. ASP executes the update but errors out on the redirect. Only if redirect address is relative.

[Woz]

What error message are you getting?

onya
Woz

[dabrisz]

a generic

HTTP 500 - Internal server error
Internet Explorer

[dabrisz]

Working with ASP(vbscript), ACCESS, IIS 5.0 Windows 2000. update page is vbscript no html to send to browser. specified buffer to true even though it's the default in WD2k. ???? Is it a setting in IIS or WD2k.

[Xoc]

Welcome to WebmasterWorld.

Yes. Under Home Directory/Configuration/App Options in IIS manager.

It sounds like you have a syntax error in the Response.Redirect line, but I'm just guessing.

[dabrisz]

Thanks for the help!!
Dim n_location
n_location = "/edit.asp?proj_id=" & varproj & "&sponsor_id=" & varsponsor
Response.Clear
Response.Redirect n_location
If n_location is an absolute address to any other server it will work???

[dabrisz]

Finally got better error info

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/ugxp/update_actions.asp, line 31

[bmcgee]

This error is occuring during the database update, not during the response.redirect.

msdn.microsoft.com has plenty of help on this error if you search for the error message text you are getting.

Probably either bad directory settings on your server, or you are updating a read only recordset.

[dabrisz]

Thanks for the help bmcgee, I am new to asp and web programming. I had changed my code so many times that I created the last posted error. With that error corrected I still have a 500 Internal Server Error when I redirect as a relative.
I do not want to use an absolute link. Has anyone ever encountered this before or, am I missing the obvious?

[Quantum]

Try using Server.Transfer instead of Response.Redirect - under IIS5 for me Response.Redirect doesn't work if I'm transfering to another ASP page (at least while using a global.asa file, don't know about otherwise). But Server.Transfer is specifically built to handle such a transition. You can find more documentation about it here:

[4guysfromrolla.com...]
and here:
[msdn.microsoft.com...]