Re: ASP.Net 2.0 & SQL Express: Cannot find stored procedure...
- From: "Cowboy \(Gregory A. Beamer\)" <NoSpamMgbworld@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 5 Sep 2006 08:42:47 -0500
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_files
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" <den2005@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8BE32F0F-06A3-4729-A1C3-020CFFA06947@xxxxxxxxxxxxxxxx
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
--
MCP Year 2005, Philippines
.
- Prev by Date: Re: Can someone tell if Sitemap always require a starting root?
- Next by Date: Button inside a custom control...
- Previous by thread: Required Permissions Cannot Be Aquired :-(
- Next by thread: Button inside a custom control...
- Index(es):
Relevant Pages
|
