Re: Analysis Server (provider cannot be found or not installed)

#1

Hi Dejan,

Make sure te JET.4 oledb provider is installed on the machine by testing it
with a .udl file. The Microsoft.jet.4.0 OLEDB provider should be listed. It
is
the default driver used by MS Analysis Services to connect the repository.

If it is not installed, you could test the following method :
- create an ODBC DSN that point to the msmdrep.mdb file.
- In Ms Analysis Manager, edit the repository connection string to point to
the DSN
you just created.
- Open Ms Analysis Services.

If it works, you should reinstall the Jet engine, but the best would be to
migrate the repository
to MS SQL Server.

Lionel BILLON (MVP)
WINSIGHT - www.olapwebhouse.com

"Dejan Milic" <nepitaj (AT) free (DOT) fr> wrote

Quote:

Hi,

I have an issue with Analysis Server on windows 2000 multilanguage
version.

The setup runs fine without any error, the service starts but :
I'm not able to connect to the local analysis server(provider cannot
be found or not installed) using the mmc.

Using the MDX sample app I'm able to connect but there is no cube
listed in the combo box.

The default foodmart cube is not installed in the data folder.

The access databases which handle the repository aren't locked
and I'm able to connect to the repository database using odbc.

I already tried to install analysis services SP3 en
MDAC 2.8 en
JET 4.0 version 8 en
This machine has also office 2000 SR-1.

Do you have any clue ?

Regards,

Dejan MILIC

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Analysis Server (provider cannot be found or not installed)

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

Re: Analysis Server (provider cannot be found or not installed) - 02-18-2005 , 04:16 AM