 | |
DSO.Server Connect method not responding
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DSO.Server Connect method not responding -
02-16-2004
, 06:34 AM
|
My name is Michael and I would like to thank you for using Microsoft newsgroup. According to your description, it seems that you are failed to connect to Connect to the Analysis Server using DSO. There is no any response. If I have misunderstood, please feel free to let me know. I would like you to provide more information so that I can narrow down this issue. 1. What is the server name you used in connection, Http server name or normal Server name? 2. What is the version of this file msmdsrv.exe? (Usually under C:\Program Files\Microsoft Analysis Services\Bin\msmdsrv.exe) 3. How do you think there is not any response? It is possible that the connection needs a long time, but you break the connection before it feedbacks. I would like you to wait more time to see if there is something happening. 4. How many objects are referring to databases/cubes/dimensions in Analysis Server? Usually with more objects (Databases, Cubes, Dimensions ect.) the slower the connection will be, since DSO has to read the entire repository when connecting. 5. Please try to connect to Analysis Server using Analysis Manager. Does any problem occur? If so, please provide the detailed error message. It is appreciated that you can provide screen shot of the error message to help describe the problem I found the following article for your reference. Programming OLAP Databases from Microsoft Access Using DSO http://msdn.microsoft.com/library/de...us/dnacc2k2/ht ml/odc_AccessDSO.asp Also, due to the complexity 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. |
#2
| |||
| |||
|
|
Hi Michael (or anybody else),You are right: there is no response when I try to connect to Analysis Server using DSO.The answers to your questions are:1. I use a normal server name (no http server name) like "dsoServer.Connect("myServerName");". Actually I tried to connect to different names (my local PC name or even fake ones), but all don't give me a response of the Connect statement.2. The version of the msmdsrv.exe file is 8.0.760.0 (AS version is 8.0.760.0 and SQL Server 2000 version is 8.00.761).3. I wait for more then 10 minutes to let it connect, but it does not respond.4. Only one (according to my colleque).5. I can connect to Analysis Server using Analysis Manager. I see my local machine and I can see the "myServerName" server.I have read the article you mentioned allready before posting my problem (thanks anyway for the link).As extra information I can tell you that I have to run the MS SQL Server Analysis Server service pack 3 every (couple of) day(s) because otherwise the references "DSO" and "POMInterfaces" in my Visual Studio.NET windows service project are disrupted!Hope to hear from you soon, Marco> Hello Marco, My name is Michael and I would like to thank you for using Microsoft newsgroup. According to your description, it seems that you are failed to connect to Connect to the Analysis Server using DSO. There is no any response. If I have misunderstood, please feel free to let me know. I would like you to provide more information so that I can narrow down this issue. 1. What is the server name you used in connection, Http server name or normal Server name? 2. What is the version of this file msmdsrv.exe? (Usually under C:\Program Files\Microsoft Analysis Services\Bin\msmdsrv.exe) 3. How do you think there is not any response? It is possible that the connection needs a long time, but you break the connection before it feedbacks. I would like you to wait more time to see if there is something happening. 4. How many objects are referring to databases/cubes/dimensions in Analysis Server? Usually with more objects (Databases, Cubes, Dimensions ect.) the slower the connection will be, since DSO has to read the entire repository when connecting. 5. Please try to connect to Analysis Server using Analysis Manager. Does any problem occur? If so, please provide the detailed error message. It is appreciated that you can provide screen shot of the error message to help describe the problem I found the following article for your reference. Programming OLAP Databases from Microsoft Access Using DSO http://msdn.microsoft.com/library/de...us/dnacc2k2/ht ml/odc_AccessDSO.asp Also, due to the complexity 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. |
#3
| |||
| |||
|
|
Hi Michael (or anybody else), You are right: there is no response when I try to connect to Analysis Server using DSO. The answers to your questions are: 1. I use a normal server name (no http server name) like "dsoServer.Connect("myServerName");". Actually I tried to connect to different names (my local PC name or even fake ones), but all don't give me a response of the Connect statement. 2. The version of the msmdsrv.exe file is 8.0.760.0 (AS version is 8.0.760.0 and SQL Server 2000 version is 8.00.761). 3. I wait for more then 10 minutes to let it connect, but it does not respond. 4. Only one (according to my colleque). 5. I can connect to Analysis Server using Analysis Manager. I see my local machine and I can see the "myServerName" server. I have read the article you mentioned allready before posting my problem (thanks anyway for the link). As extra information I can tell you that I have to run the MS SQL Server Analysis Server service pack 3 every (couple of) day(s) because otherwise the references "DSO" and "POMInterfaces" in my Visual Studio.NET windows service project are disrupted! Hope to hear from you soon, Marco "Marco Liedekerken" <nospam (AT) hotmail (DOT) com> wrote in message news:ek2NqkI9DHA.2676 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Hi Michael (or anybody else),You are right: there is no response when I try to connect to Analysis Server using DSO.The answers to your questions are:1. I use a normal server name (no http server name) like "dsoServer.Connect("myServerName");". Actually I tried to connect to different names (my local PC name or even fake ones), but all don't give me a response of the Connect statement.2. The version of the msmdsrv.exe file is 8.0.760.0 (AS version is 8.0.760.0 and SQL Server 2000 version is 8.00.761).3. I wait for more then 10 minutes to let it connect, but it does not respond.4. Only one (according to my colleque).5. I can connect to Analysis Server using Analysis Manager. I see my local machine and I can see the "myServerName" server.I have read the article you mentioned allready before posting my problem (thanks anyway for the link).As extra information I can tell you that I have to run the MS SQL Server Analysis Server service pack 3 every (couple of) day(s) because otherwise the references "DSO" and "POMInterfaces" in my Visual Studio.NET windows service project are disrupted!Hope to hear from you soon, Marco> Hello Marco, My name is Michael and I would like to thank you for using Microsoft newsgroup. According to your description, it seems that you are failed to connect to Connect to the Analysis Server using DSO. There is no any response. If I have misunderstood, please feel free to let me know. I would like you to provide more information so that I can narrow down this issue. 1. What is the server name you used in connection, Http server name or normal Server name? 2. What is the version of this file msmdsrv.exe? (Usually under C:\Program Files\Microsoft Analysis Services\Bin\msmdsrv.exe) 3. How do you think there is not any response? It is possible that the connection needs a long time, but you break the connection before it feedbacks. I would like you to wait more time to see if there is something happening. 4. How many objects are referring to databases/cubes/dimensions in Analysis Server? Usually with more objects (Databases, Cubes, Dimensions ect.) the slower the connection will be, since DSO has to read the entire repository when connecting. 5. Please try to connect to Analysis Server using Analysis Manager. Does any problem occur? If so, please provide the detailed error message. It is appreciated that you can provide screen shot of the error message to help describe the problem I found the following article for your reference. Programming OLAP Databases from Microsoft Access Using DSO http://msdn.microsoft.com/library/de...us/dnacc2k2/ht ml/odc_AccessDSO.asp Also, due to the complexity 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. |
#4
| |||
| |||
|
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.