Hi everybody,

   I created several stored procedure in a local sql server 2005 express
database, now when I call/execute them in the asp.net 2.0 web page, it
returns an error message of "Cannot find the stored procedure '<proc_name>'",
this is funny, when I execute the command in a sql query window "exec
sp_GetAllArticles", it also returns cannot find stored procedure, but when I
execute the "Use <DBName>" and then execute the statement, it works. The sql
connection used in codes is ok.
So, what I have missed to set or where I made mistake?


Code:
Inside web.config,
<add name="Connectstring" connectionString="Data
Source=DENSIA\SQLExpress;Initial Catalog=DbName;Integrated Security=True"
providerName="System.Data.SqlClient" />

inside Load event,

DAL.ConnectionString =
ConfigurationManager.ConnectionStrings["Connectstring"].ConnectionString;

private void DisplayLatestResources()
    {
        DAL.CreateCommand("sp_GetLatestFiveTrainingResources");
        DAL.ExecuteReader();
        SqlDataReader dr = DAL.DataReader;
      .....
    }



Try supplying with user id and password, same result...also try using
aspnet_regsql.exe, same result also...

Thanks in advanced.

den2005

Consider naming your objects without the system "sp_" prefix. Are you certain
that you're connecting to the same database both times?


ML

---
http://milambda.blogspot.com/

I forgot to mention the most important fact: reference your objects using the
schema.object syntax.

=>

Check the procedure's schema (and use it!).
Make sure the user you're using has sufficient (execute) permissions in that
schema.


ML

---
http://milambda.blogspot.com/

Thanks for the reply ML.

Not familiar about schema.object....need to read about this...can you be
more specific by providing me what exactly you meant? Thanks.

den2005


Show quoteHide quote

You could start here:
http://msdn2.microsoft.com/en-us/library/ms191465.aspx
http://msdn2.microsoft.com/en-us/library/ms190387.aspx

And of course:
http://msdn2.microsoft.com/en-us/library/ms187879.aspx


ML

---
http://milambda.blogspot.com/

Primary Key
Postcode problem
Query Problem
Mitery variable
Query working in EM and QA but not in Store proc
Implicit conversion from datetime to int not allowed
Triggers: using checksum()
Please help me with a SELECT
Security (How to protect SQL Server)
What is the search query for that?