DSO, Retrieveing cube names and database names



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

.



Relevant Pages

  • Re: Cant login anymore since an update
    ... The application 'gnome-session' lost its connection to the display:0.0; ... most likely the X server was shut down or you killed/destroyed the application. ...
    (Debian-User)
  • Cant login anymore since an update
    ... The application 'gnome-session' lost its connection to the display:0.0; ... most likely the X server was shut down or you killed/destroyed ...
    (Debian-User)
  • Re: Outlook Express 6 wont send or receive email
    ... You lost me after 'your DNS service may be FUBAR', so I tried openDNS, ... Thunderbird reported that the server refused the connection. ... | Connection to host lost. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Need help from an X guru!
    ... most likely the X server was shut down or you killed/destroyed ... The application 'rhn-applet' lost its connection to the display:0.0; ...
    (RedHat)
  • Re: Networking messed up, bad checksum, incorrect length
    ... but it seems as if Netfilter lost the Established state for this connection. ... destination server, so the destination server send DUP ACKs trying to ...
    (Linux-Kernel)