Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Microsoft SQLServer 2000 on Windows Server 2000, what software is needed on the server for JDBC

 
margaret gillon
Ranch Hand
Posts: 335
6
Linux Tomcat Server Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have an old Windows 2000 server running SQLServer 2000. This is a production server and I cannot upgrade it at this time. We have only connected to it with ODBC or .Net framework. This version of SQLServer does not have Instances. In newer versions of SQLServer JDBC support is created by installing Integration Services but this version of SQLServer does not have Integration Services.

What needs to be installed on the server so it will accept JDBC connecitons?

In netbeans when I try to connect with the JTDS driver and the user account and password we use for ODBC connections the error is:

Cannot establish a connection to jdbc:jtds:sqlserver://192.168.100.16:1433 using net.sourceforge.jtds.jdbc.Driver (net/sourceforge/jtds/jbdc/Driver : Unsupported major.minor version 51.0)

When I run java -version in the command window I get java version "1.2.2"

I have searched the Microsoft Knowledge base and looked for connection software but downloads for Windows 2000 are gone.

I am connectng using servlets. I have already checked into using the ODBC:JDBC bridge per it's documentation it doesn't work with browsers or servlets.

The data is on SQLServer2000 but the web application is running in Tomcat on an Ubuntu 10.4 server.

Thanks for any help...
 
Rob Spoor
Sheriff
Pie
Posts: 20495
54
Chrome Eclipse IDE Java Windows
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
margaret gillon wrote:This version of SQLServer does not have Instances.

Yes it does. It has the default instance (called MSSQLSERVER I believe, and running on port 1433).

What needs to be installed on the server so it will accept JDBC connecitons?

In netbeans when I try to connect with the JTDS driver and the user account and password we use for ODBC connections the error is:

Cannot establish a connection to jdbc:jtds:sqlserver://192.168.100.16:1433 using net.sourceforge.jtds.jdbc.Driver (net/sourceforge/jtds/jbdc/Driver : Unsupported major.minor version 51.0)

When I run java -version in the command window I get java version "1.2.2"

You don't need anything else on the server except it needs to allow remote connections.

The error you're getting is caused by your Java version. The error message indicates the code was compiled for Java 7, so you can't run that with Java 1.2.2. You should really upgrade that. Or you probably have but some software put itself first in the PATH, causing an older JRE to be found first. You can change that by putting the JRE path first on your PATH variable.
 
margaret gillon
Ranch Hand
Posts: 335
6
Linux Tomcat Server Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry for the confusion -- the Java version that I posted in my first message is the version that is running on the SQLServer.

On my desktop I am using SDK 1.6.0_38. If I use the current Microsoft JDBC sqljdbc4.jar the error message is that SQLServer 8 (2000?) is not supported by the driver. If I use the older sqljdbc.jar (version 3) the error message is that SDK 1.6 is not supported by the driver and I should use sqljdbc4.jar.

The error message for JTDS 1.3.0 is as I posted before. So I need to find a verison of JTDS that is compiled in Java 6?

At this point I can't upgrade the Ubuntu server to Java 7 so I need to stay on Java 6.



 
margaret gillon
Ranch Hand
Posts: 335
6
Linux Tomcat Server Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Rob,

The error you're getting is caused by your Java version. The error message indicates the code was compiled for Java 7.....


Thanks to that information I went back to the jTDS site and found the last version that was made for Java 6. It is version 1.2.5. The connection to my SQLServer works with the 1.2.5 version.

Thank you.
 
Rob Spoor
Sheriff
Pie
Posts: 20495
54
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You're welcome.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic