Tomcat using MS SQL2000 Named Instance

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

It does not work when I use \\GP90.

I tried the following and it works on the default instance.
jdbc:sqlserver://KEYSTONE:1433;databaseName=TWO


To determine if it is using the port #, I changed the port to 1430 and
it no longer worked for the default instance.  This tells me it is
looking at the port #.  Does the 2nd SQL2000 instance use a different
port#?  If so could I change the port # to the one the 2nd instance uses
and would it work?  How do you determine what port the 2nd instance is
using?  Thanks
 
Dan Decker
Microsoft Dynamics GP Developer
www.Business-Computers.com 
(303)499-2039
 

-----Original Message-----
From: Karen Koch [mailto:kmkoch (at) sbcglobal.net] 
Sent: Thursday, October 12, 2006 8:29 AM
To: 'Tomcat Users List'
Cc: Dan (at) business-computers.com
Subject: RE: Tomcat using MS SQL2000 Named Instance

Try this:

jdbc:microsoft:sqlserver://KEYSTONE\\GP90:1433;SelectMethod=cursor;Datab
aseN
ame=TWO

Note the double backslash before the instance name.

Struggled with this briefly myself recently -- the answer was in the PDF
help file for the JDBC driver.

Karen Koch

-----Original Message-----
From: Dan Decker [mailto:Dan (at) Business-Computers.com] 
Sent: Wednesday, October 11, 2006 6: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