Re: .net 2 and ADOMD

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Can you run a trace on the HTTP messages? There are several tools there that
let you do this...

Also, can you verify which version of ADOMD.NET you are using? There are two
of them -- the original web release and the new one that became available
with AS 2005 (and is also available as a web download).

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Graham Lloyd" <gilly1409@xxxxxxxxxxx> wrote in message
news:%23Z4diMUfGHA.3652@xxxxxxxxxxxxxxxxxxxxxxx
Hi Jeje

I now get the same problem when I try to retieve catalogs from a remote
machine using the following line

dsCatlogs = mcnADOMD.GetSchemaDataSet(AdomdSchemaGuid.Catalogs, oRest);

the stack trace is as follows

StackTrace " at
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String
requestType, IDictionary restrictions, InlineErrorHandlingType
inlineErrorHandling, Boolean sendNamespaceCompatibility)\r\n at
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.RetrieveSchemaRowsets(Boolean
createSession)\r\n at
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(Guid
schema, Object[] restrictions, Boolean throwOnInlineErrors)\r\n at
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(Guid
schema, Object[] restrictions)\r\n at spfData.Web.getCatalogs(String
sDataSrc) in D:\\Development\\Calumo
Projects\\CalumoWeb\\calDAL\\msOlap.cs:line 1250" string

when I connect to the box remotely using xmla. It all works fine if I use
TCP but rmote TCP connection takes roughly 20 seconds. It is only that
box, so something is not installed or not runing correctly. It also
appears the same issue occurs when trying to connect on the local box
using TCP or using localhost rather than the machine name

I've tried

reinstall XMLA, SOAP, .NET v2, ADOMD9


any other ideas?

cheers

"Graham Lloyd" <gilly1409@xxxxxxxxxxx> wrote in message
news:OrHLQg7eGHA.4304@xxxxxxxxxxxxxxxxxxxxxxx
thanks Jeje

I will alter our code to be configuarable to use TCP or HTTP. I had used
only HTTP as the performance of remote TCP connections was really bad (20
odd seconds to open a connection on a remote MSAS server)

thanks for the info

Any ideas on the Ordinal issue I posted earlier?

Cheers


"Jeje" <willgart@xxxxxxxxxxx> wrote in message
news:OMJV0G7eGHA.3572@xxxxxxxxxxxxxxxxxxxxxxx
sometimes a local HTTP access doesn't works if the URL is not localhost
but http://<server>
I have this type of issue.
A loopback network card could help you

but you can also use http://localhost
or use a direct connection (not HTTP) to your server. The performance is
better.

"Graham Lloyd" <gilly1409@xxxxxxxxxxx> wrote in message
news:%23jtWVs6eGHA.2032@xxxxxxxxxxxxxxxxxxxxxxx
Hi

We've recently upgraded our dev environments to .net V2 and am getting
a constant error from XMLA when I try to connect.

"The Namespace XA:Session could not be found"

This only happens when we try to connect to a local MSAS2000 server, it
can connect to remote MSAS2000 server or remote 2005 servers.

Am I missing a pre-requisite install? I have run adomd v9, xmla sdk and
soap sdk in my attempts to access the server and also configured xmla
on IIS.

Connection string is
sConStr = "Data Source=http://"; + sDataSrc + "/xmla/msxisapi.dll;";

where sDataSrc is the name of the local server

TIA










.



Relevant Pages

  • Re: Connecting a remote workstation to a domain
    ... If you have more than a couple of remote workstations connecting to the SBS ... server via VPN, you really need to consider a Terminal Server in the main ... "Log in using a dial up connection" checkbox, ... roaming profile then synchronizes with the server over the VPN); ...
    (microsoft.public.windows.server.sbs)
  • Re: Problem with Web based client
    ... Seems like you are having problems accessing the web server on the PC you ... > My remote desktop connection works fine when I connect with a Remote ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: Remote Access and ISA Server in SBS 2003?
    ... I am glad to hear the Remote Access Wizard is working fine now. ... there is no difference in VPN between SBS 4.5 and SBS ... Error Message: VPN Connection Error 800: Unable to Establish Connection ... the external NIC of the SBS Server. ...
    (microsoft.public.windows.server.sbs)
  • RE: Another Remote Connection Manager Problem
    ... > internal and 192.168.1.3 for the internet connection. ... > via the SBS server to all clients. ... > With this configuration OWA and Remote Workplace are operational. ... > Connection Manager to connect to the VPN server and gain access to a shared ...
    (microsoft.public.windows.server.sbs)
  • Re: Another Remote Connection Manager Problem
    ... > internal and 192.168.1.3 for the internet connection. ... > via the SBS server to all clients. ... > With this configuration OWA and Remote Workplace are operational. ...
    (microsoft.public.windows.server.sbs)