Occassional (and unpredictable) 'Could not find stored procedure' erro

[kristof]

Hi,

We (the development team) get a re-occuring occassional error:

Error : System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.OleDb.OleDbException: Could not find stored procedure 'sp_***'. (pageinfo ...) --- End of inner exception stack trace ---

All signs indicate that everything is ok, except that it sometimes just doesn't seem able to connect. When that happens, there is no sign whatsoever indicating any kind of reason why it would go wrong, it just does.

Can anyone shed some light on this weird situation?

 

[ca8msm]

Could not find stored procedure 'sp_***'

That suggests that it is connecting but can't find the stored procedure. Have you just obscured the sp name with asterisks? Also, is this a system stored procedure or one you have created?

I'd try asking in the SQL Server forum as it is a SQL Server error message you are getting, not an ASP.NET one.



-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]