Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Cannot Find Stored Procedure

Author  Topic  andrewp Starting Member 2 Posts Posted - 2000-10-31 : 02:02:40 I'm trying to call a stored procedure from ASP and I get the following error : Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'sp_get_countries'. 'sp_get_countries' was created by the same uid that connects from the ASP, and the uid has public & db_owner rights. When I replace the 'EXEC sp_get_countries' with the SQL from sp_get_countries (on the ASP page), it works. When I 'EXEC sp_get_countries' from Query Analyzer (connected as the same uid above), it works. Any comments would be much appreciated. Running on MS W2000 Server(sp1), MS Sql7(sp2).