OLEdb Issue

I am getting the following error:
Error 2 An attempt has been made to use a data extension 'OLEDB' that is not
registered for this report server. C:\Documents and
Settings\Administrator.WILLCARE\My Documents\Visual Studio
2005\Projects\Willcare\Willcare\Report2.rdl 0 0
I am trying to design a report to use an OLEDB data source. the designer is
working, I can connect, design the report, preview. everything looks great.
but when i go to publish this, I get the error above.
Advice?found my own answer.
it appears SQL Express with RS is handicapped to SQL and LOCAL database
support only. not much use there IMHO...
"john doe" <jdoe@.doe.com> wrote in message
news:u60hYOBhGHA.3496@.TK2MSFTNGP02.phx.gbl...
>I am getting the following error:
> Error 2 An attempt has been made to use a data extension 'OLEDB' that is
> not registered for this report server. C:\Documents and
> Settings\Administrator.WILLCARE\My Documents\Visual Studio
> 2005\Projects\Willcare\Willcare\Report2.rdl 0 0
> I am trying to design a report to use an OLEDB data source. the designer
> is working, I can connect, design the report, preview. everything looks
> great. but when i go to publish this, I get the error above.
> Advice?
>

OLE DB Provider no registered on local machine

I am receiving the following error when trying to run my report from the
server:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'SALESLOGIX'.
(rsErrorOpeningConnection) Get Online Help
The 'SLXOLEDB.1' provider is not registered on the local machine.
No error information available: REGDB_E_CLASSNOTREG(0x80040154).
I checked and this provider seems to only be available under the profile it
was installed. That being said I installed it under both profiles for my
service user and DB user. I checked the provider by testing it with a udl
file and it worked on both profiles. I rebooted the machine and I am still
having the same issue.Ok I found out my problem. This OLE DB provider has extra registery entries
that exist for the users profile. I installed the full application as the
MSRS user and configuerd the applications DB connection validated the
connection and the report now works.
"Ben Holcombe" wrote:
> I am receiving the following error when trying to run my report from the
> server:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'SALESLOGIX'.
> (rsErrorOpeningConnection) Get Online Help
> The 'SLXOLEDB.1' provider is not registered on the local machine.
> No error information available: REGDB_E_CLASSNOTREG(0x80040154).
> I checked and this provider seems to only be available under the profile it
> was installed. That being said I installed it under both profiles for my
> service user and DB user. I checked the provider by testing it with a udl
> file and it worked on both profiles. I rebooted the machine and I am still
> having the same issue.