Tomcat using MS SQL2000 Named Instance

["Dan Decker" <Dan (at) Business-Computers.com>]

Peter - Thanks.  I want to try it.  I do not know how to find the port
number the named instance is listening on.  Do you know how to find what
its number is?
 
Dan Decker
Microsoft Dynamics GP Developer
www.Business-Computers.com 
(303)499-2039
 

-----Original Message-----
From: Peter Ries [mailto:peter.ries (at) Alignent.com] 
Sent: Thursday, October 12, 2006 9:44 AM
To: users (at) tomcat.apache.org
Subject: RE: Tomcat using MS SQL2000 Named Instance

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



---------------------------------------------------------------------
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