, October 12, 2006 11:58 AM
To: 'Tomcat Users List'
Cc: [EMAIL PROTECTED]
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
one of the things that
I tried along the way).
-Original Message-
From: Dan Decker [mailto:[EMAIL PROTECTED]
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 us
Dan:
Try this:
http://support.microsoft.com/kb/313225
Good luck,
Johnny
"Dan Decker" <[EMAIL PROTECTED]>
10/12/2006 12:57 PM
Please respond to
"Tomcat Users List"
To
"'Tomcat Users List'"
cc
<[EMAIL PROTECTED]>
Subject
[***Probable
[mailto:[EMAIL PROTECTED]
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
-2039
-Original Message-
From: Karen Koch [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 12, 2006 8:29 AM
To: 'Tomcat Users List'
Cc: [EMAIL PROTECTED]
Subject: RE: Tomcat using MS SQL2000 Named Instance
Try this:
jdbc:microsoft:sqlserver://KEYSTONE\\GP90:1433;SelectMethod=cu
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.
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:
It may be related to which JDBC driver you're using. I've never had much
success using the Microsoft SQL JDBC driver to connect to a named instance
by using the instance name. I've only been able to connect by finding out
which port the instance is using, and specifying that in the conne
