Connection.Open Performance -
05-02-2006
, 02:50 AM
Hi
I've just upgraded my Visual Studio project to version 2005. Our project is
a web app that consumes our own web services to link to MSAS 2000 SP4.
On my client PC I have also installed SQL & M(S?)SAS 2005 however, my
datasource and catalog still point to a 2000 SP4 server.
When I open the connection, it takes between 7 and 20 seconds for the
connection to open
this is my connection string
string sConStr=String.Format(CS_NAMEVALUE,CS_DATASOURCE," my2000DataSrc");
sConStr+="Integrated
Security=SSPI;Provider=MSOLAP.2;SSPI=NTLM;ConnectT o=8.0;Initial
Catalog=Foodmart 2000";
All works well when running in Vis Studio 2003, I have also installed XMLA,
ADOMD.net and SOAP SDK. I've even added the xmla folder to IIS which I know
is no longer needed. I can browse to the dll and view the SOAP response.
What am I missing?
Thanks in advance
Graham |