JSP connection all kinds of databases Daquan SQLServer2000 JDBC driver Complete installation and testing?

js|server|sqlserver| Data | Database JSP connection All kinds of databases Daquan SQLServer2000 JDBC driver Complete installation and test instructions

SQLServer2000 JDBC Driver Complete installation and test instructions (reprint)

First, download the SQLSERVER2000 JDBC driver.
This driver is available at the Microsoft site:
Window operating System
Http://www.uncj.com/upload/files/ms_jdbc_setup.exe
Http://download.microsoft.com/download/SQLSVR2000/jdbc/2000/NT45XP/EN-US/setup.exe

Unix Operating System Mssqlserver.tar
Http://download.microsoft.com/download/SQLSVR2000/jdbc/2000/UNIX/EN-US/mssqlserver.tar

Ii. installation of JDBC

Execute the ms_jdbc_setup.exe executable file, all you need to do is click Next, until the Finish button appears, complete the installation.

Note:
(1) Ms_jdbc_setup The default installation path is:
C:Program FilesMicrosoft SQL Server Driver for JDBC

(2) This edition (version 2.2.0022) only supports
Microsoft SQL Server Driver for JDBC
(3) Installation directory Lib three jar files that is the JDBC drive core we want
Msbase.jar
Mssqlserver.jar
Msutil.jar

Third, add the three jar files of the above (3) to the environment variable
Classpath
C:Program FilesMicrosoft SQL Server Driver for Jdbclibmsbase.jar;
C:Program FilesMicrosoft SQL Server Driver for Jdbclibmssqlserver.jar;
C:Program FilesMicrosoft SQL Server Driver for Jdbclibmsutil.jar

Note: I recommend that you copy the above three files to the Lib or class directory where your JVM machine resides. At this point I am copying it to the Jre/lib/ext under my JVM directory.