asked on

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

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)

amazingwolf1

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?

steverguy

ASKER

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!

steverguy

ASKER

Restarting the computer did not fix the problem.

amazingwolf1

is there any chance you have duplicate connection strings in your config file?

ASKER CERTIFIED SOLUTION