DSO, Retrieveing cube names and database names
- From: jessi <devakamma.reddy@xxxxxxxxx>
- Date: Wed, 04 Jul 2007 00:00:55 -0700
Hi group,
iam emily i mailed before inthis group about this i got a reply too,
Now the problem is iam using DSO to retrieve database names and cube
names and iam not getting any built in error and stuff but when i run
it it gives me this error if anyone could could c that and suggest me
any suggestions it would be really appreciated.
I installed SP3 and i have OLAP Admin permissions but then also iam
getting this error
the error is
Cannot connect to the Analysis server on computer 'SQLSERVER'.
Connection to the server is lost
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: Cannot
connect to the Analysis server on computer 'SQLSERVER'. Connection to
the server is lost
Source Error:
Line 35: dsoServer = CreateObject("DSO.Server")
Line 36:
Line 37: dsoServer.Connect("SQLSERVER")
Line 38:
Line 39: ' Step through the databases in the server object.
Source File: C:\Inetpub\wwwroot\KSRRK\KSRRK.aspx.vb Line: 37
Stack Trace:
[COMException (0x80040075): Cannot connect to the Analysis server on
computer 'SQLSERVER'.
Connection to the server is lost]
DSO.ServerClass.Connect(String ServerName) +0
KSRRK.WebForm1.Page_Load(Object sender, EventArgs e) in C:\Inetpub
\wwwroot\KSRRK\KSRRK.aspx.vb:37
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750
Thanks a lot
emily
.
- Follow-Ups:
- Prev by Date: DSO, retrieve cube names and data base names
- Next by Date: Re: Drop down for cube names
- Previous by thread: DSO, retrieve cube names and data base names
- Next by thread: Re: DSO, Retrieveing cube names and database names
- Index(es):
Relevant Pages
|