<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: [opencms-dev] sql server</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Yes, this will work better .. </FONT>
<BR><FONT SIZE=2>But only if with SQL-Server 2000. The Microsoft Driver does not work with 7.0. </FONT>
</P>
<P><FONT SIZE=2>Nico</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Andy Fletcher [<A HREF="mailto:AFletcher@fitchlondon.com">mailto:AFletcher@fitchlondon.com</A>] </FONT>
<BR><FONT SIZE=2>Sent: Mittwoch, 30. April 2003 17:18</FONT>
<BR><FONT SIZE=2>To: opencms-dev@opencms.org</FONT>
<BR><FONT SIZE=2>Subject: RE: [opencms-dev] sql server</FONT>
</P>
<P><FONT SIZE=2>Stefano,</FONT>
</P>
<P><FONT SIZE=2>You should download the Microsoft jdbc driver.</FONT>
<BR><FONT SIZE=2><A HREF="http://www.microsoft.com/downloads/details.aspx?FamilyID=4f8f2f01-1ed7-4c4d-8f7b-3d47969e66ae&DisplayLang=en" TARGET="_blank">http://www.microsoft.com/downloads/details.aspx?FamilyID=4f8f2f01-1ed7-4c4d-8f7b-3d47969e66ae&DisplayLang=en</A></FONT>
</P>
<P><FONT SIZE=2>You can also find the link from</FONT>
<BR><FONT SIZE=2><A HREF="http://www.microsoft.com/sql/downloads/" TARGET="_blank">http://www.microsoft.com/sql/downloads/</A></FONT>
</P>
<P><FONT SIZE=2>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.</FONT></P>
<P><FONT SIZE=2>Then you need to edit (I'm assuming you're using Tomcat, but it'll be a similar location for other servlet containers)</FONT>
<BR><FONT SIZE=2>TOMCAT_HOME/webapps/opencms/WEB-INF/config/opencms.properties</FONT>
</P>
<P><FONT SIZE=2>Find the line that says</FONT>
<BR><FONT SIZE=2># Parameters for the mssql connection-pool</FONT>
<BR><FONT SIZE=2>Change the driver lines so that they say</FONT>
</P>
<P><FONT SIZE=2>pool.mssql.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver</FONT>
</P>
<P><FONT SIZE=2>pool.mssqlonline.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver</FONT>
</P>
<P><FONT SIZE=2>pool.mssqlbackup.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver</FONT>
</P>
<P><FONT SIZE=2>You can also change the url lines so that they say</FONT>
<BR><FONT SIZE=2>jdbc:microsoft:sqlserver://localhost:1433</FONT>
<BR><FONT SIZE=2>but I believe you can change this in your browser when you run the setup script.</FONT>
</P>
<P><FONT SIZE=2>You might need to restart Tomcat after editing this file, depending on whether you've already started OpenCMS.</FONT>
</P>
<P><FONT SIZE=2>HTH,</FONT>
<BR><FONT SIZE=2>Andy</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Stefano Morando [<A HREF="mailto:smorando@dartway.com">mailto:smorando@dartway.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: 30 April 2003 15:53</FONT>
<BR><FONT SIZE=2>To: opencms-dev@opencms.org</FONT>
<BR><FONT SIZE=2>Subject: [opencms-dev] sql server</FONT>
</P>
<BR>
<P><FONT SIZE=2>Hy, i need to use opencms with sql server where i can find the merant jdbc driver?</FONT>
</P>
<P><FONT SIZE=2>thanks</FONT>
<BR><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>This mail is send to you from the opencms-dev mailing list</FONT>
<BR><FONT SIZE=2>To change your list options, or to unsubscribe from the list, please visit</FONT>
<BR><FONT SIZE=2><A HREF="http://mail.opencms.org/mailman/listinfo/opencms-dev" TARGET="_blank">http://mail.opencms.org/mailman/listinfo/opencms-dev</A></FONT>
</P>
</BODY>
</HTML>