Umanga


Hi,

I installed the analysis server 2005 version.

When I'm trying to get the databases in an OLAP server using DSO it gave me the error, "Invalid object name 'OlapObjects' "

Following is my vb code.

dsoServer.Connect (sServer)
For i = 1 To dsoServer.MDStores.count
Set dsoTempDB = dsoServer.MDStores(i)
ComboboxName.AddItem dsoTempDB.name
Next

I tried installing Analysis server 2005 several times, and installed service pack 2 as well. But still I get this error.

Please help.

Thank you.




Re: Invalid object name 'OlapObjects'

Edward Melomed


First. You should really take a look at using AMO object model to perform any tasks with Analysis Services 2005 . AS2005 is completely different from AS2000 and AMO is way better way to perform any tasks with it. You will be way better off investing your time and energy with looking into using AMO.

Having said that, if your application absolutely requres DSO here is set of instructions on how to get it working http://msdn2.microsoft.com/en-us/library/ms403370.aspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.







Re: Invalid object name 'OlapObjects'

Umanga

Hi,

Thank u very much for the information.

I was able to connect to my analysis server 2000 repository according to the steps given in the URL .

I have another question related to DSO. Is it possible to connect to analysis server 2005 using DSO as well

I also agree with you about using AMO. But for the moment I have to connect to the analysis server using DSO. But I would looking into using AMO later.

Thanks again for your help.






Re: Invalid object name 'OlapObjects'

Edward Melomed

It is possible to connect to AS2005 using DSO.

In fact DSO will under the covers invoke AMO, it will pass all the information to AMO and then AMO will make the conneciton.


Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.






Re: Invalid object name 'OlapObjects'

Umanga

HI Again,

Do you know what's the provider I should use when giving the RepositoryConnectionString for DSO to get databases configured in Analysis server 2005.

When I used OLE DB provider for Analysis service 9.0 , It gave the following error.

"Query (1, 10) Parser: The syntax for ',' is incorrect."

Thanks

Umanga.





Re: Invalid object name 'OlapObjects'

Edward Melomed

I think there is a little bit of misunderstanding. The paper on http://msdn2.microsoft.com/en-us/library/ms403370.aspx states you should use something like Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program files\Microsoft SQL Server\MSSQL.n\OLAP\DSO\msmdrep.mdb;Persist Security Info=False


Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.






Re: Invalid object name 'OlapObjects'

Umanga

Hi,

It worked for getting the databases configured in Analysis server 2000 from sql server 2005.

I want to get the newly created databases using SQL Server Business Intelligence Development Studio in sql server 2005 from DSO.

For example, now when I check from the sql server management studio, it shows food mart database (2000) and my new database created in 2005 ,

But using the "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program files\Microsoft SQL Server\MSSQL.n\OLAP\DSO\msmdrep.mdb" it shows only database Food mart (configured in 2000)

Do you think it's possible to get databases added in 2005 using DSO as well, or should I use AMO

Hope my question is clear now

Thanks

Umanga.





Re: Invalid object name 'OlapObjects'

Edward Melomed

As I mentioned earlier, support for DSO is very limited. It is there mainly for backward compartibility of existing applications and exisiting cubes.

The way DSO works with AS2005 is that it will not show you the server cube created using BI Dev studio. For that you will need to start using AMO object model.

If looks at functionality offered by AS2005 and new ideas it has, it is very different from AS2000. So many properties, objects and concepts are different. DSO simply not the way to manager AS2005.


Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.