cognos,数据源链接测试失败,如何解决?

0
本人使用的环境是win7+cognos8.4+oracle11,按照视频教程一步步操作,在framework,create一个项目然后配置数据源的时候,测试链接失败,失败原因见截图。我也看了很多网上关于测试链接失败的帖子,问题还是无法解决。对于sql*net连接字符串,我也找到了:
# tnsnames.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

COGNOS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cognos)
)
)

LISTENER_COGNOS =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
照理来说也没问题。可是就是连接不上。但是在cognos configuration中的IBM COGNOS CONTENT STORE中测试链接是成功的。但是user id and password和database naem (cm)这些个是默认的。
希望天山上的童姥们帮我解决下这个问题,万分感谢!!!
QQ图片20140827095832.jpg QQ图片20140827095825.jpg QQ图片123.jpg QQ图片456.jpg
已邀请:
0

梁勇 - 天道酬勤、上善若水。爱好商业智能 2014-08-27 回答

对应的是不是jar包没拷贝,参考下 Cognos 连接Oracle中 Jar驱动如何进行选择解决方案分享 http://www.flybi.net/question/821 ,把系统的版本也贴出来,是 64bit,还是32bit的。。
0

matoidwang - 人不行,别怪脚下路不平 2014-08-27 回答

好的,谢谢,我去试试看

要回复问题请先登录注册