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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]