[opencms-dev] sql server

[Andy Fletcher]

Stefano,

You should download the Microsoft jdbc driver.
http://www.microsoft.com/downloads/details.aspx?FamilyID=4f8f2f01-1ed7-4c4d-8f7b-3d47969e66ae&DisplayLang=en

You can also find the link from
http://www.microsoft.com/sql/downloads/

Make sure the 3 files (msbase.jar, mssqlserver.jar, msutil.jar) are in the classpath. You can just drop them into the opencms/WEB-INF/lib folder to make it easier.

Then you need to edit (I'm assuming you're using Tomcat, but it'll be a similar location for other servlet containers)
TOMCAT_HOME/webapps/opencms/WEB-INF/config/opencms.properties

Find the line that says
# Parameters for the mssql connection-pool
Change the driver lines so that they say

pool.mssql.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver

pool.mssqlonline.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver

pool.mssqlbackup.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver

You can also change the url lines so that they say
jdbc:microsoft:sqlserver://localhost:1433
but I believe you can change this in your browser when you run the setup script.

You might need to restart Tomcat after editing this file, depending on whether you've already started OpenCMS.

HTH,
Andy

-----Original Message-----
From: Stefano Morando [mailto:smorando at dartway.com]
Sent: 30 April 2003 15:53
To: opencms-dev at opencms.org
Subject: [opencms-dev] sql server


Hy, i need to use opencms with sql server where i can find the merant jdbc driver?

thanks