..custom report/parameter pages in LBI 9..

We are currently upgrading our LRS environment from LRS to LBI 9. Our LRS environment was on Windows 2000 with Tomcat as the HTTPd. Our LBI environment is on Windows 2003 with WebSphere as the HTTPd. In LRS we used custom report pages to provide a user with parameters that are then fed into Crystal reports upon run-time. The custom page was a .JSP that would call a SQL Server DB residing on the same box as LRS to query for parameters. The user would then click submit, and the report ran with the parameters that the user specified.

Enter LBI 9 - we cannot get the same process to work. We are unsure whether we are not making the correct call to the SQL Server, or whether it should be different, since we are now on WebSphere as opposed to Tomcat. Below is a snipet of a sample .JSP that works on LRS, but not on LBI 9:

<%@ page import="java.sql.Connection,
java.sql.DriverManager,
java.sql.Statement"%>
<%
String strScreenHeader="Labor Distribution by Pay Period";

//*******************************************
//DEFINE ONCE FOR EACH SERVER CONNECTION TYPE
//*******************************************
//For SQL Server
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection cnn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost;User=report;Password=123456;DatabaseName=LawsonVTS");

Statement stmt = cnn.createStatement();
//*************************************

//**********************************************************************
//DEFINE A Separate one for each Dynamic Value if the come from different Queries.
//**********************************************************************
java.sql.ResultSet rs1;
String SQLQuery1 = "Select Company as Filter from VTS_RptDist where UserID = '" + request.getParameter("fsuserid") + "' and Suite = 'FN' and Role = 'ALL'";

By the way, the purpose of us needing this, is that our user-level access to companies/acct-units is controlled by this parameter page. It determines the username upon run-time, and then queries only the companies/acct-units that the user is authorized to view.

In LBI 9, after publishing the report we used the Events section to define a Parameter Selection event. We entered the web path of where the JSP resides, and saved.

Upon running the report, instead of getting the parameter page, we get:

Error 500: com.microsoft.jdbc.sqlserver.SQLServerDriver

Has anyone come across this, or have any ideas as to how we can get this working? Thanks for looking!