You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Alexander Diedler <AD...@tecracer.de> on 2008/04/22 12:39:20 UTC
Access SQL Server 2005 and 2000 on same machine
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
Re: Access SQL Server 2005 and 2000 on same machine
Posted by Etienne Giraudy <eg...@gmail.com>.
Probably the answer is just in jTDS FAQ in http://jtds.sourceforge.net/faq.html
Check the answer to "What is the URL format used by jTDS?"
My .2
E-
On 4/22/08, Alexander Diedler <AD...@tecracer.de> wrote:
> 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
>
>
>
>
>
> ---------------------------------------------------------------------
> 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
RE: Access SQL Server 2005 and 2000 on same machine
Posted by Alexander Diedler <AD...@tecracer.de>.
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
Re: Access SQL Server 2005 and 2000 on same machine
Posted by David Smith <dn...@cornell.edu>.
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