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,

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_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <92FD52FD-700D-4667-ADC3-17ECFEF4DB65 (AT) microsoft (DOT) com>,
PeterH (AT) discussions (DOT) microsoft.com says...

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:

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

+-------------------+
Server


--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) 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 (AT) discussions (DOT) microsoft.com> wrote

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.

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:

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: