ASP.Net 2.0 & SQL Express: Cannot find stored procedure...

[den 2005]

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_GetAllArticl es", 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="Connectst ring" connectionStrin g="Data
Source=DENSIA\S QLExpress;Initi al Catalog=DbName; Integrated Security=True"
providerName="S ystem.Data.SqlC lient" />

inside Load event,

DAL.ConnectionS tring =
ConfigurationMa nager.Connectio nStrings["Connectstr ing"].ConnectionStri ng;

private void DisplayLatestRe sources()
{
DAL.CreateComma nd("sp_GetLates tFiveTrainingRe sources");
DAL.ExecuteRead er();
SqlDataReader dr = DAL.DataReader;
.....
}

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

Thanks in advanced.
den2005
--
MCP Year 2005, Philippines

[Cowboy \(Gregory A. Beamer\)]

Make sure the user (anon?) is not set with another default catalog other
than DbName.
Make sure the server is configured to accept TCP/IP connections

Since this is Express, your options are limited (no profiler, for example).
I am not sure how to easily query which DB you are in (someone else surely
knows), but I know you can run this command:

SELECT * FROM sys.database_fi les

If you find the files are not DBName and DBName_Log, you are in the wrong
database. You can also query the sprocs in this database and make sure you
stuck them there rather than some other database. Other than that, I am
stumped.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************** *************** *************** ****
Think outside of the box!
*************** *************** *************** ****
"den 2005" <de*****@discus sions.microsoft .comwrote in message
news:8B******** *************** ***********@mic rosoft.com...

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_GetAllArticl es", 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="Connectst ring" connectionStrin g="Data
Source=DENSIA\S QLExpress;Initi al Catalog=DbName; Integrated Security=True"
providerName="S ystem.Data.SqlC lient" />

inside Load event,

DAL.ConnectionS tring =
ConfigurationMa nager.Connectio nStrings["Connectstr ing"].ConnectionStri ng;

private void DisplayLatestRe sources()
{
DAL.CreateComma nd("sp_GetLates tFiveTrainingRe sources");
DAL.ExecuteRead er();
SqlDataReader dr = DAL.DataReader;
.....
}

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

Thanks in advanced.
den2005
--
MCP Year 2005, Philippines