Hello,
last command (Set dsoCube=...) of this sample code takes over 30 secs when
the connected server is remote. (server is in the same 100Mbit LAN)
When I run this script right on OLAPSRV, time < 1 sec.
How can I solve it ?
Thanks in advance for any response...

Set dsoServer = CreateObject("DSO.Server")
dsoServer.Connect "OLAPSRV"
Set dsoDB = dsoServer.MDStores("VOIS")
Set dsoCube = dsoDB.MDStores("Sales")

(SQL2000, SP2, Repository is in Analysis native format - SQLServer)

Hi Petr,

Thanks for your feedback. What do you mean by "Client has none CPU usage
during connecting."?
You wrote it takes about 30 seconds that when you performed the "Set
dsoCube = dsoDB.MDStores("Sales") " statement on your computer, so I would
like to know if the CPU usage is high at that time. Based on my experience,
when the cube is designed very complex, the problem mentioned in this post
may occur.

Also, due to the nature of this issue, it would be best to contact
Microsoft Product Support Services via telephone so that a dedicated
Support Professional can assist with your request. To obtain the phone
numbers for specific technology request please take a look at the web site
listed below.
http://support.microsoft.com/default...S;PHONENUMBERS

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.