Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

DSO Application with Analysis Services 2005

  
   Database Forums (Home) -> OLAP RSS
Next:  CONTAINSTABLE - weird results - using "and n..  
Author Message
Gary Wise

External


Since: Aug 05, 2005
Posts: 3



(Msg. 1) Posted: Wed Aug 10, 2005 8:57 am
Post subject: DSO Application with Analysis Services 2005
Archived from groups: microsoft>public>sqlserver>olap (more info?)
I have an application that uses DSO to define and populate cubes which works
on the AS2000 platform. I am trying to evaluate how easily this can be
ported to SQL 2005 platform.

I have installed SQL 2005 on a server and running a test app to connect
using DSO I get "The connection string to the repository needs to be
specified in the 9.0 server properties (see <DSO>...<\DSO section in
msmdsrv.ini file from Analysis Service 9.0)". I've found the file but I do
not know what to enter here. Can somebody assist?

Secondly, I would like to set up a client-server environment to test the
application in a more realistic configuration but I cannot figure out how to
set up the Analysis Services client-side components. The SQL Server 2005 CTP
setup does not seem to offer the this option. Any help here would be greatly
appreciated.

Many thanks,
Gary

 >> Stay informed about: DSO Application with Analysis Services 2005 
Back to top
Login to vote
Peter H

External


Since: Sep 26, 2005
Posts: 2



(Msg. 2) Posted: Tue Sep 27, 2005 1:03 pm
Post subject: RE: DSO Application with Analysis Services 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Gary:
Have you been able to solve this issue?
I believe that I have the same problem.
thanks,
Peter.

"Gary Wise" wrote:

> I have an application that uses DSO to define and populate cubes which works
> on the AS2000 platform. I am trying to evaluate how easily this can be
> ported to SQL 2005 platform.
>
> I have installed SQL 2005 on a server and running a test app to connect
> using DSO I get "The connection string to the repository needs to be
> specified in the 9.0 server properties (see <DSO>...<\DSO section in
> msmdsrv.ini file from Analysis Service 9.0)". I've found the file but I do
> not know what to enter here. Can somebody assist?
>
> Secondly, I would like to set up a client-server environment to test the
> application in a more realistic configuration but I cannot figure out how to
> set up the Analysis Services client-side components. The SQL Server 2005 CTP
> setup does not seem to offer the this option. Any help here would be greatly
> appreciated.
>
> Many thanks,
> Gary

 >> Stay informed about: DSO Application with Analysis Services 2005 
Back to top
Login to vote
Malbeth

External


Since: Oct 07, 2005
Posts: 1



(Msg. 3) Posted: Fri Oct 07, 2005 2:17 am
Post subject: RE: DSO Application with Analysis Services 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Peter,
What I have found is that by running the SQL Server 2005 Management
programme and connecting to an instance of Analysis Services you can look at
its Properties, which are read from msmdsrv.ini, and it allows you to specify
connection details of a database to use as the DSO repository. You will then
be able to connect using DSO.

However, so far I have only been able to do this by running the application
on the server machine itself. I haven't been able to find a client install
that will put DSO on a client machine. I haven't yet had a look at the
September CTP. If you find such a thing I would be grateful if you could
pass it on.

HTH,
Gary

"Peter H" wrote:

> Gary:
> Have you been able to solve this issue?
> I believe that I have the same problem.
> thanks,
> Peter.
>
> "Gary Wise" wrote:
>
> > I have an application that uses DSO to define and populate cubes which works
> > on the AS2000 platform. I am trying to evaluate how easily this can be
> > ported to SQL 2005 platform.
> >
> > I have installed SQL 2005 on a server and running a test app to connect
> > using DSO I get "The connection string to the repository needs to be
> > specified in the 9.0 server properties (see <DSO>...<\DSO section in
> > msmdsrv.ini file from Analysis Service 9.0)". I've found the file but I do
> > not know what to enter here. Can somebody assist?
> >
> > Secondly, I would like to set up a client-server environment to test the
> > application in a more realistic configuration but I cannot figure out how to
> > set up the Analysis Services client-side components. The SQL Server 2005 CTP
> > setup does not seem to offer the this option. Any help here would be greatly
> > appreciated.
> >
> > Many thanks,
> > Gary
 >> Stay informed about: DSO Application with Analysis Services 2005 
Back to top
Login to vote
Chagel

External


Since: Oct 25, 2005
Posts: 1



(Msg. 4) Posted: Tue Oct 25, 2005 8:59 pm
Post subject: Re: DSO Application with Analysis Services 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi, Gary

can you go on use DSO to retrieve AS objects like cubes, dimensions..
after connected the server with changing the settings like you said? We
failed seems DSO needed to query data from Repository.
 >> Stay informed about: DSO Application with Analysis Services 2005 
Back to top
Login to vote
Peter H

External


Since: Sep 26, 2005
Posts: 2



(Msg. 5) Posted: Wed Oct 26, 2005 4:24 am
Post subject: Re: DSO Application with Analysis Services 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I did find the property settings in analysis services.
however, once connected, i also cannot retrieve objects.
I believe my DBA as me using the last CTP.

Error:
Invalid object name 'OlapObjects'.
At:
Dim oDatabases As DSO.OlapCollection
Set oDatabases = DSOServer.MDStores

Previously, this is what I did to be able to connect using 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

The above is where I left it - all I know - figured i would wait for Nov 7th.
But if there are any ideas, I would certainly try them.
thanks,
Peter.


"Chagel" wrote:

> Hi, Gary
>
> can you go on use DSO to retrieve AS objects like cubes, dimensions..
> after connected the server with changing the settings like you said? We
> failed seems DSO needed to query data from Repository.
>
>
 >> Stay informed about: DSO Application with Analysis Services 2005 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Aging receivables in Analysis Services 2005 - I am completely new to OLAP. I have searched books, newsgroups, various sites and Books Online...but aging does not seem to be addressed anywhere. Aging is a common business reporting requirement and I would have thought that Analysis Services or MDX..

Unexpected Error while deplying Analysis Services 2005 Cube - Hi Guys: All of a sudden I am getting this error below while deploying analysis services 2005 cube to the server. I am not sure what is causing this. Is anyone aware of this? Please let me know. Internal error: An unexpected error occurred (file..

Analysis Services 2005 Actions From Excel 2003 for Drillth.. - I'm interested finding out how to call or excecute a drillthrough action in SSAS 2005 from Excel 2003. I have a large rolap dimension and am unable to perform drillthrough using VB code. It works great if the dimension is MOLAP, but not ROLAP. When ...

sql 2005 analysis services - Does anyone know where I can get SQL 2005 analysis services tutorial? Thanks.

Analysis Services Newbie - I have just installed analysis services and I am going thourgh the tutorial, Quick Start. I followed the dirctions but after I make the first dimension it will not let me preview the dimension it says "Unable to browse the Dimension "New Dim...
   Database Forums (Home) -> OLAP All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]