Repository.ConnectToSQLRepository: Difference between revisions

Latest revision as of 16:18, 17 June 2016

Connects to a SQL Server repository. Returns a Boolean value; when true, indicates a successful connection to the repository.

.ConnectToSQLRepository(ServerName, DatabaseName, UseImpersonation, ImpersonateDomain, ImpersonateUsername, ImpersonatePassword)

ServerName

Required. String. The name of the SQL Server.

DatabaseName

Required. String. The name of the database.

UseImpersonation

Optional. Boolean. Indicates whether the database requires impersonation. Default value = False.

ImpersonateDomain

Optional. String. The domain for the impersonation.

ImpersonateUsername

Optional. String. The account username for the impersonation.

ImpersonatePassword

Optional. String. The account password for the impersonation.

VB|VB.NET

Dim MyRepository As New Repository
MyRepository.ConnectToSQLRepository("MyServer", "MyDatabase")

@@ Line 1: / Line 1: @@
-{{Template:API}}{{Template:APIBreadcrumb|9|.[[Repository Class|Repository]]}}
+{{Template:API}}{{Template:APIBreadcrumb|.[[Repository Class|Repository]]}}
@@ Line 9: / Line 9: @@
 ===Parameters===
 ''ServerName''
-:Required. String. The file path for the SQL Server.
+:Required. String. The name of the SQL Server.
 ''DatabaseName''
@@ Line 15: / Line 15: @@
 ''UseImpersonation''
-:Optional. Boolean. Indicates whether the database requires impersonation. Default value is false.
+:Optional. Boolean. Indicates whether the database requires impersonation. Default value = False.
 ''ImpersonateDomain''
@@ Line 28: / Line 28: @@
 ==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'''
   {{APIPrefix|Dim}} MyRepository {{APIPrefix|As New}} Repository
-  MyRepository.ConnectToSQLRepository({{APIString|"C:\Program Files\Microsoft SQL Server\"}}, {{APIString|"MyEnterprise"}})
+  MyRepository.ConnectToSQLRepository({{APIString|"MyServer"}}, {{APIString|"MyDatabase"}})