0

I have Java code that, for the time being, has to be run in Java 1.4 and is using the SQL Server 2000 Driver for JDBC. One of the MS SQL Servers we work with is being upgraded from SQL Server 2000 to SQL Server 2008. The SQL 2000 JDBC driver does not work with 2008, as I've found out in practice and from reading online.

All (?) newer versions of JDBC that support SQL 2008 (2, 3 & 4) require Java 5 or Java 6.

How can I connect to MS SQL Server 2008 from Java 1.4?

Edit It looks like SQL Server 2005 JDBC Driver 1.2 will allow me to connect to SQL 2008 from Java 1.4, but that the download isn't available anymore??

Peter
  • 9,643
  • 6
  • 61
  • 108
  • 1
    Why do you have to use Java 1.4? Why can't you update to a version that will work with the newer JDBC drivers? – Nexion Dec 17 '12 at 21:10
  • @Nexion - My code is run inside of IBM Maximo 6, which requires Java 1.4. – Peter Dec 17 '12 at 21:18

1 Answers1

2

You could use a third party driver like jdts: http://jtds.sourceforge.net. The 1.2.x versions run on versions 1.3 to 6. Here's a good link which describes how to use it: Help me create a jTDS connection string.

Community
  • 1
  • 1
yakshaver
  • 2,472
  • 1
  • 18
  • 21
  • If I'm reading their page correctly, I would make sure the jar is accessible in my classpath and then modify my existing static variables that store the MSSQL JDBC settings ("com.microsoft.jdbc.sqlserver.SQLServerDriver" and "jdbc:microsoft:sqlserver://"). Sound about right? – Peter Dec 17 '12 at 21:25
  • Yes. I added a link describing in detail how to use it above. – yakshaver Dec 17 '12 at 22:06