VBA Connection to Server - Deprecated data source provider
Summary
VBA Connection to Server - Deprecated data source providerContent
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?
0