In addition to setting ClassPath in SQL Server 2k for JDBC HTML HLP, you also need to copy 3 JAR files in Microsoft SQL Server 2000 Driver for JDBC / LIB / Lib / in Tomcat / Common / Lib /, otherwise the following may occur Error message:
TYPE EXCEPTION Report
Message
Description The Server Encountered An Internal Error () That Prevented It from fulventing this request.
EXCEPTION
Javax.Servlet.ServletException: com.microsoft.jdbc.sqlserver.sqlserdriver
Org.apache.jasper.Runtime.pageContextImpl.doHandlePageException (pageContextimpl.java: 862)
Org.apache.jasper.Runtime.pageContextImpl.HandlepageException (PageContextImpl.java: 795)
Org.apache.jsp.testdata_jsp._jspservice (TestData_jsp.java: 79)
Org.apache.jasper.Runtime.httpjspBase.Service (httpjspbase.java: 133)
Javax.servlet.http.httpservlet.service (httpservlet.java: 856)
Org.apache.jasper.Servlet.jspservletWrapper.Service (jspservletwrapper.java: 311)
Org.apache.jasper.servlet.jspservlet.ServiceJspfile (jspservlet.java: 301)
Org.apache.jasper.servlet.jspservlet.Service (jspservlet.java: 248)
Javax.servlet.http.httpservlet.service (httpservlet.java: 856)
Root Cause
Java.lang.classNotFoundException: com.microsoft.jdbc.sqlserver.sqlserdriver
Org.apache.catalina.Loader.WebAppclassLoader.loadClass (WebAppclassLoader.java: 1365)
Org.apache.catalina.Loader.WebAppclassLoader.LoadClass (WebAppclassLoader.java: 1212)
Org.apache.jasper.Servlet.jasperLoader.LoadClass (JasperLoader.java: 184)
Org.apache.jasper.servlet.jasperloader.LoadClass (JasperLoader.java: 110)
Java.lang.classloader.LoadClassinternal (ClassLoader.java:302)
Java.lang.class.Forname0 (Native Method)
Java.lang.class.Forname (Class.java:141)
Org.apache.jsp.testData_jsp._jspservice (testdata_jsp.java: 48)
Org.apache.jasper.Runtime.httpjspBase.Service (httpjspbase.java: 133)
Javax.Servlet.http.httpservlet.service (httpservlet.java: 856) org.apache.jasper.servlet.jspservletWrapper.Service (jspservletwrapper.java: 311)
Org.apache.jasper.servlet.jspservlet.ServiceJspfile (jspservlet.java: 301)
Org.apache.jasper.servlet.jspservlet.Service (jspservlet.java: 248)
Javax.servlet.http.httpservlet.service (httpservlet.java: 856)
Note The Full Stack TRACE OF THE ROOT Cause IS Available In The Tomcat Logs.