一、Web Intelligence通过Universe连接到Oracle 数据库,在制作报表时刷新数据出错: DBDriver failed to load : C:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\dbd_oci.dll WIS 10901
解决方法:1、找到对应的ORACLE的JDBC驱动目录,如D:\oracle\jdbc\lib,其中包括驱动包(ojdbc12jar或ojdbc14.jar),将该目录添加到环境变量PATH
2、找到BO服务器目录下的D:\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\jdbc\jdbc.sbo文件,在其中查找到相应的使用数据库的版本,本例中使用ORACLE 10:
<DataBase Active="Yes" Name="Oracle 10">
<Class JARFile="dbd_jdbc,dbd_oracle">com.businessobjects.connectionserver.java.drivers.jdbc.oracle.OracleDriver</Class>
<JDBCDriver>
<!-- Uncomment and edit the following lines
to define java classes required by JDBC driver
<ClassPath>
<Path>your jar or class files directory</Path>
</ClassPath>
-->
----- <ClassPath>
----- <Path>D:\oracle\jdbc\lib\ojdbc14.jar</Path>
----- </ClassPath>
<Parameter Name="JDBC Class">oracle.jdbc.OracleDriver</Parameter>
<Parameter Name="URL Format">jdbc:oracle:thin:@$DATASOURCE${:$DATABASE$}</Parameter>
</JDBCDriver>
<Parameter Name="Family">Oracle</Parameter>
<Parameter Name="Version">oracle_jdbc.setup</Parameter>
<Parameter Name="Description File">oracle</Parameter>
<Parameter Name="SQL External File">oracle</Parameter>
<Parameter Name="SQL Parameter File">oracle</Parameter>
<Parameter Name="Strategies File">oracle</Parameter>
<Parameter Name="Driver Capabilities">Query,Procedures</Parameter>
<Parameter Name="Extensions">oracle10,oracle,jdbc</Parameter>
<Parameter Name="Escape Character">/</Parameter>
<Parameter Name="Force Execute">Always</Parameter>
<Parameter Name="Catalog Separator">.</Parameter>
</DataBase>
添加上面 ----- <ClassPath>
----- <Path>D:\oracle\jdbc\lib\ojdbc14.jar</Path>
----- </ClassPath>
部分即可!然后重启服务器。