Repository.ConnectToSQLRepository: Difference between revisions
John Leavitt (talk | contribs) No edit summary |
John Leavitt (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
{{Template:APIClass|Repository Class|Repository}} | {{Template:APIClass|Repository Class|Repository}} | ||
Connects to a SQL repository. | |||
== Method Syntax == | == Method Syntax == | ||
{{APIName|'''ConnectToSQLRepository'''(}} | {{APIName|'''ConnectToSQLRepository'''(}} | ||
Revision as of 22:48, 23 September 2013
Connects to a SQL repository.
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")