环境: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
麻烦大家帮我分析原因。