tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Diedler" <ADied...@tecracer.de>
Subject RE: Access SQL Server 2005 and 2000 on same machine
Date Tue, 22 Apr 2008 10:54:21 GMT
No, the Services on the same Port and same IP.
SQL Server allow up to 99 Instances on one machine. Only the Instance Name is important to
identify the correct Instance. But how I can Access a SQL Server by Instance with Tomcat?
 
Alex
 

________________________________

From: David Smith [mailto:dns4@cornell.edu]
Sent: Tue 4/22/2008 12:50 PM
To: Tomcat Users List
Subject: Re: Access SQL Server 2005 and 2000 on same machine



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





Mime
View raw message