Connection Overview

A Connection represents the association of a single database in SQL Server to a project in Visual SourceSafe. It contains:

1. Connection name;
2. SourceSafe repository connection properties (Visual SourceSafe server configuration file location, source control project path, authorization data);
3. SQL Server database connection properties (SQL Server name, database name, authorization data).

SQLSourceSafe saves connection data in a connection file in XML format. The connection file is created after you create a connection from Connection Wizard. In multiple user environments where each user has different user name and password for SourceSafe and/or SQL Server, the connection settings will differ among users. The following is a typical project file content:

<?xml version="1.0" encoding="utf-8">

<APPConfig xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<strSqlServerDatabaseName>CommunityStarterKit</strSqlServerDatabaseName>

<strSqlServerName>(local)</strSqlServerName>

<strSqlServerPassword>password</strSqlServerPassword>

<strSqlServerUserID>sa</strSqlServerUserID>

<bUseWinAuthen>false</bUseWinAuthen>

<bCreateSQLDatabase>false</bCreateSQLDatabase>

<strVSSUserID>davidw</strVSSUserID>

<strVSSPassword>password</strVSSPassword>

<strVSSIni>C:\VSSDatabase\srcsafe.ini</strVSSIni>

<strVSSProj>$/CommunityStarterKit</strVSSProj>

<strProjectName>testProject</strProjectName>

<bCreateVSSDatabase>false</bCreateVSSDatabase>

</APPConfig>

---

SQLSourceSafe, 2003-2006 © Copyright, Best SoftTool, Incorporated