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:[EMAIL PROTECTED] Sent: Thursday, 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 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:[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 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:[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=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:[EMAIL PROTECTED] Sent: Wednesday, October 11, 2006 6: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]
