<DIV>I've searched the archives and I've gotten this driver to work last week with JDev/ADF but no joy with OpenCMS so can anybody help?</DIV>
<DIV> </DIV>
<DIV>Windows 2000</DIV>
<DIV>SQL Server 2000</DIV>
<DIV>SQL Server JDBC Driver from Microsoft</DIV>
<DIV>OpenCMS "fat" download 5.0</DIV>
<DIV> </DIV>
<DIV>Installed JDBC driver in default directory C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC</DIV>
<DIV> </DIV>
<DIV>Placed the 3 files msbase.jar, msutil.jar and mssqlserver.jar in classpath env variable</DIV>
<DIV>Copied the darn things to tomcat\webapps\opencms\WEB-INF\lib as well just in case</DIV>
<DIV> </DIV>
<DIV>SQL Server already running on box</DIV>
<DIV>JDK already on box</DIV>
<DIV> </DIV>
<DIV>installed opencms.jar just fine</DIV>
<DIV>C:\Tomcat\webapps\opencms\WEB-INF\config\opencms.properties file</DIV>
<DIV>-
<DIV> #resourcebroker=mysql<BR> resourcebroker=mssql</DIV> #pool.mssqlonline.driver=com.merant.datadirect.jdbc.sqlserver.SQLServerDriver<BR>
pool.mssql.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver<BR> #pool.mssqlonline.url=jdbc:merant:sqlserver://sqlserver:1433<BR> pool.mssql.url=jdbc:microsoft:sqlserver://myhostbox:1433</DIV>
<DIV> </DIV>
<DIV>brought up the opencms wizard and selected advanced->MS Sql Server -></DIV>
<DIV> edited the connection url to be same as above</DIV>
<DIV> </DIV>
<DIV>get this:</DIV>
<DIV>Error while loading driver: [com.microsoft.jdbc.sqlserver.SQLServerDriver, com.microsoft.jdbc.sqlserver.SQLServerDriver, com.microsoft.jdbc.sqlserver.SQLServerDriver]<BR>java.lang.ClassNotFoundException: [com/microsoft/jdbc/sqlserver/SQLServerDriver, com/microsoft/jdbc/sqlserver/SQLServerDriver, com/microsoft/jdbc/sqlserver/SQLServerDriver]<BR></DIV>
<DIV> </DIV>
<DIV>Ok, it cant find the driver, how do I tell it where it is? What am I missing?</DIV>
<DIV> </DIV>
<DIV> </DIV>