情况一:Universe链接Oracle(选择客户端链接方式)
开发端:客户端装的BO Client Tool 4.0版本要和Oracle Client要一致,即同为32位或64位
运行时:由于BOE 4.0为64位,所以在BOE调相应驱动时会调用:C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\drivers\lib64\dbd_oci.dll
所以要保证在服务器端安装64位的Oracle client, 32位的会报错
情况二:Universe 链接SQL Server或Oracle (用JDBC方式连接)
1.配置classpath环境变量
2.将C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc
目录下的文件jdbc.sbo文件打开,添加类路径:
<ClassPath>
<Path>C:\\XJL\\Install Software\\Drivers\\sqljdbc.jar</Path>
</ClassPath>
</DriverConfiguration>
补充:
当时解决的chartset issue:
2.Also you need to
(the purpose of adding PATH environment is to fix the chartset issue. Error message : “Conversion from UTF8 tochartset failed:Encoding not loaded” )