I am trying to find the SQL SERVER 2000 JDBC Driver to use in extracting data from SQL SERVER and also carrying out several operation implemented in Java/JSF. Any idea where I could get my hands on the driver? It is no surprise that Microsoft.com /MSDN stopped supporting and hence supplying the necessary driver. Please help and it is greatly appreciated
P.S. Sorry if this is the wrong place to post this :)
EDIT: Solution Working:
So JTDS does it based on link below. The strings I changed to make it work for SQL SERVER 2000 are:
Class.forName("net.sourceforge.jtds.jdbc.Driver");
and
connServer.dbConnect("jdbc:jtds:sqlserver://host;", "username",
"password");
Have you tried http://www.microsoft.com/download/en/details.aspx?id=1511