Repository.ConnectToSQLRepository: Difference between revisions
Jump to navigation
Jump to search
Chris Kahn (talk | contribs) (→Syntax) |
Chris Kahn (talk | contribs) |
||
| Line 20: | Line 20: | ||
== Usage Example == | == Usage Example == | ||
{{APIComment|'Declare a new repository connection | {{APIComment|'Declare a new repository connection object.}} | ||
Dim MyRepository As New Repository | Dim MyRepository As New Repository | ||
Revision as of 22:01, 27 May 2014
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")