none
SQL Express Reporting Services data extension problem.

    Question

  • I am running SQL Express Advanced addition on an XP pro box.  The install went cleanly, and I have no problems creating and publishing reports that use a SQL server data source, however when I try and publish a report that uses an oracle data source I get the following error.

    An attempt has been made to use a data extension 'ORACLE' that is not registered for this report server.

    The report works fine withing the preview pain of Visual Studio, and it publishes fine within SQL 2005 standard edition. 

    Can someone please tell me how to register the data extension for ORACLE in SQL Express.

    Thanks for your help

    Robert Dennis
    Tuesday, September 12, 2006 3:42 PM

Answers

  • To answer my own question the below link shows that you can not connect to Oracle Data Sources in SQL Express. 

    http://msdn2.microsoft.com/en-us/library/ms365166.aspx
    Unsupported Features

    Other editions of SQL Server 2005 include a larger set of Reporting Services features. The following list describes the features that are documented in SQL Server Books Online, but cannot be used in this edition:

    • Scheduled report processing, caching, snapshots, subscriptions, and delivery are not supported.
    • Analysis Services, Oracle, XML, SAP, SQL Server Integration Services (SSIS), OLE DB, and ODBC data sources are not supported.
    • Remote data sources are not supported. Reports that are hosted in a SQL Server Express report server must retrieve SQL Server relational data from a local SQL Server Express Database Engine instance.
    • Ad hoc reporting through semantic models and Report Builder is not supported.
    • TIFF (Image), XML, and CSV rendering extensions are not supported.
    • The Reporting Services API extensible platform for delivery, data processing, rendering, and security is not supported.
    • Custom authentication extensions and custom role assignments are not supported. You must map existing Windows domain user and group accounts to predefined role definitions.
    • Managing a long-running report process is not supported. Specifically, you cannot use the Manage Jobs feature in Report Manager to stop report processing.
    • Scale-out deployment is not supported.

    Tuesday, September 12, 2006 7:14 PM

All replies

  • To answer my own question the below link shows that you can not connect to Oracle Data Sources in SQL Express. 

    http://msdn2.microsoft.com/en-us/library/ms365166.aspx
    Unsupported Features

    Other editions of SQL Server 2005 include a larger set of Reporting Services features. The following list describes the features that are documented in SQL Server Books Online, but cannot be used in this edition:

    • Scheduled report processing, caching, snapshots, subscriptions, and delivery are not supported.
    • Analysis Services, Oracle, XML, SAP, SQL Server Integration Services (SSIS), OLE DB, and ODBC data sources are not supported.
    • Remote data sources are not supported. Reports that are hosted in a SQL Server Express report server must retrieve SQL Server relational data from a local SQL Server Express Database Engine instance.
    • Ad hoc reporting through semantic models and Report Builder is not supported.
    • TIFF (Image), XML, and CSV rendering extensions are not supported.
    • The Reporting Services API extensible platform for delivery, data processing, rendering, and security is not supported.
    • Custom authentication extensions and custom role assignments are not supported. You must map existing Windows domain user and group accounts to predefined role definitions.
    • Managing a long-running report process is not supported. Specifically, you cannot use the Manage Jobs feature in Report Manager to stop report processing.
    • Scale-out deployment is not supported.

    Tuesday, September 12, 2006 7:14 PM
  •  

    Anyone know if SQL 2005 for Workgroups is subject to the same problem?

     

    I am having the exact same problem listed here.  Have Oracle 9i client installed. 

     

    Also, using this version, I cannot seem to define any data source connection types other than Microsoft SQL ( no ODBC, Oracle, OLE DB - they dont appear in the drop down box).

     

    Can someone point me in the right direction?

    Friday, October 19, 2007 5:52 PM
  • I've created a Custom Data Extension for reporting services, is it supported in Expression edition because I have the Following error message 

     

    The data processing extension used for this report is not available. It has either been uninstalled, or it is not configured correctly.

     

    When I open the Data Source in Report Manager.

     

    I made exactly the same configuration as on Standard Edition and its work on Standard Edition.

     

    Do somebody have an idea

    Friday, February 29, 2008 8:34 PM