Re: DSO, Retrieveing cube names and database names

use the adomd.net API instead of the DSO
its a .Net compatible API and easy to use

"jessi" <devakamma.reddy@xxxxxxxxx> wrote in message news:1183532455.552879.292300@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: Ping doesnt work
    ... Iam doing a direct RDP connection to the client server from my office PC. ... Iam trying to ping the internal pc by the IP address as well as the PC ...
    (microsoft.public.windows.server.general)
  • DSO, Retrieveing cube names and database names
    ... Now the problem is iam using DSO to retrieve database names and cube ... Cannot connect to the Analysis server on computer 'SQLSERVER'. ... Connection to the server is lost ...
    (microsoft.public.sqlserver.olap)
  • Re: sending emails using python
    ... if iam using the following code iam getting error ... server = smtplib.SMTP ... server.sendmail(fromAddress, toAddress, msg) ... this type of authentication might work.Because the same process ...
    (comp.lang.python)
  • Build up NAT/VPN Role Server
    ... 2003 Enterprise Server. ... Currently iam not running DHCP + DNS Server. ... putting the adapter that have access to internet as Primary Adapter, ... Share Resource but unable to access Internet. ...
    (microsoft.public.windows.server.networking)
  • error in outputting data with NI board
    ... When iam testing analog outout using measurement and automation explorer, iam getting the output displayed on DSO but there is a problem when iam trying to run the output using matlab. ... When iam inputing data from external source, iam able to see the output in matlab scope. ...
    (comp.soft-sys.matlab)