SQL Server Performance

Report Builder and DB2

Discussion in 'SQL Server 2005 Reporting Services' started by jrep, Sep 27, 2006.

  1. jrep New Member

    I have successfully deployed a standard Report (i.e. non Report Builder) to our Report Server using a Shared Data Source to an iSeries Access for Windows Driver. The Data Source has the following properties:

    Type : OLEDB
    Connection String : Provider=IBMDA400.DataSource.1;Data Source=AA;Initial Catalog=AA;Default Collection=MITDTA;Catalog Library List=MITDTA,MVXBDTA

    The Report works perfectly using this connection.

    However when I try to run a Report Builder Report based on a Report Builder Model that uses this same shared connection I get the following error:

    An attempt has been made to use a data extension 'OLEDB' that is not registered for this report server.
    ----------------------------
    Cannot create command for data source 'dataSource1'.
    ----------------------------
    An error has occurred during report processing.

    Any ideas?

Share This Page