Tomcat using MS SQL2000 Named Instance

["Peter Ries" <peter.ries (at) Alignent.com>]

Dan,
Have you tried using the server name of Keystone and specifying the
unique port number the named instance is listening on? I believe that
should work. I think that would be something like this:

jdbc:sqlserver://KEYSTONE:####;databaseName=TWO

...where you replace #### with the port number.


~Peter




-----Original Message-----
From: Dan Decker [mailto:Dan (at) Business-Computers.com] 
Sent: Wednesday, October 11, 2006 4:28 PM
To: users (at) tomcat.apache.org
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

---------------------------------------------------------------------
To start a new topic, e-mail: users (at) tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe (at) tomcat.apache.org
For additional commands, e-mail: users-help (at) tomcat.apache.org