March 28, 2006 at 10:27 am
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
June 24, 2006 at 10:42 am
Try "jtds" from sourceforge. I'm using it and it have worked like a charm...
TIA.
July 17, 2006 at 4:50 pm
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...
July 19, 2006 at 11:44 pm
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.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply