I am trying to find a SQL Server SQL Server driver to use when retrieving data from SQL SERVER, and also perform several operations implemented in Java / JSF. Any idea where I can take the driver? It is not surprising that Microsoft.com/MSDN ceased to support and, therefore, supplied the necessary driver. Please help and we are very grateful
PS Sorry if this is not the place to post it :)
EDIT: Solution:
So, JTDS does this based on the link below. The lines that I changed to make it work for SQL SERVER 2000:
Class.forName("net.sourceforge.jtds.jdbc.Driver");
and
connServer.dbConnect("jdbc:jtds:sqlserver://host;", "username", "password");
source share