ELMAH and SQL Server 2008 R2?

Question

I try to run ELMAH with my ASP.NET MVC 2 project but have some problem to get it to work with my SQL Server 2008 R2 database.

This is what I have done.

• Run the dbscript in my database, accidentally I ran it twice but it seems to not matter in this case.

• Add the following section to my web.config (under configSection):

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

• This is how my Entity Framework connection string looks like :

  <add name="MyEntities" 
       connectionString="metadata=res://*/Models.Model.MyEntities.csdl|res://*/Models.Model.MyEntities.ssdl|res://*/Models.Model.MyEntities.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=000.000.000.000;Initial Catalog=MyDatabase;Persist Security Info=True;User ID=[username];Password=[password];MultipleActiveResultSets=True&quot;" 
       providerName="System.Data.EntityClient" />
  

When visiting the admin/elmah/ page I get the following exception :

Keyword not supported: 'metadata'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Keyword not supported: 'metadata'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ArgumentException: Keyword not supported: 'metadata'.]
System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) +5110868
System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) +98
System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +64
System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) +24
System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) +150
System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) +59

What am I doing wrong?

Answer 1

Entity framework connection string is different from sqlclient connection string and they are not compatible. You have to use sqlclient connection string to work with elmah. Look at this site for valid connection strings: http://connectionstrings.com/sql-server-2008