reporting-services - SSRS 中的 DB2 数据源

Question

我必须从 SSRS 连接到 Db2 数据源并创建报告。我在我的系统上安装了最新的 Db2 客户端。

在 SSRS 中添加数据源时，我选择了“OLEDB”数据源，然后选择了“IBM OLEDB Provider”，在输入服务器名、用户名、密码后...它会抛出一条错误消息......

The database alias couldn't be found in db2dsdriver.cfg configuration file.

谁能给我指出正确的方向

Answer 1

可以找到有关该特定文件的 IBM 文档 here .它解释了它是什么，并解释了如何编辑它。

基本上，您需要在报表服务器上编辑文件并添加服务器名称。

摘录:

The db2dsdriver.cfg configuration file can be edited. However, the file must be edited manually. In addition, after editing the file, you must restart the application for the changes to take effect. The configuration file is created in one of the following paths: for a data server client, the configuration file is created in a folder named cfg under the instance path:

• On AIX®, HP-UX, Linux, or Solaris operating systems, instance_path/cfg
• On Windows operating systems, instance_path\cfg

for a data server driver, the configuration file is created in a folder named cfg under the installation path:

• On AIX, HP-UX, Linux, or Solaris operating systems, installation_path/cfg
• On Windows operating systems, installation_path\cfg

A sample configuration file is shipped to help you get started. It is located in the sqllib/cfg directory. The configuration file contains the following sections:

• the data source name section contained within the DSN_Collection tags,
• the database information section contained within the databases tags,
• the global attributes section contained within the parameters tags.

<configuration>
    <DSN_Collection>
        <dsn alias="alias1" name="name1" host="server1.net1.com" port="50001"/>
        <!-- Long aliases are supported -->
        <dsn alias="longaliasname2" name="name2" host="server2.net1.com" port="55551">
            <parameter name="Authentication" value="Client"/>
        </dsn>
    </DSN_Collection>
    <databases>
        <database name="name1" host="server1.net1.com" port="50001">
            <parameter name="CurrentSchema" value="OWNER1"/>
            <WLB>
                <parameter name="enableWLB" value="true"/>
                <parameter name="maxTransports" value="50"/>
            </WLB>
            <ACR>
                <parameter name="enableACR" value="true"/>
            </ACR>
        </database>
        <!-- Local IPC connection -->
        <database name="name3" host="localhost" port="0">
            <parameter name="IPCInstance" value="DB2"/>
            <parameter name="CommProtocol" value="IPC"/>
        </database>
    </databases>
    <parameters>
        <parameter name="GlobalParam" value="Value"/>
    </parameters>
</configuration>