[opencms-dev] connect to SQL Server

[Lynn Guy]

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?
 
Windows 2000
SQL Server 2000
SQL Server JDBC Driver from Microsoft
OpenCMS "fat" download 5.0
 
Installed JDBC driver in default directory C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC
 
Placed the 3 files msbase.jar, msutil.jar and mssqlserver.jar in classpath env variable
Copied the darn things to tomcat\webapps\opencms\WEB-INF\lib as well just in case
 
SQL Server already running on box
JDK already on box
 
installed opencms.jar just fine
C:\Tomcat\webapps\opencms\WEB-INF\config\opencms.properties file
-     #resourcebroker=mysql
     resourcebroker=mssql
                                                                                                                            #pool.mssqlonline.driver=com.merant.datadirect.jdbc.sqlserver.SQLServerDriver
      pool.mssql.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
     #pool.mssqlonline.url=jdbc:merant:sqlserver://sqlserver:1433
      pool.mssql.url=jdbc:microsoft:sqlserver://myhostbox:1433
 
brought up the opencms wizard and selected advanced->MS Sql Server ->
  edited the connection url to be same as above
 
get this:
Error while loading driver: [com.microsoft.jdbc.sqlserver.SQLServerDriver, com.microsoft.jdbc.sqlserver.SQLServerDriver, com.microsoft.jdbc.sqlserver.SQLServerDriver]
java.lang.ClassNotFoundException: [com/microsoft/jdbc/sqlserver/SQLServerDriver, com/microsoft/jdbc/sqlserver/SQLServerDriver, com/microsoft/jdbc/sqlserver/SQLServerDriver]

 
Ok, it cant find the driver, how do I tell it where it is?  What am I missing?
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20050112/0d02fffe/attachment.htm>