环境：rhel6.9 mysql5.6 odbc连接 cognos11.0.8.0
在cognos 管理管理控制台界面上创建mysql odbc数据源后进行测试时报错：QE-DEF-0285登录失败
mysql测试失败.jpg
odbc配置：
[coguser@bejcad01 drivers]$ rpm -qa |grep ODBC
unixODBC-2.2.14-14.el6.i686
[coguser@bejcad01 drivers]$ rpm -qa |grep mysql-connect
mysql-connector-odbc-5.3.9-1.el6.i686
[coguser@bejcad01 drivers]$ cat /etc/odbc.ini
[cogdb]
Driver = MySQL
Description = mysql
Server = bejcad01
Database = cogdb
Port = 3316
User = coguser
Password = coguser
[coguser@bejcad01 drivers]$
检查odbc 连接mysql数据库登录成功
| [coguser@bejcad01 drivers]$ isql -v cogdb |
|---|
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
SQL> quit
麻烦大家帮我分析原因。
收起