Repository.ConnectToSQLRepository: Difference between revisions
Jump to navigation
Jump to search
John Leavitt (talk | contribs) m (Protected "Repository.ConnectToSQLRepository" ([edit=sysop] (indefinite) [move=sysop] (indefinite)) [cascading]) |
Chris Kahn (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
{{Template:APIClass|Repository Class|Repository}} | {{Template:APIClass|Repository Class|Repository}} | ||
{{Template:Repository.ConnectToSQLRepository.Cmt}} | |||
{{ | |||
== | == Syntax == | ||
*ConnectToSQLRepository( ServerName {{APIPrefix|As String}}, DatabaseName {{APIPrefix|As String}}, {{APIPrefix|Optional}} UseImpersonation {{APIPrefix|As Boolean}} = False , {{APIPrefix|Optional}} ImpersonateDomain {{APIPrefix|As String}} = "", {{APIPrefix|Optional}} ImpersonateUsername {{APIPrefix|As String}} = "" , {{APIPrefix|Optional}} ImpersonatePassword {{APIPrefix|As String}} = "") {{APIPrefix|As Boolean}} | |||
'' | Parameters | ||
The | :''ServerName'': The server file path for the SQL Repository. | ||
''' | :''DatabaseName'': The Database name of the Synthesis Repository to connect. | ||
The | |||
''' | :''UseImpersonation'': The database requires impersonation. | ||
The | |||
''' | :''ImpersonateDomain'': The domain for the impersonation. | ||
The | |||
'''ImpersonatePassword'' | :''ImpersonateUsername'': The User Name for the impersonation. | ||
The Password for the impersonation. | |||
:''ImpersonatePassword'': The Password for the impersonation. | |||
== Usage Example == | == Usage Example == | ||
Revision as of 17:06, 27 February 2014
Connects to an MS SQL repository.
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 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")