sql server and tomcat

my webapp reads data from a sql server 2000 db, everithing works fine, but if I try to export in tomcat it doesn't work

I've set with tomcat administration datasource information, downloaded a jdbc driver from msn and copyed jars into webapp lib directory and commo lib directory , but doesn't work

here is the error:

com.sun.rave.web.ui.appbase.ApplicationException: org.apache.jasper.JasperException: java.lang.RuntimeException: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.sun.sql.jdbc.sqlserver.SQLServerDriver'

com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.destroy(ViewHandlerImpl.java: 601)

com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.renderView(ViewHandlerImpl.ja va:316)

com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87 )

com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:221)

com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)

javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)

com.sun.rave.web.ui.util.UploadFilter.doFilter(UploadFilter.java:194)

[1151 byte] By [gio_moria] at [2007-11-27 1:58:18]
# 1
Hi!Did You read following threads: http://forum.java.sun.com/thread.jspa?forumID=881&threadID=5046057 http://forum.java.sun.com/thread.jspa?forumID=881&threadID=5060749Thanks,Roman.
-Grif-a at 2007-7-12 1:34:51 > top of Java-index,Development Tools,Java Tools...
# 2
yes, I did...(the 2nd link is about mysql, I have another application that correctly uses mysql drivers)my problem, I think , is to find the correct jdbc driver, I don't know where to get a working one(microsoft one seems to be not working properly)
gio_moria at 2007-7-12 1:34:51 > top of Java-index,Development Tools,Java Tools...