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" <users@tomcat.apache.org> To "'Tomcat Users List'" <users@tomcat.apache.org> cc <[EMAIL PROTECTED]> 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:[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. 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:[EMAIL PROTECTED] Sent: Wednesday, October 11, 2006 4:28 PM To: users@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@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
