BUG: Source Control Times Out When You Add Stored Procedures (234906)



The information in this article applies to:

  • Microsoft Visual InterDev 6.0
  • Microsoft Visual SourceSafe for Windows 6.0
  • Microsoft SQL Server 6.5 Service Pack 4 and later
  • Microsoft SQL Server 7.0

This article was previously published under Q234906

SYMPTOMS

When attempting to place a large number of stored procedures under source control the following error appears:
[Microsoft ODBC Driver] timeout expired.
NOTE: If you set a timeout value in the data tools option pages, the error will still appear.

CAUSE

This is a bug.

RESOLUTION

To workaround this bug complete the following steps:
  1. Add your Source Control database.
  2. Wait until the timeout error message appears.
  3. Save the project and reload.
  4. When the project reloads in Visual InterDev it will be attached to the Visual Source Safe Database. The stored procedures that were sucessfully placed under Source Control will marked as such.
  5. The remaining procedures can then be placed under Source Control by right-clicking on the individual procedures within Visual InterDev, and selecting "add to source control".
  6. Repeat steps 2-4 until all the stored procedures have been added sucessfully to Source Control.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

Modification Type:MajorLast Reviewed:5/12/2003
Keywords:kbBug kbpending KB234906