[opencms-dev] Install on MS SQL Server and /opencms Prefix

[Cory Syvenky]

Fellow CMS'ers,

This is a two-part issue.

(1) I've successfully installed OpenCms 5.0.1 (FAT) on Windows 2000 Server using MySQL with very little problems. However, I need to install it on MS SQL Server (we are trying to mirror our production server). The problem now is I can't get the OCSETUP wizard to use the Microsoft JDBC drivers. There has been a flurry of activity in the mail archies but nobody mentions how they got thru the install wizard successfully. I have downloaded and installed version 2.2.0022 from Microsoft, I have copied the 3 .jar files in my %CATALINA_HOME%/webapps/opencms/WEB-INF/lib directory. When I run the OCSETUP wizard and enter the details for our SQL Server, I'm left with the following error messages:

"Error while loading driver: com.merant.datadirect.jdbc.sqlserver.SQLServerDriver
java.lang.ClassNotFoundExceotion: com.merant.datadirect.jdbc.sqlserver.SQLServerDriver"

This error is confusing seeing as I am using: "jdbc:microsoft:sqlserver://IPAddr:1433" as the connection string.

Any windows users out there know the way out of this hole?

(2) I was doing more digging in the mail archives to see if anybody has had success removing the /opencms prefix from their Windows/IIS installation. I know there is some Apache documentation using mod_proxy etc., this however doesn't apply to us. I did stroll across some postings regarding a PDF document by Bhavna Petel, the process seems to be straight forward, but there are other postings where users have claimed this does not work. Does it?

Thanks,
cS