Why are remote data connections returned in Visual Studio?

Question

In Visual Studio 2008, I have database connections in the Server Explorer window that point to SQL Server databases installed locally on my PC.

When I delete one of the connections in go, but the next time I start Visual Studio, it returns again.

Does anyone know how to remove them correctly?

It doesn't matter, but it's a little annoying.

Thanks.

Answer 1

I found a solution to this problem, noting that the “remote” database connections were again displayed in Server Explorer when I opened the solution file (I previously had VS to open the last project at startup).

So, knowing that this should be something in the solution, I was looking for files, and I have a database project that contains build scripts, etc. In this project, there is a section "DBRefFolder" in the * .dbp file. The "excluded" database links were here, and when I deleted them, everything was fine.

It's a little annoying that VS is not deleting these entries properly, but at least I have a solution.

The following is an example from a * .dbp file:

Begin DataProject = "SQL Server Databases" ... ... ... ... Begin DBRefFolder = "Database References" Begin DBRefNode = "Name" ConnectStr = "Data Source=XXX;Initial Catalog=YYY;Integrated Security=True" Provider = "{91510608-8809-4020-8897-FBA057E22D54}" Colorizer = 6 End ... ... ... ... End End 

Answer 2

Just delete the web.config file or other configuration files, such as the app.config connection strings, that you no longer need. I’ve been testing it for about half a day, and removing unnecessary connection strings from the configuration file will help me not to load this connection string again in the visual studio 2012 server explorer. Good luck.

Answer 3

Delete them, close Visual Studio, clean up the temporary ASP.NET files, and start Visual Studio.

Answer 4

VisualStudio does not actually save changes to every small project or changes to space settings. I often find things like added or deleted projects, reverted to the way they were before if I turned off my machine before I could get out of VS first.

So, I highly recommend closing beautifully from VS after making any changes to the settings that you do not want to lose.

You think that the program created by Microsoft will not be the program that I use, which will not be able to correctly process the shutdown request and must first be closed manually, but nooooo ....

Answer 5

Steve, I've been dealing with this issue for a couple of days. Not only could I not delete the old connection, but I was also unable to add a new connection.

Here is what I found after searching high and low.

On Windows 7 and possibly Vista, try renaming or deleting this file "DefaultView.SEView" in this folder C: \ Users ... \ AppData \ Roaming \ Microsoft \ VisualStudio \ 9.0 \ ServerExplorer

Someone else said to delete the file from AppData \ Local, but it is not.

Answer 6

I used the notepad ++ Find in Files function to find the name of the data connection, I believe that you can search in the following folder:

C: \ Users \ YOURNAME \ Documents \ Visual Studio 2013 \

The following file has a data connection:

C: \ Users \ YOURNAME \ Documents \ Visual Studio 2013 \ WebSites \ WebSite1 \ Web.config

Remove the following statement that has a data connection:

<add name = "YOURCONNECTIONSTRINGNAME" connectionString = "server = ****; user id = ****; database = ****; ersistsecurityinfo = True; password = ****" providerName = "MySql.Data .MySqlClient "/">