dbTalk Databases Forums  

Connection.Open Performance

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


Discuss Connection.Open Performance in the microsoft.public.sqlserver.olap forum.



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

Default 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



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.