Refreshing SQL 2000 connection in Visual Studio 2005

I have set up an SQL server database as a data source using the Data Source Configuration Wizard, but when I make changes to the source it does not show in my VB project even after refreshing.

Closing and reopening the project makes no difference either.

The only solution I can find is to create a new connection.

[333 byte] By [DanielCoetzee] at [2007-12-26]
# 1
What kind of changes are you making at the source that you expect to show up in VB?
DMan1 at 2007-9-4 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 2
Modifications to the actual SQL Database table layout, adding tables, etc.
DanielCoetzee at 2007-9-4 > top of Msdn Tech,Visual Basic,Visual Basic General...