Repository.ConnectToSQLRepository
Jump to navigation
Jump to search
Member of: SynthesisAPI9.Repository
Connects to a SQL Server repository that you specify. Returns a Boolean value; when true, indicates a successful connection to the repository.
Syntax
.ConnectToSQLRepository(ServerName, DatabaseName, UseImpersonation, ImpersonateDomain, ImpersonateUsername, ImpersonatePassword)
Parameters
ServerName
- String. The file path for the SQL Server.(Required)
DatabaseName
- String. The name of the database. (Required)
UseImpersonation
- Boolean. When true, indicates that the database requires impersonation. Default value is false. (Optional)
ImpersonateDomain
- String. The domain for the impersonation. (Optional)
ImpersonateUsername
- String. The account username for the impersonation. (Optional)
ImpersonatePassword
- String. The account password for the impersonation. (Optional)
Example
This example assumes that a SQL Server database named "MyEnterprise" exists in the C: drive. The code ignores the return value.
VB|VB.NET Dim MyRepository As New Repository MyRepository.ConnectToSQLRepository("C:\Program Files\Microsoft SQL Server\", "MyEnterprise")