An error occurs when an extra parameter is increased in application as well as stored procedure to the existing one
-
Hi, I am using sql server 2005 and ASP .Net 2.0, VS 2005. When I increased a parameter in Stored Procedure and in application, and again running the application it throws an error that, Parameters does not match with the stored procedure parameters. All i have to do is restart the machine and again run the application. Then it does not throw the error and it works fine with the extra parameter in application as well as in storedproc. I am unable to understand what is the exact problem, that i have to restart the machine and then it accepts the changes
-
Hi, I am using sql server 2005 and ASP .Net 2.0, VS 2005. When I increased a parameter in Stored Procedure and in application, and again running the application it throws an error that, Parameters does not match with the stored procedure parameters. All i have to do is restart the machine and again run the application. Then it does not throw the error and it works fine with the extra parameter in application as well as in storedproc. I am unable to understand what is the exact problem, that i have to restart the machine and then it accepts the changes
I think you'll find it has to do with the way you are running the ASP for development, sound like ASP is cacheing the footprint and rebooting clears out the chache. Try asking in the ASP forum, they may be more helpful.
Never underestimate the power of human stupidity RAH