Stored procedure not running through web app.

[bjswift]

I have a stored procedure which accepts 8 parameters, and I have a screen which sets up those parameters, and runs the stored procedure. However, the screen will not finish running the stored procedure, and will time out if I let it run long enough.

However, I've stepped through the app, making sure the parameters are what they should be, and even ran the stored procedure with query analyzer with the same parameters, and it runs within 10 seconds.

I have no idea where to start. The app used to work, until I added a parameter, and added an option the user can choose that sets that parameter...

Thanks.

[Alsvha]

Are you sure that the connection to the database is intact? I know you say you have only altered one parameter, but it sounds as if the database connections times out, so I'd start with investigating whether the connection is infact still there.

Have you tried running another - to see if you still can run stored procedures from within your code?

If it does, then it is clear that the problem has arisen from your latest changes, and I'd try to revert back to the code you had before, double check that it runs as wanted, and then try in small steps to bring back your changes. That would be my course of action in trying to debug this issue.

Hope you find the problem.