Microsoft SQL
Server Reporting Services (SSRS) can connect to a DB2® database
server by using an ODBC, OLE DB, or DB2 (IBM® Data Server Provider for .NET)
embedded connection type.
You can select
DB2 (
IBM Data Server Provider for .NET)
as an embedded connection type in the SSRS application if one of the
following
DB2 products
is installed in the SSRS environment:
- ADB2 database
server product (for example, DB2 Enterprise
Server Edition)
- IBM Data
Server Client
- IBM Data Server Runtime Client
- IBM Data
Server Driver Package
You can provide the credentials that are used in a connection
to a
DB2 database
if you select the
DB2 embedded
connection in the supported Microsoft Visual
Studio software. The credentials that you provide are masked instead
of being displayed in plain text. Use of the
DB2 embedded
connection is supported for SSRS 2008 and SSRS 2012.
If you install the SSRS software in an environment where the
DB2 product
is already installed, by default, only ODBC and OLE DB embedded connection
types are available for connections to
DB2 databases. The
reason is that the
DB2 installation
process updates the SSRS configuration files that are required to
list
IBM Data Server Provider for .NET in
the embedded connection type section of the Microsoft Visual Studio software. If you
installed the SSRS product after you installed the
DB2 software,
you cannot select the
IBM Data Server Provider for .NET when
you configure an embedded connection. If you want to select the
IBM Data Server Provider for .NET for
use, you must either reinstall the
DB2 product
or start the IBM Data Server
configuration tool.
- To reinstall the DB2 product:
- Open the Control Panel.
- In the Programs and Features window, right-click
the entry for the DB2 product.
- Click the Repair or Change button.
- To start the IBM Data Server Provider for .NET configuration
tool:
- Open the IBM DB2 group icon.
- Select the default DB2 copy.
For example, DB2COPY1.
- Select the Set-up Tools icon.
- Select the Configure DB2 .NET Data Provider icon.
The IBM Data Server Provider for .NET configuration
tool (Configure DB2 .NET Data Provider) is
not available for the IBM Data
Server Driver Package installation.