Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes Microsoft SQLServer 2000 on Windows Server 2000, what software is needed on the server for JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Microsoft SQLServer 2000 on Windows Server 2000, what software is needed on the server for JDBC" Watch "Microsoft SQLServer 2000 on Windows Server 2000, what software is needed on the server for JDBC" New topic
Author

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

margaret gillon
Ranch Hand

Joined: Nov 12, 2008
Posts: 318
    
    5

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

Joined: Oct 27, 2005
Posts: 19697
    
  20

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.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
margaret gillon
Ranch Hand

Joined: Nov 12, 2008
Posts: 318
    
    5

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

Joined: Nov 12, 2008
Posts: 318
    
    5

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

Joined: Oct 27, 2005
Posts: 19697
    
  20

You're welcome.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Microsoft SQLServer 2000 on Windows Server 2000, what software is needed on the server for JDBC