Return-Path: 
 <users-return-179060-apmail-tomcat-users-archive=tomcat.apache.org@tomcat.apache.org>
Delivered-To: apmail-tomcat-users-archive@www.apache.org
Received: (qmail 6229 invoked from network); 22 Apr 2008 10:51:08 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 22 Apr 2008 10:51:08 -0000
Received: (qmail 10746 invoked by uid 500); 22 Apr 2008 10:50:58 -0000
Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org
Received: (qmail 10131 invoked by uid 500); 22 Apr 2008 10:50:56 -0000
Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@tomcat.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@tomcat.apache.org>
List-Post: <mailto:users@tomcat.apache.org>
List-Id: <users.tomcat.apache.org>
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Delivered-To: mailing list users@tomcat.apache.org
Received: (qmail 10120 invoked by uid 99); 22 Apr 2008 10:50:56 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Apr 2008 03:50:56 -0700
X-ASF-Spam-Status: No, hits=-4.0 required=10.0
	tests=RCVD_IN_DNSWL_MED,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of dns4@cornell.edu designates
 128.253.83.142 as permitted sender)
Received: from [128.253.83.142] (HELO authusersmtp.mail.cornell.edu)
 (128.253.83.142)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Apr 2008 10:50:11 +0000
Received: from [128.253.209.217] (dns4-endeavour.calsnet.cornell.edu
 [128.253.209.217])
	(authenticated bits=0)
	by authusersmtp.mail.cornell.edu (8.13.1/8.12.10) with ESMTP id
 m3MAoOfw029925
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT)
	for <users@tomcat.apache.org>; Tue, 22 Apr 2008 06:50:24 -0400 (EDT)
Message-ID: <480DC2F1.2060306@cornell.edu>
Date: Tue, 22 Apr 2008 06:50:25 -0400
From: David Smith <dns4@cornell.edu>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
To: Tomcat Users List <users@tomcat.apache.org>
Subject: Re: Access SQL Server 2005 and 2000 on same machine
References: 
 <A8D68D059E1FF0458DB29B4C5BBD55360130AD8E@zeus.Herrlich-Ramuschkat.de>
In-Reply-To: 
 <A8D68D059E1FF0458DB29B4C5BBD55360130AD8E@zeus.Herrlich-Ramuschkat.de>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

Ok... how do you get two services on the same port?  Are they bound to 
different IPs?  They can't both respond on the same address and port.

--David

Alexander Diedler wrote:
> 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
>
>   


---------------------------------------------------------------------
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