Thursday, March 8, 2012

"Keyword not supported: 'provider'." error with Report Builder

Hi,

I'm trying to process reports with Report Builder against a SQL Server Database.

When the .Net Provider is used in the model, everything works fine.

But if I try to use another provider (the .Net Provider for OLEDB or the native OLEDB one) to connect to the data source, i've got the following error when trying to process the report in Report Builder: Keyword not supported: 'provider'.

Is this a normal behaviour of the Report Builder ?

Thanks in advance.

Grgory.

I have tried OLE DB data sources (for Sybase) on SQL Server 2005 server, and it just doesn't work. Ended up using ODBC

The same steps worked fine on SQL Server 2000 (can access Sybase through OLE instead of ODBC)

I think it's not really a Report Server issue

No comments:

Post a Comment