[opencms-dev] sql server

[Nico Krause]

Yes, this will work better .. 
But only if with SQL-Server 2000. The Microsoft Driver does not work with
7.0. 

Nico

-----Original Message-----
From: Andy Fletcher [mailto:AFletcher at fitchlondon.com] 
Sent: Mittwoch, 30. April 2003 17:18
To: opencms-dev at opencms.org
Subject: RE: [opencms-dev] sql server

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
_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20030430/c258332f/attachment.htm>