Problems when retrieving cubes schema using OleDb

Hello,

I'm using Analysis Service 9.0 OleDb provider to retrieve a schema from the data source as follows:

Code Snippet

olapConnection.GetOleDbSchemaTable(OLAPSchemaGuid.Cubes, new object[] { catalogName });

The problem is that I cannot get a cube list from some catalogs. For example, I can list cubes from the "OLAPTestCube" catalog, but I cannot do this from the "Adventure Works DW". It seems to me the problem appeared after upgrading SQL Server to SP2. What may cause this behavior?

Thank you,

I've got it. The solution was to call the OleDbConnection.ChangeDatabase method. It seems to me that GetOleDbSchema method works in scope of the current catalog.