I keep getting this error when I try to retreive data from a sql server 2000 database:
Error. The server encountered an unexpected condition which prevented it from fulfilling the request.
java.lang.NoClassDefFoundError: com/microsoft/jdbc/base/BaseDriver
at java.lang.ClassLoader.defineClass0(Native Method)
..etc..etc
I installed the latest JDBC driver from MS. I am running the JAVA SDK 1.4 .. my class path includes all the jar files from MS..
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar ..etc..etc
Following is the JSP code..
<%@ page import="java.util.*, java.sql.*" %>
<HTML>
<HEAD><TITLE>Tree from Rating's Tabele</TITLE></HEAD>
<BODY text=#000000 bgColor=#ffffff leftMargin=25 topMargin=5>
<B>Test Page</B>
<BR><BR>
<P>
<%
Connection conn = null;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection
("jdbc:microsoft:sqlserver://satellite:1433","ARAdmin","AR#Admin#");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select name, schemaId from arschema ");
%>
<P align=left>
<TABLE width="50%" cellspacing="1" cellpadding="1" border="0" bgcolor="#65B1D9" bordercolorlight="#FFFFFF">
<TR bgcolor="#EEF5FA">
<TH><font face="Verdana" size="2">Name</font></TH>
<TH><font face="Verdana" size="2">Schema ID</font></TH>
</TR>
<%
String TD_Cell_Start = "<TD bgColor=#ffffff><FONT face=Verdana color=#000000 size=-1>";
String TD_Cell_End = "</FONT></TD>";
%>
//Loop through results of query.
while(rs.next())
{
out.println("<TR>");
out.println(TD_Cell_Start + rs.getString("name") + TD_Cell_End);
out.println(TD_Cell_Start + rs2.getString("schemaId") + TD_Cell_End);
out.println("</FONT></TR>");
}
out.println("</TABLE></P><BR>");
%>
<%
//Clean up resources, close the connection.
if(conn != null)
{
conn.close();
}
%>
%>
</CENTER>
</BODY>
</HTML>
I am really new to JSP and I am really confused as to what it is I am doing wrong. Thanks for any help.