Problems with DataSets in DataSources window when renaming the source database

[Magnus]

I have a set of typed datasets that are tied to a database on a mssql2005
server. They are naturally displayed and available in the DataSources
window. Now I want to rename the database, but when I do that and
reconfigure any of the datasets with the Wizard, all the datatables I have
previously selected are marked as unavailable (with a red x next to it), and
displays all database objects in the renamed database as "new" and
unchecked.

How can I rename the database and keep the current set of typed datasets?

=- magnus -=

 

[Magnus]

I have a set of typed datasets that are tied to a database on a mssql2005
server. They are naturally displayed and available in the DataSources
window. Now I want to rename the database, but when I do that and
reconfigure any of the datasets with the Wizard, all the datatables I have

When I rename the database I obviously also change the database name in the
connection string in the settings file.

I have also done some more testing and it seems like the DataSources window
handle this inconsistently, or I am doing something wrong. Because even
though two different datasets use the same datasource, on one of them the
wizard reports it cannot connect to the database and the database name
displayed in the error message is the old name even though I have changed
the connection string. The other one manages to connect to the datasource
but has the problem as described in my previous post. Everything is back to
normal if I rename the database and connection string back to it's original
name. Albeit the change is not noticed instantly, it seems to take some
amount of time (minutes) before the datasources wizard is aware of the
change somehow.

- Magnus