ASP.NET

To use Data acess application block with web application VS 2008

Please support our ASP.NET advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2008

Posts: 10

Reputation: skumar.snl is an unknown quantity at this point

Solved Threads: 0

skumar.snl skumar.snl is offline

Offline

Newbie Poster

To use Data acess application block with web application VS 2008

Dec 18th, 2008

At run time I am getting error requested database does not exist in configuration see at Line 19
string con = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cn"].ConnectionString;

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
Line 19:      Database db = DatabaseFactory.CreateDatabase(con);
Line 20: string sqlcmd = "select * from Movies where MovieID<500";
Line 21:  DbCommand dbcommand = db.GetSqlStringCommand(sqlcmd);
Line 19:      Database db = DatabaseFactory.CreateDatabase(con);
Line 20: string sqlcmd = "select * from Movies where MovieID<500";
Line 21:  DbCommand dbcommand = db.GetSqlStringCommand(sqlcmd);

In my webconfig i have given required Code in web config

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
<configSections><section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data"/></configSections>
 
<connectionStrings><add name="AdventureWorksDB" providerName="System.Data.SqlClient" connectionString="server=localhost;database=AdventureWorks;UID=user;PWD=word;"/><connectionStrings> 
<dataConfiguration defaultDatabase="AdventureWorksDB"/>
<configSections><section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data"/></configSections>

<connectionStrings><add name="AdventureWorksDB" providerName="System.Data.SqlClient" connectionString="server=localhost;database=AdventureWorks;UID=user;PWD=word;"/><connectionStrings> 
<dataConfiguration defaultDatabase="AdventureWorksDB"/>

i have even added required DLL....
i also configured the EnterPrise Library

i defined there required connection string

followed steps in given link http://www.datadirect.com/developer/...t-net-daab.pdf.

but of no result ..

can some one tell me

Last edited by peter_budo; Dec 18th, 2008 at 3:29 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Dec 2008

Posts: 8

Reputation: vasioky is an unknown quantity at this point

Solved Threads: 1

vasioky

Offline

Newbie Poster

Re: To use Data acess application block with web application VS 2008

Dec 18th, 2008

your problem is here :
string con = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cn"].ConnectionString;
you have no connection string with name "cn" your connection string is called AdventureWorksDB this mean you have to write :

System.Web.Configuration.WebConfigurationManager.ConnectionStrings["AdventureWorksDB "].ConnectionString;

•

Join Date: Dec 2008

Posts: 10

Reputation: skumar.snl is an unknown quantity at this point

Solved Threads: 0

skumar.snl skumar.snl is offline

Offline

Newbie Poster

Re: To use Data acess application block with web application VS 2008

Dec 18th, 2008

System.Web.Configuration.WebConfigurationManager.ConnectionStrings["AdventureWorksDB "].ConnectionString;

my connection string is same name as in webconfig file..
i checked still getting same error database in not defined in config
Is there any default setting for connection? other then webconfig

•

Join Date: Dec 2008

Posts: 8

Reputation: vasioky is an unknown quantity at this point

Solved Threads: 1

vasioky

Offline

Newbie Poster

Re: To use Data acess application block with web application VS 2008

Dec 18th, 2008

ok the second problem can be also in your web.config declaration. you have to different database but I'm not sure because I never used dataConfiguration tag. Hope this will solve your problem.

Help with Code Tags

(Toggle Plain Text)

<connectionStrings><add name="AdventureWorksDB" providerName="System.Data.SqlClient" connectionString="server=localhost;database=AdventureWorks;UID=user;PWD=word;"/><connectionStrings> 
<dataConfiguration defaultDatabase="AdventureWorksDB"/>

Last edited by peter_budo; Dec 18th, 2008 at 3:30 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.