Tomcat using MS SQL2000 Named Instance

[johnny (at) dancik.com]

Dan:

It may be related to which JDBC driver you're using.  I've never had much 
success using the Microsoft SQL JDBC driver to connect to a named instance 
by using the instance name.  I've only been able to connect by finding out 
which port the instance is using, and specifying that in the connection 
URL.

I have had success using the JTDS driver - it's an open source, pure Java 
(type 4) JDBC 3.0 driver for Microsoft SQL Server (and Sybase), which has 
worked just fine when I use the instance name in the URL.  You can find it 
at:

http://jtds.sourceforge.net

Good luck!

Thanks,
Johnny





"Dan Decker" <Dan (at) Business-Computers.com> 
10/11/2006 07:27 PM
Please respond to
"Tomcat Users List" <users (at) tomcat.apache.org>


To
<users (at) tomcat.apache.org>
cc

Subject
Tomcat using MS SQL2000 Named Instance






I am trying to get Tomcat to connect to a MS SQL2000 Named instance
rather than the default instance.
Using the following it connects to the database TWO on the default
server KEYSTONE with no problems.
 
jdbc:sqlserver://KEYSTONE;databaseName=TWO
 
When I try to access the MS SQL2000 named instance KEYSTONE\GP90 it
still connects to the default
 
jdbc:sqlserver://KEYSTONE;instanceName=GP90;databaseName=TWO
 
 
Dan Decker