1

i have written a Gui application in java and all is working fine when connecting to SQL 2008 with the jdbc4 API. however i now need to connect to SQL 2000. i have downgraded to jdbc driver 3 but that is incompatible with java 1.6/7 and requires v 1.5 .

is there any way to get the newer versions of java to connect to old SQL 2000.

user2168435
  • 732
  • 2
  • 10
  • 27
  • If it is a one time thing, try using plain ODBC in order to connect to the old SQL2000. It could also work as a permanent solution, but you would have to pay a small speed penalty. – Costis Aivalis Mar 25 '13 at 07:36

1 Answers1

1

Have a look at this page. JDBC driver 3.0 with JRE 7 compatibility.

http://www.microsoft.com/en-in/download/details.aspx?id=28562

or have a look at jTDS.

http://jtds.sourceforge.net/

Reading these posts may also help.

How to make Java work with SQL Server?

java.sql.SQLException: SQL Server version 8 is not supported by this driver. SQL State = 08S01, Error Code = 0

Community
  • 1
  • 1
Varun
  • 1,014
  • 8
  • 23