<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1522" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006>Hi,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006>Im new to this and am trying to set up OpenCms on my
system.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006>I have installed the latest copy of the SDK and
Tomcat.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006>I have already installed on my pc Microsoft SQL
Server.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT size=+0><SPAN class=948520013-04102006><SPAN
class=948520013-04102006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV></SPAN></FONT>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006>But when i go through the OpenCms setup pages i enter
<STRONG>step_4_database_setup.jsp</STRONG> and enter the database details in
here for a MS SQL Server.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006>Enter the usernames and passwords and then the i have
tried the JDBC connection string as :</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006>
<STRONG>jdbc:microsoft:sqlserver://localhost:1433
and</STRONG></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006><STRONG>
jdbc:jtds:sqlserver://localhost:1433</STRONG></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006>but i still get the SAME error message for both
drivers:</SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006><FONT face="Times New Roman" color=#000000
size=3><TD>It was not possible to create a database connection with the given
parameters.<BR>Please check the Exception below. There can be two reasons for
this error: </FONT></DIV>
<DIV dir=ltr align=left>
<UL>
<LI><FONT color=#000000><B>Your database is down</B>, or</FONT>
<LI><B><FONT color=#000000>Your database is not accessible with the given
connection parameters.</FONT></B></LI></UL></DIV><FONT color=#000000>Be also
aware that Alkacon recommends to use the following JDBC drivers for MS SQL
Server:<BR><CODE>[]</CODE></FONT>
<P><FONT color=#000000>Check that the Jdbc drivers are included in your class
path. </FONT></P></TD></SPAN></FONT>
<DIV dir=ltr align=left><FONT size=+0><SPAN
class=948520013-04102006> Error loading JDBC driver:
"net.sourceforge.jtds.jdbc.Driver".<BR>-------------------------------------------<BR>java.lang.ClassNotFoundException:
net.sourceforge.jtds.jdbc.Driver at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1355)
at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1201)
at java.lang.ClassLoader.loadClassInternal(Unknown Source) at
java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown
Source) at org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:266) at
org.apache.jsp.setup.step_005f4a_005fdatabase_005fvalidation_jsp._jspService(step_005f4a_005fdatabase_005fvalidation_jsp.java:70)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunn</SPAN></FONT></DIV></BLOCKQUOTE>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006>CLASSPATH=C:\Program Files\Microsoft SQL Server 2000
Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver
for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver
for
JDBC\lib\msutil.jar;C:\Drivers\jtds-1.2-dist\jtds-1.2.jar</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006>PATH=.........;C:\Progra~1\Java\jdk1.5.0_08\bin;C:\Program
Files\Java\jre1.5.0_08\bin\;C:\Program Files\Microsoft SQL
Server\80\Tools\BINN;C:\Program Files\Microsoft SQL Server 2000 Driver for
JDBC\lib;C:\Drivers\jtds-1.2-dist</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT size=2><SPAN class=948520013-04102006>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006>I know this is up and working - i have written a little
java program which i execute in Eclipse and this connects to the DB and returns
values.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006>(results from Java program :</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT size=+0><SPAN class=948520013-04102006>
<P><FONT face=Arial color=#0000ff size=2><STRONG>Connection
Successful!<BR></STRONG></FONT><FONT face=Arial color=#0000ff
size=2><STRONG>Driver Information<BR></STRONG></FONT><FONT face=Arial
color=#0000ff size=2>Driver Name: SQLServer<BR></FONT><FONT face=Arial
color=#0000ff size=2>Driver Version: 2.2.0029<BR></FONT><FONT face=Arial
color=#0000ff size=2><STRONG>Database Information <BR></STRONG></FONT><FONT
face=Arial color=#0000ff size=2>Database Name: Microsoft SQL
Server<BR></FONT><FONT face=Arial color=#0000ff size=2>Database Version:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) <BR></FONT><FONT face=Arial
color=#0000ff size=2>Aug 6 2000 00:57:48 <BR></FONT><FONT face=Arial><FONT
color=#0000ff><FONT size=2>Copyright (c) 1988-2000 Microsoft
Corporation</FONT></FONT></FONT></P><FONT face=Arial><FONT color=#0000ff><FONT
size=2></FONT></FONT></FONT></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT size=+0><SPAN class=948520013-04102006><FONT
face=Arial><FONT color=#0000ff><FONT size=2><FONT size=2>
<P><STRONG>Connection Successful!<BR>Driver Information</STRONG><BR>Driver Name:
jTDS Type 4 JDBC Driver for MS SQL Server and Sybase<BR>Driver Version:
1.2<BR><STRONG>Database Information <BR></STRONG>Database Name: Microsoft SQL
Server<BR>Database Version: 08.00.0194</FONT><BR><SPAN
class=948520013-04102006>)</SPAN></FONT></FONT></FONT></P></SPAN></FONT></DIV></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006>Any ideas please on why this is happening and what i
can do to solve this?</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006>cheers</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=948520013-04102006>steve</SPAN></FONT></DIV></BODY></HTML>