?
Solved

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

Posted on 2009-04-06
7
Medium Priority
?
2,183 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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:
Anurag Agarwal earned 1000 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 1000 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In .NET 2.0, Microsoft introduced the Web Site.  This was the default way to create a web Project in Visual Studio 2005.  In Visual Studio 2008, the Web Application has been restored as the default web Project in Visual Studio/.NET 3.x The Web Si…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses
Course of the Month16 days, 23 hours left to enroll

862 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