could not execute a stored procedure(using DAAB) from a client(aspx page) to a wcf service
- by user1144695
i am trying to store data to sql database from a asp.net client website through a stored procedure(using DAAB) in a wcf service hosted in a asp.net empty website.When i try to store data to the DB i get the following error:
**
- The server was unable to process the request due to an internal
error. For more information about the error, either turn on
IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute
or from the <serviceDebug> configuration behavior) on the server in
order to send the exception information back to the client, or turn
on tracing as per the Microsoft .NET Framework SDK documentation and
inspect the server trace logs.
**
When i try to debug i get the following exception: Activation error occured while trying to get instance of type Database, key "" in the code--
Database db = EnterpriseLibraryContainer.Current.GetInstance<Database>("MyInstance");
where my app.config is
<?xml version="1.0"?>
<configuration>
<configSections>
<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=5.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="true"/>
</configSections>
<dataConfiguration defaultDatabase="MyInstance"/>
<connectionStrings>
<add name="MyInstance" connectionString="Data Source=BLRKDAS307581\KD;Integrated Security=True;User ID=SAPIENT\kdas3;Password=ilove0LINUX" providerName="System.Data.SqlClient" />
</connectionStrings>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
</startup>
</configuration>
Can anyone help me with it? Thanks in advance...