If you don't want to see the error again, you need to fix the problem ;)

Apparently, the code cannot find the procedure. This can be caused by a few situations:

1. The procedure does not exist in your database.
2. The user account is not allowed to access the database that has the procedure. It then logs in into its own default database that does not have this procedure....

Hope this helps,

Imar

thanks the code can find the procedure that is why it is updating the site and i can see the effect on the web page, because this codes above are in the CMS so the changes are seen on the webpage, that means it can see the procedure and it inserts, but i can not take away the this page can not be dispalyed, i have to refresh for the actual page to load .

In that case, take a look here to learn how to turn off "friendly" http error messages and run the page again: http://imar.spaanjaars.com/QuickDocId.aspx?QUICKDOC=264

There might be more errors in your page.....

Imar