Repository.ConnectToOracleRepository - Revision history

Kate Racaza at 21:54, 13 November 2015

2015-11-13T21:54:01Z

← Older revision		Revision as of 21:54, 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 15:33, 25 August 2015

2015-08-25T15:33:03Z

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


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

	== Syntax ==		== Syntax ==
Line 9:		Line 9:
	===Parameters===		===Parameters===
	''Port''		''Port''
	:Integer. The server port for the Oracle repository. ~~(Required)~~		:Required. Integer. The server port for the Oracle repository.

	''Service''		''Service''
	:String. The repository service identifier. ~~(Required)~~		:Required. String. The repository service identifier.

	''Host''		''Host''
	:String. The repository host identifier. ~~(Required)~~		:Required. String. The repository host identifier.

	''Schema''		''Schema''
	:String. The repository schema. ~~(Required)~~		:Required. String. The repository schema.

	''Password''		''Password''
	:String. The repository password or the Windows login password used for access to the database. ~~(Required)~~		:Required. String. The repository password or the Windows login password used for access to the database.

Kate Racaza at 15:35, 23 July 2015

2015-07-23T15:35:44Z

← 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:05, 20 July 2015

2015-07-20T22:05:04Z

← Older revision		Revision as of 22:05, 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 an Oracle repository that you specify. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.		<onlyinclude>Connects to an Oracle repository that you specify. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.</onlyinclude>
	<~~noinclude~~>
	== Syntax ==		== Syntax ==
	'''.ConnectToOracleRepository'''(''Port'', ''Service'', ''Host'', ''Schema'', ''Password'')		'''.ConnectToOracleRepository'''(''Port'', ''Service'', ''Host'', ''Schema'', ''Password'')
Line 30:		Line 30:
	{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository		{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository
	MyRepository.ConnectToOracleRepository({{APIString\|"OraclePort"}}, {{APIString\|"OracleService"}},{{APIString\|"OracleHost"}}, {{APIString\|"OracleSchema"}}, {{APIString\|"OraclePassword"}})		MyRepository.ConnectToOracleRepository({{APIString\|"OraclePort"}}, {{APIString\|"OracleService"}},{{APIString\|"OracleHost"}}, {{APIString\|"OracleSchema"}}, {{APIString\|"OraclePassword"}})
	~~</noinclude>~~

Kate Racaza at 17:29, 20 July 2015

2015-07-20T17:29:26Z

← Older revision		Revision as of 17:29, 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 an Oracle repository that you specify. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.		Connects to an Oracle repository that you specify. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.
	<noinclude>		<noinclude>
	== Syntax ==		== Syntax ==
	'~~'object~~''.'''~~ConnectToOracleRepository~~(''Port'', ''Service'', ''Host'', ''Schema'', ''Password'')'''		'''.ConnectToOracleRepository'''(''Port'', ''Service'', ''Host'', ''Schema'', ''Password'')

			===Parameters===
			''Port''
			:Integer. The server port for the Oracle repository. (Required)

			''Service''
			:String. The repository service identifier. (Required)

	~~where~~ ''~~object~~'' ~~is a variable that represents a Repository object~~.		''Host''
			:String. The repository host identifier. (Required)

	~~===Parameters===~~		''Schema''
	~~{\| {{APITable}}~~		:String. The repository schema. (Required)
	\|-
	~~\|Port{{APIParam\|Required}}\|\|~~'''~~Integer~~'~~''. The server port for the Oracle repository.~~		''Password''
	\|-		:String. The repository password or the Windows login password used for access to the database. (Required)
	~~\|Service{{APIParam\|Required}}\|\|'''~~String~~'''~~. The repository ~~service identifier~~.
	\|-
	~~\|Host{{APIParam\|~~Required~~}}\|\|'''String'''. The repository host identifier.~~
	\|-
	~~\|Schema{{APIParam\|Required}}\|\|~~''~~'String~~''~~'. The repository schema.~~
	\|-
	~~\|Password{{APIParam\|Required}}\|\|'''~~String~~'''~~. The repository password~~. (Your~~ Windows login ~~credentials are~~ used for access to the database~~; use your Windows password~~.)
	\|}


	==Example==		==Example==

	'''VBA\|VB.NET'''~~<br>~~		'''VBA\|VB.NET'''

	{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository		{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository
	MyRepository.ConnectToOracleRepository({{APIString\|"OraclePort"}}, {{APIString\|"OracleService"}},{{APIString\|"OracleHost"}}, {{APIString\|"OracleSchema"}}, {{APIString\|"OraclePassword"}})		MyRepository.ConnectToOracleRepository({{APIString\|"OraclePort"}}, {{APIString\|"OracleService"}},{{APIString\|"OracleHost"}}, {{APIString\|"OracleSchema"}}, {{APIString\|"OraclePassword"}})
	</noinclude>		</noinclude>

Kate Racaza at 17:26, 17 July 2015

2015-07-17T17:26:11Z

← 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 an Oracle repository that you specify. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.		Connects to an Oracle 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:53Z

← 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 an Oracle repository that you specify. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.		Connects to an Oracle repository that you specify. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.
			<noinclude>
	== Syntax ==		== Syntax ==
	''object''.'''ConnectToOracleRepository(''Port'', ''Service'', ''Host'', ''Schema'', ''Password'')'''		''object''.'''ConnectToOracleRepository(''Port'', ''Service'', ''Host'', ''Schema'', ''Password'')'''
Line 28:		Line 28:
	{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository		{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository
	MyRepository.ConnectToOracleRepository({{APIString\|"OraclePort"}}, {{APIString\|"OracleService"}},{{APIString\|"OracleHost"}}, {{APIString\|"OracleSchema"}}, {{APIString\|"OraclePassword"}})		MyRepository.ConnectToOracleRepository({{APIString\|"OraclePort"}}, {{APIString\|"OracleService"}},{{APIString\|"OracleHost"}}, {{APIString\|"OracleSchema"}}, {{APIString\|"OraclePassword"}})
			</noinclude>

Kate Racaza at 16:52, 13 July 2015

2015-07-13T16:52:40Z

← Older revision		Revision as of 16:52, 13 July 2015
Line 1:		Line 1:
	{{Template:~~APIClass~~\|~~Repository Class~~\|Repository}}		{{Template:APIBreadcrumb\|9\|Repository}}
	{{Template:~~Repository~~.~~ConnectToOracleRepository~~.~~Cmt}}~~		{{Template:API}}
			Connects to an Oracle repository that you specify. Returns a '''Boolean''' value; when true, indicates a successful connection to the repository.

	== Syntax ==		== Syntax ==
	*ConnectToOracleRepository(~~{{APIPrefix\|ByVal}}~~ Port ~~{{APIPrefix\|As Integer}}~~, ~~{{APIPrefix\|ByVal}}~~ Service ~~{{APIPrefix\|As String}}~~, ~~{{APIPrefix\|ByVal}}~~ Host ~~{{APIPrefix\|As String}}~~, ~~{{APIPrefix\|ByVal}}~~ Schema ~~{{APIPrefix\|As String}}~~, ~~{{APIPrefix\|ByVal}}~~ Password ~~{{APIPrefix\|As String}}~~)~~{{APIPrefix\|As Boolean}}~~		''object''.'''ConnectToOracleRepository(''Port'', ''Service'', ''Host'', ''Schema'', ''Password'')'''

	~~Parameters~~		where ''object'' is a variable that represents a Repository object.
	:''~~Port~~''~~: The server port for the Oracle repository~~.

	:''Service'': The repository service identifier.		===Parameters===
			{\| {{APITable}}
			\|-
			\|Port{{APIParam\|Required}}\|\|'''Integer'''. The server port for the Oracle repository.
			\|-
			\|Service{{APIParam\|Required}}\|\|'''String'''. The repository service identifier.
			\|-
			\|Host{{APIParam\|Required}}\|\|'''String'''. The repository host identifier.
			\|-
			\|Schema{{APIParam\|Required}}\|\|'''String'''. The repository schema.
			\|-
			\|Password{{APIParam\|Required}}\|\|'''String'''. The repository password. (Your Windows login credentials are used for access to the database; use your Windows password.)
			\|}

	~~:''Host'': The repository host identifier.~~

	~~:''Schema'': The repository schema.~~		==Example==

	:''~~Password~~''~~: The repository password. (Your Windows login credentials are used for access to the database; use your Windows password.)~~		'''VBA\|VB.NET'''<br>
			{{APIPrefix\|Dim}} MyRepository {{APIPrefix\|As New}} Repository
	~~{{Template:BooleanReturn.Cmt}}~~		MyRepository.ConnectToOracleRepository({{APIString\|"OraclePort"}}, {{APIString\|"OracleService"}},{{APIString\|"OracleHost"}}, {{APIString\|"OracleSchema"}}, {{APIString\|"OraclePassword"}})

	~~== Usage Example ==~~

	{{~~APIComment~~\|~~'Declare a new repository connection object.~~}}
	~~Dim~~ MyRepository ~~As New Repository~~

	{{~~APIComment~~\|~~'Connect to the Synthesis repository.~~}}
	~~Dim Success As Boolean~~
	~~Success =~~ MyRepository.ConnectToOracleRepository("OraclePort", "OracleService",
	"OracleHost", "OracleSchema", "OraclePassword")

Alex Ulanov at 17:25, 20 May 2015

2015-05-20T17:25:24Z

← Older revision		Revision as of 17:25, 20 May 2015
Line 1:		Line 1:
	{{Template:APIClass\|Repository Class\|Repository}}		{{Template:APIClass\|Repository Class\|Repository}}
	{{Template:Repository.ConnectToOracleRepository~~.Cmt}} {{Template:BooleanReturn~~.Cmt}}		{{Template:Repository.ConnectToOracleRepository.Cmt}}

	== Syntax ==		== Syntax ==
	*ConnectToOracleRepository( Port {{APIPrefix\|As Integer}}, Service {{APIPrefix\|As String}}, Host {{APIPrefix\|As String}}, Schema {{APIPrefix\|As String}}, Password {{APIPrefix\|As String}}){{APIPrefix\|As Boolean}}		*ConnectToOracleRepository({{APIPrefix\|ByVal}} Port {{APIPrefix\|As Integer}}, {{APIPrefix\|ByVal}} Service {{APIPrefix\|As String}}, {{APIPrefix\|ByVal}} Host {{APIPrefix\|As String}}, {{APIPrefix\|ByVal}} Schema {{APIPrefix\|As String}}, {{APIPrefix\|ByVal}} Password {{APIPrefix\|As String}}){{APIPrefix\|As Boolean}}

	Parameters		Parameters
Line 15:		Line 15:

	:''Password'': The repository password. (Your Windows login credentials are used for access to the database; use your Windows password.)		:''Password'': The repository password. (Your Windows login credentials are used for access to the database; use your Windows password.)

			{{Template:BooleanReturn.Cmt}}

	== Usage Example ==		== Usage Example ==
Line 22:		Line 24:

	{{APIComment\|'Connect to the Synthesis repository.}}		{{APIComment\|'Connect to the Synthesis repository.}}
	Dim Success As Boolean ~~= False~~		Dim Success As Boolean
	Success = MyRepository.ConnectToOracleRepository("OraclePort", "OracleService",		Success = MyRepository.ConnectToOracleRepository("OraclePort", "OracleService",
	"OracleHost", "OracleSchema", "OraclePassword")		"OracleHost", "OracleSchema", "OraclePassword")

Chris Kahn: /* Usage Example */

2014-05-27T22:00:19Z

Usage Example

← Older revision		Revision as of 22:00, 27 May 2014
Line 18:		Line 18:
	== Usage Example ==		== Usage Example ==

	{{APIComment\|'Declare a new repository connection ~~class~~.}}		{{APIComment\|'Declare a new repository connection object.}}
	Dim MyRepository As New Repository		Dim MyRepository As New Repository