Tomcat using MS SQL2000 Named Instance
- From: johnny (at) dancik.com
- Date: Thu, 12 Oct 2006 13:44:56 -0400
Dan:
Try this:
http://support.microsoft.com/kb/313225
Good luck,
Johnny
"Dan Decker" <Dan (at) Business-Computers.com>
10/12/2006 12:57 PM
Please respond to
"Tomcat Users List" <users (at) tomcat.apache.org>
To
"'Tomcat Users List'" <users (at) tomcat.apache.org>
cc
<peter.ries (at) 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 (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