Cube File Connection string ?

[_mubashir]

Hello All, I am working in Visual Studio 2003. I want to access local cube (.cub) file with ADODB object. How is this possible? I am using the following code, but it doesnt seems to work Dim cnActive As New ADODB.Connection Dim rs As ADODB.Recordset cnActive = New ADODB.Connection Try cnActive.Open("provider=msolap;Data Source=c:\temp\mycube.cub;", "", ",0) rs = cnActive.OpenSchema(ADODB.SchemaEnum.adSchemaCatalogs) Catch ex As Exception sError = ex.Message Exit Sub End Try The error is "The operation has failed because of an error in the COM component - unknown error c:\temp\mycube.cub Access Denied. ". I have given full access to this folder but no use. Any ideas? thanx Mubashir

Every job is a self portrait of the person who did it.