Tomcat using MS SQL2000 Named Instance

["Karen Koch" <kmkoch (at) sbcglobal.net>]

Try this:

jdbc:microsoft:sqlserver://KEYSTONE\\GP90:1433;SelectMethod=cursor;DatabaseN
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