Repository.ConnectToSQLRepository - Revision history

Kate Racaza at 16:18, 17 June 2016

2016-06-17T16:18:49Z

← Older revision		Revision as of 16:18, 17 June 2016
Line 15:		Line 15:

	''UseImpersonation''		''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''		''ImpersonateDomain''

Kate Racaza at 21:53, 13 November 2015

2015-11-13T21:53:39Z

← Older revision		Revision as of 21:53, 13 November 2015
Line 1:		Line 1:
	{{Template:API}}{{Template:APIBreadcrumb\|9\|.[[Repository Class\|Repository]]}}		{{Template:API}}{{Template:APIBreadcrumb\|.[[Repository Class\|Repository]]}}

Kate Racaza at 23:37, 30 October 2015

2015-10-30T23:37:52Z

← Older revision		Revision as of 23:37, 30 October 2015
Line 9:		Line 9:
	===Parameters===		===Parameters===
	''ServerName''		''ServerName''
	:Required. String. The ~~file path for~~ the SQL Server.		:Required. String. The name of the SQL Server.

	''DatabaseName''		''DatabaseName''
Line 28:		Line 28:

	==Example==		==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'''		'''VB\|VB.NET'''

	{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository		{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository
	MyRepository.ConnectToSQLRepository({{APIString\|"~~C:\Program Files\Microsoft SQL Server\~~"}}, {{APIString\|"~~MyEnterprise~~"}})		MyRepository.ConnectToSQLRepository({{APIString\|"MyServer"}}, {{APIString\|"MyDatabase"}})

Kate Racaza at 15:31, 25 August 2015

2015-08-25T15:31:22Z

← Older revision		Revision as of 15:31, 25 August 2015
Line 2:		Line 2:


	<onlyinclude>Connects to a SQL Server repository ~~that you specify~~. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.</onlyinclude>		<onlyinclude>Connects to a SQL Server repository. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.</onlyinclude>

	== Syntax ==		== Syntax ==
Line 9:		Line 9:
	===Parameters===		===Parameters===
	''ServerName''		''ServerName''
	:String. The file path for the SQL Server.~~(Required)~~		:Required. String. The file path for the SQL Server.

	''DatabaseName''		''DatabaseName''
	:String. The name of the database. ~~(Required)~~		:Required. String. The name of the database.

	''UseImpersonation''		''UseImpersonation''
	:Boolean. ~~When true, indicates that~~ the database requires impersonation. Default value is false. ~~(Optional)~~		:Optional. Boolean. Indicates whether the database requires impersonation. Default value is false.

	''ImpersonateDomain''		''ImpersonateDomain''
	:String. The domain for the impersonation. ~~(Optional)~~		:Optional. String. The domain for the impersonation.

	''ImpersonateUsername''		''ImpersonateUsername''
	:String. The account username for the impersonation. ~~(Optional)~~		:Optional. String. The account username for the impersonation.

	''ImpersonatePassword''		''ImpersonatePassword''
	:String. The account password for the impersonation. ~~(Optional)~~		:Optional. String. The account password for the impersonation.

Kate Racaza at 16:34, 18 August 2015

2015-08-18T16:34:18Z

← Older revision		Revision as of 16:34, 18 August 2015
Line 2:		Line 2:


	<onlyinclude>Connects to a SQL ~~server~~ repository that you specify. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.</onlyinclude>		<onlyinclude>Connects to a SQL Server repository that you specify. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.</onlyinclude>

	== Syntax ==		== Syntax ==
Line 9:		Line 9:
	===Parameters===		===Parameters===
	''ServerName''		''ServerName''
	:String. The ~~server~~ file path for the SQL ~~database~~.(Required)		:String. The file path for the SQL Server.(Required)

	''DatabaseName''		''DatabaseName''
Line 15:		Line 15:

	''UseImpersonation''		''UseImpersonation''
	:Boolean. When true, indicates that the database requires ~~SQL~~ impersonation. Default value is false. (Optional)		:Boolean. When true, indicates that the database requires impersonation. Default value is false. (Optional)

	''ImpersonateDomain''		''ImpersonateDomain''
Line 28:		Line 28:

	==Example==		==Example==
	This example assumes that a SQL database named "MyEnterprise" exists in the C: drive. The code ignores the return value.		This example assumes that a SQL Server database named "MyEnterprise" exists in the C: drive. The code ignores the return value.
	'''VB\|VB.NET'''		'''VB\|VB.NET'''

	{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository		{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository
	MyRepository.ConnectToSQLRepository({{APIString\|"C:\Program Files\Microsoft SQL Server\"}}, {{APIString\|"MyEnterprise"}})		MyRepository.ConnectToSQLRepository({{APIString\|"C:\Program Files\Microsoft SQL Server\"}}, {{APIString\|"MyEnterprise"}})

Kate Racaza at 15:35, 23 July 2015

2015-07-23T15:35:30Z

← Older revision		Revision as of 15:35, 23 July 2015
Line 1:		Line 1:
	{{Template:API}}{{Template:APIBreadcrumb\|9~~, 10~~\|.[[Repository Class\|Repository]]}}		{{Template:API}}{{Template:APIBreadcrumb\|9\|.[[Repository Class\|Repository]]}}

Kate Racaza at 22:04, 20 July 2015

2015-07-20T22:04:32Z

← Older revision		Revision as of 22:04, 20 July 2015
Line 1:		Line 1:
	~~<noinclude>~~{{Template:API}}{{Template:APIBreadcrumb\|9, 10\|.[[Repository Class\|Repository]]}}~~</noinclude>~~		{{Template:API}}{{Template:APIBreadcrumb\|9, 10\|.[[Repository Class\|Repository]]}}


	Connects to a SQL server repository that you specify. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.		<onlyinclude>Connects to a SQL server repository that you specify. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.</onlyinclude>
	<~~noinclude~~>
	== Syntax ==		== Syntax ==
	'''.ConnectToSQLRepository'''(''ServerName'', ''DatabaseName'', ''UseImpersonation'', ''ImpersonateDomain'', ''ImpersonateUsername'', ''ImpersonatePassword'')		'''.ConnectToSQLRepository'''(''ServerName'', ''DatabaseName'', ''UseImpersonation'', ''ImpersonateDomain'', ''ImpersonateUsername'', ''ImpersonatePassword'')
Line 33:		Line 33:
	{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository		{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository
	MyRepository.ConnectToSQLRepository({{APIString\|"C:\Program Files\Microsoft SQL Server\"}}, {{APIString\|"MyEnterprise"}})		MyRepository.ConnectToSQLRepository({{APIString\|"C:\Program Files\Microsoft SQL Server\"}}, {{APIString\|"MyEnterprise"}})
	~~</noinclude>~~

Kate Racaza at 17:24, 20 July 2015

2015-07-20T17:24:31Z

← Older revision		Revision as of 17:24, 20 July 2015
Line 1:		Line 1:
	<noinclude>{{Template:API}}{{Template:APIBreadcrumb\|9\|[[Repository Class\|Repository]]}}</noinclude>		<noinclude>{{Template:API}}{{Template:APIBreadcrumb\|9, 10\|.[[Repository Class\|Repository]]}}</noinclude>


	Connects to a SQL server repository that you specify. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.		Connects to a SQL server repository that you specify. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.
	<noinclude>		<noinclude>
	== Syntax ==		== Syntax ==
	'~~'object~~''.'''~~ConnectToSQLRepository~~(''ServerName'', ''DatabaseName'', ''UseImpersonation'', ''ImpersonateDomain'', ''ImpersonateUsername'', ''ImpersonatePassword'')'''		'''.ConnectToSQLRepository'''(''ServerName'', ''DatabaseName'', ''UseImpersonation'', ''ImpersonateDomain'', ''ImpersonateUsername'', ''ImpersonatePassword'')

			===Parameters===
			''ServerName''
			:String. The server file path for the SQL database.(Required)

	~~where~~ ''~~object~~'' ~~is a variable that represents a Repository object~~.		''DatabaseName''
			:String. The name of the database. (Required)

	~~===Parameters===~~		''UseImpersonation''
	~~{\| {{APITable}}~~		:Boolean. When true, indicates that the database requires SQL impersonation. Default value is false. (Optional)
	\|-
	~~\|ServerName{{APIParam\|Required}}\|\|~~'''~~String~~'~~''. The server file path for the SQL database.~~		''ImpersonateDomain''
	\|-		:String. The domain for the impersonation. (Optional)
	~~\|DatabaseName{{APIParam\|Required}}\|\|'''String'''. The name of the database.~~
	\|-		''ImpersonateUsername''
	~~\|UseImpersonation{{APIParam\|Optional}}\|\|'''~~Boolean~~'''~~. When true, indicates that the database requires SQL impersonation. Default value is false.		:String. The account username for the impersonation. (Optional)
	\|-
	\|ImpersonateDomain~~{{APIParam\|Optional}}\|\|'~~''String~~'''~~. The domain for the impersonation.		''ImpersonatePassword''
	\|-		:String. The account password for the impersonation. (Optional)
	\|ImpersonateUsername~~{{APIParam\|Optional}}\|\|'~~''String~~'''~~. The account username for the impersonation.
	\|-
	\|ImpersonatePassword~~{{APIParam\|Optional}}\|\|'~~''String~~'''~~. The account password for the impersonation.
	\|}


	==Example==		==Example==
	This example assumes that a SQL database named "MyEnterprise" exists in the C: drive. ~~This~~ code ~~sample~~ ignores the return value.		This example assumes that a SQL database named "MyEnterprise" exists in the C: drive. The code ignores the return value.
	'''VB\|VB.NET'''~~<br>~~		'''VB\|VB.NET'''

	{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository		{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository
	MyRepository.ConnectToSQLRepository({{APIString\|"C:\Program Files\Microsoft SQL Server\"}}, {{APIString\|"MyEnterprise"}})		MyRepository.ConnectToSQLRepository({{APIString\|"C:\Program Files\Microsoft SQL Server\"}}, {{APIString\|"MyEnterprise"}})
	</noinclude>		</noinclude>

Kate Racaza at 17:26, 17 July 2015

2015-07-17T17:26:01Z

← Older revision		Revision as of 17:26, 17 July 2015
Line 1:		Line 1:
	<noinclude>{{Template:API}}{{Template:APIBreadcrumb\|9\|Repository}}</noinclude>		<noinclude>{{Template:API}}{{Template:APIBreadcrumb\|9\|[[Repository Class\|Repository]]}}</noinclude>

	Connects to a SQL server repository that you specify. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.		Connects to a SQL server repository that you specify. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.

Kate Racaza at 23:16, 16 July 2015

2015-07-16T23:16:13Z

← Older revision		Revision as of 23:16, 16 July 2015
Line 1:		Line 1:
	{{Template:~~APIBreadcrumb\|9\|Repository~~}}		<noinclude>{{Template:API}}{{Template:APIBreadcrumb\|9\|Repository}}</noinclude>
	{{Template:~~API~~}}

	Connects to a SQL server repository that you specify. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.		Connects to a SQL server repository that you specify. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.
			<noinclude>
	== Syntax ==		== Syntax ==
	''object''.'''ConnectToSQLRepository(''ServerName'', ''DatabaseName'', ''UseImpersonation'', ''ImpersonateDomain'', ''ImpersonateUsername'', ''ImpersonatePassword'')'''		''object''.'''ConnectToSQLRepository(''ServerName'', ''DatabaseName'', ''UseImpersonation'', ''ImpersonateDomain'', ''ImpersonateUsername'', ''ImpersonatePassword'')'''
Line 31:		Line 30:
	{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository		{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository
	MyRepository.ConnectToSQLRepository({{APIString\|"C:\Program Files\Microsoft SQL Server\"}}, {{APIString\|"MyEnterprise"}})		MyRepository.ConnectToSQLRepository({{APIString\|"C:\Program Files\Microsoft SQL Server\"}}, {{APIString\|"MyEnterprise"}})
			</noinclude>