Solved

Unable to find connection 'dbname' for object 'Web.config'.

Posted on 2009-04-06
7
1,879 Views
Last Modified: 2012-05-06
Last night I went to bed and my project in Visual Studio 2005 worked just fine.  I start VS this morning and I get:

Unable to find connection 'dbConnectionString (Web.config)1' for object 'Web.config'. The connection string could not be found in application settings, or the data provider associated with the connection string could not be loaded.

What I don't understand is, this worked yesterday, and all day yesterday I didn't touch my web.config file.  Also, the database, which is an SQL Server is up, and I was able to access it using Enterprise Manager.

Any ideas what caused this?  I'm assuming I could create a new dataset and redo my tableadapters, but if this happend once, I'm sure it will happen again.

Any help would be appreciated! (let me know if i need to post additional info)
0
Comment
Question by:steverguy
  • 3
  • 3
7 Comments
 
LVL 4

Expert Comment

by:amazingwolf1
ID: 24076151
1. check you DO have the connection string on your config file in the correct place, even if you did not change it.

2. Did you try to restart your machine?

3. is your sql server on the same machine? Do you manage to open the management studio and run a query?

0
 
LVL 1

Author Comment

by:steverguy
ID: 24076306
The connection strings are located right below the <configSections> and right about the <system.web> section.  Does that seem correct?  I am new to ASP.NET and this was autogenerated.
</configSections>
  <connectionStrings>
    <add name="mydbConnectionString" connectionString="Data Source=myser.COM;Initial Catalog=mydb;Persist Security Info=True;User ID=username;Password=xxxxxx" providerName="System.Data.SqlClient" />
  </connectionStrings>
 <system.web>

The SQL Server is hosted remotley.  I am going to try restarting my computer to see if that works.

Thanks for your hquick response!
0
 
LVL 1

Author Comment

by:steverguy
ID: 24076380
Restarting the computer did not fix the problem.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 4

Expert Comment

by:amazingwolf1
ID: 24076423
is there any chance you have duplicate connection strings in your config file?
0
 
LVL 11

Accepted Solution

by:
anuragal earned 250 total points
ID: 24076444
This is a problem reported to MS and as far as i read on internet MS also acceptd it as bug in VS2005. Follow the below link..
http://social.msdn.microsoft.com/forums/en-US/winformsdatacontrols/thread/08a48cad-619d-4421-b584-f2b5550ba6c5/
In this link a long discussion is made and the users have posted some tricks to solve this problem.
May any trick work for you :-)
Anurag
0
 
LVL 4

Assisted Solution

by:amazingwolf1
amazingwolf1 earned 250 total points
ID: 24076464
Try to regenerate the connection string. Do you work with a dataset?
0
 
LVL 1

Author Comment

by:steverguy
ID: 24076523
I deleted the dataset and created a new one, which regenerated the connection string.  It is working now.  What an annoying bug!

Thanks for your help!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Sometimes in DotNetNuke module development you want to swap controls within the same module definition.  In doing this DNN (somewhat annoyingly) swaps the Skin and Container definitions to the default admin selections.  To get around this you need t…
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now