Help! - Client Access To Remote Databases -
05-04-2006
, 06:45 PM
Hi
We have an app that connects via a .NET web service and adoMD.net to SSAS
2000 and eventually to SSAD 2005 using the following example connection
string (C# to SSAS 2000)
string sConStr=String.Format(CS_NAMEVALUE,CS_DATASOURCE," my2000DataSrc");
sConStr+="Integrated
Security=SSPI;Provider=MSOLAP.2;SSPI=NTLM;ConnectT o=8.0;Initial
Catalog="+my2000Catalog;
We are also in the process of upgrading our source code to .NET v2 on VS2005
and I've noticed the following problem in the 2005 environment when
connecting to remote MSAS servers.
To connect to a SSAS 2000 box from VS2003 takes about 8 seconds over an
pretty quiet network. To connect to a SSAS 2000 box from VS2005 takes about
15 - 20 seconds.
Also note:- If I connect to the same server without specifying the catalog
it connected immediately
Is there anything I'm doing wrong here? How do I improve the performance? |