Integration

I have created a working report (MyReport.jsp) in Reports Builder. It has two user parameters (id, P_JDBCPDS). I am using the Microsoft SQL -Server Drivers which are know are not supported by Oracle).

The Report works in Reports Builder. I added Microsoft JDBC jars to the REPORTS_CLASSPATH and created an entry in the jdbcpds.conf file for reports.

How do I get it to work outside of reports builder?

I am setting up 9iAS on a separate machine. What do I need to modify in order to get my JSP to run there?
What does my URL have to look like? Is it the same as the Reports Builder standalone OC4J I am trying to get to work.


//webserver:8888/reports/test/MyReport.jsp?id=1&P_JDBCPDS=<string to connect to MS SQL Server>.

I need the Microsoft JDBC Drivers to be recognized by 9iAS and the OC4J.

Thanks,

Jeanne