ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problem connecting to Analysis Services (https://www.excelbanter.com/excel-discussion-misc-queries/75930-problem-connecting-analysis-services.html)

ln54

Problem connecting to Analysis Services
 
I can no longer connect My EXCEL spreadsheet Office 2003
to Analysis Server/SQL Server 2000 .
----------
Error Message:
Open Connection failed, Unable to open connection, Unspecified eror.
-------------------------------------------------------------------
I has worked OK for a long time but suddenly not.

I have tried to reinstall Office, MDAC 8.0 and PTSLite file from SQL server
servicepack 3
but nothing works.

Do I really need to reinstall windows and all programs from the start??,
my colleagues do not experience these problems.

Miguel Zapico

Problem connecting to Analysis Services
 
The latest service pack for analysis services and SQL server is SP4, can you
apply it to the server?
--
It is nice to be important, but it is more important to be nice


"ln54" wrote:

I can no longer connect My EXCEL spreadsheet Office 2003
to Analysis Server/SQL Server 2000 .
----------
Error Message:
Open Connection failed, Unable to open connection, Unspecified eror.
-------------------------------------------------------------------
I has worked OK for a long time but suddenly not.

I have tried to reinstall Office, MDAC 8.0 and PTSLite file from SQL server
servicepack 3
but nothing works.

Do I really need to reinstall windows and all programs from the start??,
my colleagues do not experience these problems.



All times are GMT +1. The time now is 06:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com