Tomcat using MS SQL2000 Named Instance

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

Karen - Thanks for your help.  The double backslash is now working.  I
had to upgrade the SQL 2000 named instance to SP4.
 
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 11:58 AM
To: 'Tomcat Users List'
Cc: Dan (at) business-computers.com
Subject: RE: Tomcat using MS SQL2000 Named Instance

Odd -- works for me using the double backslash just fine... 

You do seem to missing "microsoft:" in the beginning of the connection
string, not sure if that's a typo or not.  Mine began
"jdbc:microsoft:sqlserver:" etc.

Did not have to mess with the port numbers (this was one of the things
that
I tried along the way).

-----Original Message-----
From: Dan Decker [mailto:Dan (at) Business-Computers.com] 
Sent: Thursday, October 12, 2006 11:50 AM
To: 'Karen Koch'; 'Tomcat Users List'
Subject: RE: Tomcat using MS SQL2000 Named Instance

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


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