如图,配好的数据源,在DB2命令行模式下是能连的通的。
在cognos服务器中配置的时候,显示JDBC模式是通的,兼容模式失败
cognos版本10.1,DB2版本9.7
后台点击报表无反应,日志为:
Failure QE-DEF-0285 The logon failed. QE-DEF-0285 The logon failed.QE-DEF-0325 The logon failed for the following reason:RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: test UDA-SQL-0031 Unable to access the "test" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.UDA-SQL-0107 A general exception has occurred during the operation "attach".[IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004收起