Accessing SQL-Server 2005 with JDBC type 4 ... and JDK 1.3

• Christian Theriault

  SSC Enthusiast

  Points: 111

  More actions

  March 28, 2006 at 10:27 am

  #365720

  Hi,

  I want to upgrade our database servers from Sql-server 2000 to Sql-Server 2005, but a compatibility detail is bugging me:

  I'm somehow unfortunate, because I must cope with legacy Java 1.3 applications accessing the databases. These application (web) are working fine with MS-JDBC driver on Sql-Server 2000, however it seems Microsoft JDBC for Sql-Server 2005 requires recent version of JRE.

  I had a lot of problems in the past with Merrant's drivers, especially with complex queries having inner queries, but as soon as I started using Microsoft's (even with the early beta versions) everything started working properly.

  I cannot easily upgrade the Java package; I would rather rewrite in .Net! I would appreciate a honest recommendation of a JDBC driver type 4 compatible with java 1.3 and MS-Sql-Server 2005.

  Thanks,

  christian

• March 31, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Nilo Paim

  Newbie

  Points: 7

  More actions

  June 24, 2006 at 10:42 am

  #645723

  Try "jtds" from sourceforge. I'm using it and it have worked like a charm...

  TIA.

• Christian Theriault

  SSC Enthusiast

  Points: 111

  More actions

  July 17, 2006 at 4:50 pm

  #649701

  It turned out that, SQL-server-2005 was still compatible with the old JDBC Driver. Everything still working fine...

  Another solution is to buy the "official" driver from Datadirect for JDK 1.3 with Sql-server-2005. It is just an upgrade of the Microsoft driver which is, in fact, developped by DataDirect. ==> same driver, but just a different version, same bug and limitation to be expected as well.

  Sorry I should have posted myself the answer sooner to share it with the others...

• Shanavaz

  Newbie

  Points: 7

  More actions

  July 19, 2006 at 11:44 pm

  #650307

  Hi Christian,

  I am looking for a Type4 driver for JDK1.5 for SQL Server 2000. Can you please help me out? I downloaded Microsoft Driver, but I am not able to connect. Can you pls provide only the statements used to connect it? Also where should I put the jar files?

  Thanks very much

  Shan.