bo服务器idt和bw链接修改,【SAP_BO】关于Universe和IDT链接数据库的JDBC配置

情况一：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文件打开，添加类路径：

C:\\XJL\\Install

Software\\Drivers\\sqljdbc.jar

$JDBCCLASS$

$DATASOURCE$

10

补充：

当时解决的chartset issue: Conversion

from UTF8 tochartset

failed:Encoding not loaded

2.Also you need to add "C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects

Enterprise XI 4.0\win64_x64" to the PATH environment variables on

the SAP Business Objects Enterprise machine

(the purpose of adding PATH environment is to fix the chartset issue. Error message : “Conversion from UTF8 to chartset failed:Encoding not loaded” )