Repository.ConnectToSQLRepository

Method Syntax

ConnectToSQLRepository( ByVal ServerName As String, ByVal DatabaseName As String, Optional ByVal UseImpersonation As Boolean = False, Optional ByVal ImpersonateDomain As String = "", Optional ByVal ImpersonateUsername As String = "", Optional ByVal ImpersonatePassword As String = "") As Boolean
Connects to an MS SQL repository.

Parameters

ServerName The server file path for the SQL Repository.

DatabaseName The Database name of the Synthesis Repository to connect.

UseImpersonation 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 class.

       Private WithEvents MyRepository As New Repository

Connect to the Synthesis repository.

       Dim Success As Boolean = False
       Success = MyRepository.ConnectToSQLRepository("SQLServerPath", "SQLDatabaseName")