【BI Publisher】SQL Server JDBC設定－Peter Lin-被動投資紀錄

The JDBC driver for your selected database must be available to BI Publisher. If you are using an Oracle database or one of the DataDirect drivers provided by BI Publisher, then the drivers will be installed in the correct location and there is no further setup required.

For all other database and driver selections, you have the following options to make the native JDBC drivers available to BI Publisher:

(Recommended) For OC4J deployments, you can copy the native driver JAR files to the following location: <oc4j_home>/j2ee/home/applib (將sqljdbc.jar與sqljdbc4.jar一起丟進去)
(Recommended) Configure your Web application server to register the JDBC drivers. See your application server documentation for information on registering third-party JDBC drivers.
Copy the native driver JAR files to the following location: xmlpserver/WEB-INF/lib

If you choose this option, you will be required to repeat this step each time you redeploy the BI Publisher server for an upgrade or other reason.
Add the JDBC drivers to your application server's Java CLASSPATH.

最後，記得要重啟BI Publisher服務