Cube File Connection string ?
-
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 TryThe 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 MubashirEvery job is a self portrait of the person who did it.
-
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 TryThe 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 MubashirEvery job is a self portrait of the person who did it.
See this example: http://sqljunkies.com/WebLog/mosha/archive/2006/03/08/local_cube_password.aspx[^]
Vasudevan Deepak Kumar Personal Homepage Tech Gossips