HypSetSharedConnectionsURL
Describes the Oracle Smart View for Office VBA function, HypSetSharedConnectionsURL.
Data provider types: Oracle Essbase, Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting
Description
HypSetSharedConnectionsURL() sets the Shared Connections URL in the config file and Options dialog box.
Syntax
HypSetSharedConnectionsURL (vtSharedConnURL)
ByVal vtSharedConnURL As Variant
Parameters
vtSharedConnURL: the new Shared Connections URL to be set.
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Public Declare Function HypSetSharedConnectionsURL Lib "HsAddin" (ByVal vtSharedConnURL As Variant) As Long
Sub Example_HypSetSharedConnectionsURL()
Dim lRet As Long
lRet = HypSetSharedConnectionsURL("http://<server>:19000/workspace/SmartViewProviders")
End Sub