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

[Matt MacDonald]

Hi All,

When using the dataset designer, at least once a week or so, I will try to
add a new query to a table adapter, or modify an existing one and get the
error "Unable to find connection 'dbname' 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." The
only way I have found to be able to correct the issue is to drag another
table onto the designer, which will generate a second connection string in
my web.config, as well as add an entry to my project settings. After doing
this, I then have to hit each adapter already on the designer and have it
use the connection string in the settings, rather than the one in the config
file. Is there a better way to get around this? Or better yet, is there a
way to stop it from happening in the first place?

Thanks,
Matt