tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From joh...@dancik.com
Subject Re: [***Probable Spam***] RE: Tomcat using MS SQL2000 Named Instance
Date Thu, 12 Oct 2006 17:44:56 GMT
Dan:

Try this:

http://support.microsoft.com/kb/313225

Good luck,
Johnny





"Dan Decker" <Dan@Business-Computers.com> 
10/12/2006 12:57 PM
Please respond to
"Tomcat Users List" <users@tomcat.apache.org>


To
"'Tomcat Users List'" <users@tomcat.apache.org>
cc
<peter.ries@Alignent.com>
Subject
[***Probable Spam***] RE: Tomcat using MS SQL2000 Named Instance






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@Alignent.com] 
Sent: Thursday, October 12, 2006 9:44 AM
To: users@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@Business-Computers.com] 
Sent: Wednesday, October 11, 2006 4:28 PM
To: users@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@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



Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message