MFA Icon

MFA for Oracle Community

Starting September 2025, Oracle Community will require Multi-Factor Authentication (MFA) for all member logins. This simple extra step helps protect your account—and the community data—by adding an additional layer of security during sign-in.

Read more about MFA
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Essbase

    VBA Connection to Server - Deprecated data source provider

    edited Aug 2, 2018 2:36AM in Essbase 1 comment

    Summary

    VBA Connection to Server - Deprecated data source provider

    Content

    I've been attempting to automate our retrieval process through a VBA script, though have run into problems with the "HypCreateConnection" function. When manually connected to the server, it shows our provider as "Analytic Services Smart View Provider". This suggests we should use vtProvider "HYP_ANALYTICAL_SERVICES" in the HypCreateConnection function. HypCreateConnection returns an error value of "-15, Invalid Connection Parameter"

    The most current Developers Documentation says: "The global constant HYP_ANALYTIC_SERVICES = "Analytic Provider Services" is deprecated." What provider should we use instead? Is there an alternate method to connect to our server with?

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!