Re: [ELMAH] Sql Server 2008 Express issue: Could not find stored procedure 'ELMAH_GetErrorsXml'.

[Atif Aziz]

Have you used Management Studio Express to try and verify if the table and stored procedures are indeed defined in the aspnetdb.mdf your attaching to in the connection string?

On Wed, Jul 8, 2009 at 2:55 AM, faux.dev <faux...@gmail.com> wrote:

Hiya,

I'm trying to use ELMAH with SQL Server 2008 Express, but run into an
error when trying to view the elmah.axd page. The error is:
"Sql Server 2008 Express issue: Could not find stored procedure
'ELMAH_GetErrorsXml'."

My setup:  Visual Studio 2008, ASP.NET 3.5, SQL Server 2008 Express

I have a database 'aspnetdb.mdf' that gets generated by ASP.NET when
using its default membership and roles providers. I ran the
SQLServer.sql script to generate the ELMAH_Error table and its
accompanying stored procedures. In web.config, I'm telling Elmah to
use the same connection string that works fine for my
AspNetSqlMembershipProvider entry.

The connection string:

<add name="LocalSqlServer" connectionString="data source=.
\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|
aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" /
>

My Elmah errorLog entry:

<errorLog type="Elmah.SqlErrorLog, Elmah"
connectionStringName="LocalSqlServer" />


Any thought as to why Sql Server 2008 Express can't find the stored
procedure?
Thanks for your time,
-fauxdev

[faux.dev]

Hi Atif,

Just discovered this was a case of user (me) error. My apologies!
I had two different databases named 'aspnetdb.mdf' attached, but ran
the SqlServer.sql file on the wrong one.

thank you,
-mf

On Jul 9, 10:28 am, Atif Aziz <aziza...@gmail.com> wrote:
> Have you used Management Studio Express to try and verify if the table and
> stored procedures are indeed defined in the aspnetdb.mdf your attaching to
> in the connection string?
>

[faux.dev]

FYI i'm going to remove this group post after a couple of days, no
need to clutter up the folder with trivial user errors. ; )