dbTalk Databases Forums  

Help! - Client Access To Remote Databases

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Help! - Client Access To Remote Databases in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Gilly
 
Posts: n/a

Default 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?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.