Microsoft KB Archive/317523

= PRB: &quot;Only One Database Connection at a Time Is Supported&quot; Error Message When You Merge Source Controlled Solution Files in Visual Studio .NET IDE =

Article ID: 317523

Article Last Modified on 2/23/2007

-

APPLIES TO

 Microsoft Visual SourceSafe 6.0C, when used with:  Microsoft Visual Studio .NET 2002 Professional Edition

 Microsoft Visual Studio .NET 2002 Enterprise Architect

 Microsoft Visual Studio .NET 2002 Enterprise Developer

 Microsoft Visual Studio .NET 2002 Academic Edition</li></ul> </li></ul>

-

<div class="notice_section">

This article was previously published under Q317523

<div class="symptoms_section">

SYMPTOMS
When you try to merge solution files that contain a project or projects that are under source code control, you may receive the following error message:

Only one database connection at a time is supported

<div class="cause_section">

CAUSE
This problem occurs because the projects in each solution are stored in different databases. Only one Visual SourceSafe database is supported in a solution. Even when you use the same database, this problem occurs if one database is identified with a Universal Naming Convention (UNC) path and the other database is identified with a regular file path.

<div class="resolution_section">

RESOLUTION
To work around this behavior, use one of the following methods.

Workaround 1
Leave the project files in separate solution files.

Workaround 2
Move one solution into the same database as the other database when you merge the solutions. To do this, follow these steps:
 * 1) Open the first solution in Visual Studio .NET.
 * 2) On the File menu, point to Source Control, and then click Change Source Control.
 * 3) In the Change Source Control dialog box, unbind the solution from its source control database.
 * 4) Open the second solution in Visual Studio .NET.
 * 5) On the File menu, point to Open, and then click Project.
 * 6) Click Add to Solution, and then open the first solution.
 * 7) Check in the project file that you just added. You are prompted to add this project to the same database as the solution that it is being added to.

<div class="status_section">

STATUS
This behavior is by design.

<div class="moreinformation_section">

Steps to Reproduce the Behavior

 * 1) Create a new project in Visual Studio .NET.
 * 2) On the File menu in the Visual Studio .NET IDE, point to Source Control, and then click Add Solution to Source Control.
 * 3) Close the solution.
 * 4) Create another new project in Visual Studio .NET.
 * 5) Add the second solution to source control, and use a different Visual SourceSafe database, or use the same database but specify a UNC path instead of the file path to the database.
 * 6) On the File menu in the Visual Studio .NET IDE, point to Open, and then click Project.
 * 7) In the Open Project dialog box, click Add to Solution, open the solution that you created in step 1, and then click Checkout.

<div class="references_section">