You have to close the connection first before issuing a response.redirect, well you should at least, or else it can cause an error, or leave too many copies of the connector open. I would have to do research on that to confirm it, but I don't redirect when reading or writing data to a database.
Response.Redirect is the last thing you want to do in a sub, after closing and disposing of objects.
It's actually better to write a function without response.redirect, and have the function return a result or exit code, and then redirect.
if (0 = createStoredProcedure()) then
Last Visit: 31-Dec-99 19:00 Last Update: 26-Feb-15 16:08