Repository.ConnectToSQLRepository

Connects to an MS SQL repository. Returns True if successful, otherwise returns False.

Syntax

• ConnectToSQLRepository( ServerName As String, DatabaseName As String, Optional UseImpersonation As Boolean = False , Optional ImpersonateDomain As String = "", Optional ImpersonateUsername As String = "" , Optional ImpersonatePassword As String = "") As Boolean

Parameters

ServerName: The server file path for the SQL repository.

DatabaseName: The database name of the repository.

UseImpersonation: Whether the database requires impersonation.

ImpersonateDomain: The domain for the impersonation.

ImpersonateUsername: The User Name for the impersonation.

ImpersonatePassword: The Password for the impersonation.

Usage Example

 'Declare a new repository connection object. 
 Dim MyRepository As New Repository
 
 'Connect to the Synthesis repository. 
 Dim Success As Boolean = False
 Success = MyRepository.ConnectToSQLRepository("SQLServerPath", "SQLDatabaseName")