MS SQL Server OLAP - using VB6 to connect to Analysis Services 2005

Author

using VB6 to connect to Analysis Services 2005

Peter H

2005-09-26, 11:23 am

I have considerable VB6 code that connects to Analysis Services 2000 using
both DSO and ADOMD 2.8. I am desperate to upgrade to SQL server and AS 2005
as soon as possible. However, my VB6 code is refusing to connect to Analysis
Services 2005 (the latest pre-release). Some questions:
1.) how do I connect to Analysis Services 2005 with VB6?
2.) Will VB6 be able to utilize mdac 9?

thank you in advance,

Darren Gosbell

2005-09-26, 8:24 pm

There have been other posts around this issue. You need to install the
version of PTS that matches AS 2005. If you do a search in
groups.google.com I am sure you would be able to find the details.

VB6 should work find, I think all COM interfaces have been maintained as
this is how Excel talks to AS and it works with 2005.

--
Regards
Darren Gosbell [MCSD]
< dgosbell_at_yahoo_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <92FD52FD-700D-4667-ADC3- 17ECFEF4DB65@microso
ft.com>,
PeterH@discussions.microsoft.com says...
> I have considerable VB6 code that connects to Analysis Services 2000 using
> both DSO and ADOMD 2.8. I am desperate to upgrade to SQL server and AS 2005
> as soon as possible. However, my VB6 code is refusing to connect to Analysis
> Services 2005 (the latest pre-release). Some questions:
> 1.) how do I connect to Analysis Services 2005 with VB6?
> 2.) Will VB6 be able to utilize mdac 9?
>
> thank you in advance,
>
>

Peter H

2005-09-27, 7:24 am

hmm. My understanding of AS2005 is that there is no more pivot table
services. The functionality has been moved to the server. Instead, mdac9
supposedly has a lightweight wrapper for ado and adomd that mimics PTS.

BTW: I am able to connect and use data via:
1.) excel pivot table
2.) sql server mgt studio 2005

"Darren Gosbell" wrote:

> There have been other posts around this issue. You need to install the
> version of PTS that matches AS 2005. If you do a search in
> groups.google.com I am sure you would be able to find the details.
>
> VB6 should work find, I think all COM interfaces have been maintained as
> this is how Excel talks to AS and it works with 2005.
>
>
> --
> Regards
> Darren Gosbell [MCSD]
> < dgosbell_at_yahoo_do
t_com>
> Blog: http://www.geekswithblogs.net/darrengosbell
>
> In article <92FD52FD-700D-4667-ADC3- 17ECFEF4DB65@microso
ft.com>,
> PeterH@discussions.microsoft.com says...
>

Dave Wickert [MSFT]

2005-09-27, 8:24 pm

Yes, and No. PTS' official name is the OLEDB Provider for OLAP. PTS8 (aka
the msolap.2 provider) was a thick client which used lots of resources, had
a client-side cache, etc -- it only works against SQL2K.

The new PTS9 (aka the msolap.3 provider) is needed to speak to SQL2K5. It is
a thin layer upon XMLA and all query processing happens on the server.

ADOMD talks to either of them the same once you say if you want msolap.2 or
..3

+-------------------+
| Your application |
+-------------------+
| ADOMD |
+-------------------+
| PTS8 or PTS9 |
+-------------------+
|
+------------------------------------------------ Analsyis
Server

--
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Peter H" <PeterH@discussions.microsoft.com> wrote in message
news:E20D27F3-17F3-4366-99BF- 8A26D4E123BB@microso
ft.com...[color=darkred]
> hmm. My understanding of AS2005 is that there is no more pivot table
> services. The functionality has been moved to the server. Instead, mdac9
> supposedly has a lightweight wrapper for ado and adomd that mimics PTS.
>
> BTW: I am able to connect and use data via:
> 1.) excel pivot table
> 2.) sql server mgt studio 2005
>
>
>
> "Darren Gosbell" wrote:
>

Peter

2005-09-27, 8:24 pm

I have an application for which AS2005 with a pivot table front-end
would be IDEAL, except that my dimension hierarchies are many-to-many
(ie a Products dimension may include "Phones" with children "Landline
phones" and "Mobile phones", but "Mobile phones" may also be a child of
"Mobile devices". I was told that AS2005 can support such many-to-many
hierarchies, but I haven't been able to figure out how. Can you
provide any leads or explanations? Thanks.

Peter H

2005-09-28, 8:24 pm

Dave:
thank you for your comments.
With that, I have been able to connect using adomd. but when i am trying to
attach to a database: oConnection.DefaultDatabase = DatabaseName
I get the error:
Either the user, HAIINT.COM\PHeld, does not have access to the
KA_DLR_C94__koni database, or the database does not exist.
I am able to manage that database in AS 2005 mgmt studio, and can browse its
data via an excel pivot table. So, i am now confused with the "access" error.
thanks,
Peter.

"Dave Wickert [MSFT]" wrote:

> Yes, and No. PTS' official name is the OLEDB Provider for OLAP. PTS8 (aka
> the msolap.2 provider) was a thick client which used lots of resources, had
> a client-side cache, etc -- it only works against SQL2K.
>
> The new PTS9 (aka the msolap.3 provider) is needed to speak to SQL2K5. It is
> a thin layer upon XMLA and all query processing happens on the server.
>
> ADOMD talks to either of them the same once you say if you want msolap.2 or
> ..3
>
> +-------------------+
> | Your application |
> +-------------------+
> | ADOMD |
> +-------------------+
> | PTS8 or PTS9 |
> +-------------------+
> |
> +------------------------------------------------ Analsyis
> Server
>
>
> --
> Dave Wickert [MSFT]
> dwickert@online.microsoft.com
> Program Manager
> BI Systems Team
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> "Peter H" <PeterH@discussions.microsoft.com> wrote in message
> news:E20D27F3-17F3-4366-99BF- 8A26D4E123BB@microso
ft.com...
>
>
>

Peter H

2005-09-28, 8:24 pm

Dave:
I also figured out some of the issue regarding connection via DSO with VB6.
i did the following and now can connect to a cube via DSO:
1.) right click on instance of AS 2005 in mgmt studio and choose
properties
2.) check on the advanced (bottom left)
3.) scroll to DSO settings
4.) specify the 3rd and 4th settings – connection strings
5.) restart the instance

However...
once connected, i am getting the error:
invalid object name 'olapobjects'

Any clues?
thanks,
Peter.

"Dave Wickert [MSFT]" wrote:

> Yes, and No. PTS' official name is the OLEDB Provider for OLAP. PTS8 (aka
> the msolap.2 provider) was a thick client which used lots of resources, had
> a client-side cache, etc -- it only works against SQL2K.
>
> The new PTS9 (aka the msolap.3 provider) is needed to speak to SQL2K5. It is
> a thin layer upon XMLA and all query processing happens on the server.
>
> ADOMD talks to either of them the same once you say if you want msolap.2 or
> ..3
>
> +-------------------+
> | Your application |
> +-------------------+
> | ADOMD |
> +-------------------+
> | PTS8 or PTS9 |
> +-------------------+
> |
> +------------------------------------------------ Analsyis
> Server
>
>
> --
> Dave Wickert [MSFT]
> dwickert@online.microsoft.com
> Program Manager
> BI Systems Team
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> "Peter H" <PeterH@discussions.microsoft.com> wrote in message
> news:E20D27F3-17F3-4366-99BF- 8A26D4E123BB@microso
ft.com...
>
>
>

Sponsored Links