tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Diedler" <ADied...@tecracer.de>
Subject Access SQL Server 2005 and 2000 on same machine
Date Tue, 22 Apr 2008 10:39:20 GMT
Hello,
We have installed a SQL 2000 and SQL 2005 Server Express on the same server and same Port
(1433)
Now we have no chance to tell the Tomcat in Conf Directory, which SQL Server Version and Database
has to be choosen for the Application.
I know, that there are Instance Names like 127.0.0.1\sqlexpress or 127.0.0.1\default but how
use it in Tomcat 6.0.14 on Windows 2003 Server?
Here a Example from /conf/Catalina/localhost/root.xml
 
<Resource name="jdbc/jTDS"
               auth="Container"
               type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
username="sa"
password="xxx"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"
driverClassName="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://testsqlserver:1433/tecracer4;charset=Cp1252"
/> 
 
 

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message