|
Home > Archive > MS SQL Server OLAP > March 2006 > Cannot instantiate OLEDBSimpleProvider component
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Cannot instantiate OLEDBSimpleProvider component
|
|
| dustbort 2006-03-28, 1:31 pm |
| I am currently using Analysis Services 2000 SP3 with SQL Server 2000 SP4.
When I open Analysis Manager and go to any cube and click the data tab, I
get one of the following errors:
"Provider cannot be found. It may not be properly installed." upon the first
click of the data tab; or
"Cannot instantiate OLEDBSimpleProvider component." upon going to a
different tab and then back to data tab.
The problem began when I upgraded AS 2000 from RTM to SP4. The installation
of SP4 went smoothly, but when I went to the data tab in Analysis Manager I
saw these errors. Upon checking the connection string to the repository in
Analysis Manager, the provider was (from memory) "Microsoft.Jet.OLEDB.4". I
subsequently then went and updated SQL Server from SP3 to SP4 to match AS,
and this had no effect. So I reinstalled the AS 2000 SP4 with no effect.
Then I migrated the data repository from Access to SQL Server. Now the
provider in the connection string to the repository was "SQLOLEDB.1", but I
still got the same error. Then I reinstalled AS 2000 without first
uninstalling: same error. Then I uninstalled AS 2000 and reinstalled it:
same error. The version still indicates it is SP4 even though it was a RTM
installation I the applied SP3 (on the same CD as RTM install) and the
version of AS 2000 still indicates SP4: same error. After this I installed
MDAC 2.8 SP1 and Jet SP8: same error. After most if not all of these steps,
I rebooted the machine before opening Analysis Manager, so any changes would
take effect.
The problem only seems to be with the provider or OLEDBSimpleProvider
component. In addition to Analysis Manager, there are some client
applications on the intranet that also raise the "Cannot instantiate
OLEDBSimpleProvider component." error. I can run a full process on the
cubes with no problem.
Does anyone know what the heck is going on???
| |
| Akshai Mirchandani [MS] 2006-03-28, 8:27 pm |
| Can you check if you have this file:
<program files>\common files\system\ole db\msdaosp.dll
And try to re-register it:
regsvr32 "<program files>\common files\system\ole db\msdaosp.dll"
This is the OLE DB Simple Provider that comes as part of MDAC -- it gets
invoked by the OLE DB for OLAP driver in a few situations and perhaps it has
somehow become invalid...
HTH,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"dustbort" <dustbort at yahoo dot com> wrote in message
news:OKmTH3oUGHA.2360@TK2MSFTNGP09.phx.gbl...
>I am currently using Analysis Services 2000 SP3 with SQL Server 2000 SP4.
>When I open Analysis Manager and go to any cube and click the data tab, I
>get one of the following errors:
>
> "Provider cannot be found. It may not be properly installed." upon the
> first click of the data tab; or
> "Cannot instantiate OLEDBSimpleProvider component." upon going to a
> different tab and then back to data tab.
>
> The problem began when I upgraded AS 2000 from RTM to SP4. The
> installation of SP4 went smoothly, but when I went to the data tab in
> Analysis Manager I saw these errors. Upon checking the connection string
> to the repository in Analysis Manager, the provider was (from memory)
> "Microsoft.Jet.OLEDB.4". I subsequently then went and updated SQL Server
> from SP3 to SP4 to match AS, and this had no effect. So I reinstalled the
> AS 2000 SP4 with no effect. Then I migrated the data repository from
> Access to SQL Server. Now the provider in the connection string to the
> repository was "SQLOLEDB.1", but I still got the same error. Then I
> reinstalled AS 2000 without first uninstalling: same error. Then I
> uninstalled AS 2000 and reinstalled it: same error. The version still
> indicates it is SP4 even though it was a RTM installation I the applied
> SP3 (on the same CD as RTM install) and the version of AS 2000 still
> indicates SP4: same error. After this I installed MDAC 2.8 SP1 and Jet
> SP8: same error. After most if not all of these steps, I rebooted the
> machine before opening Analysis Manager, so any changes would take effect.
>
> The problem only seems to be with the provider or OLEDBSimpleProvider
> component. In addition to Analysis Manager, there are some client
> applications on the intranet that also raise the "Cannot instantiate
> OLEDBSimpleProvider component." error. I can run a full process on the
> cubes with no problem.
>
> Does anyone know what the heck is going on???
>
| |
| dustbort 2006-03-28, 8:27 pm |
| I found the file and ran the command you gave. A message box comes up that
says:
"msdaosp.dll" is not an executable file and no registration helper is
registered for this file type.
"Akshai Mirchandani [MS]" <akshaim@online.microsoft.com> wrote in message
news:e0%235CNrUGHA.776@TK2MSFTNGP09.phx.gbl...
> Can you check if you have this file:
>
> <program files>\common files\system\ole db\msdaosp.dll
>
> And try to re-register it:
>
> regsvr32 "<program files>\common files\system\ole db\msdaosp.dll"
>
> This is the OLE DB Simple Provider that comes as part of MDAC -- it gets
> invoked by the OLE DB for OLAP driver in a few situations and perhaps it
> has somehow become invalid...
>
> HTH,
> Akshai
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> Please do not send email directly to this alias. This alias is for
> newsgroup
> purposes only.
>
> "dustbort" <dustbort at yahoo dot com> wrote in message
> news:OKmTH3oUGHA.2360@TK2MSFTNGP09.phx.gbl...
>
>
| |
| Akshai Mirchandani [MS] 2006-03-29, 3:29 am |
| Something is wrong here -- it looks like the file is corrupted. I'm not
familiar with how you can repair MDAC, but that appears to be needed on this
box.
Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"dustbort" <dustbort at yahoo dot com> wrote in message
news:O%23cbz%23rUGHA
.5468@TK2MSFTNGP14.phx.gbl...
>I found the file and ran the command you gave. A message box comes up that
>says:
>
> "msdaosp.dll" is not an executable file and no registration helper is
> registered for this file type.
>
> "Akshai Mirchandani [MS]" <akshaim@online.microsoft.com> wrote in message
> news:e0%235CNrUGHA.776@TK2MSFTNGP09.phx.gbl...
>
>
|
|
|
|
|