tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dan Decker" <...@Business-Computers.com>
Subject RE: Tomcat using MS SQL2000 Named Instance
Date Fri, 13 Oct 2006 18:48:11 GMT
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@sbcglobal.net] 
Sent: Thursday, October 12, 2006 11:58 AM
To: 'Tomcat Users List'
Cc: Dan@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@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@sbcglobal.net] 
Sent: Thursday, October 12, 2006 8:29 AM
To: 'Tomcat Users List'
Cc: Dan@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@Business-Computers.com] 
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: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message