Installation and configuration of Microsoft SQL Server and SQL Server 2000 driver for JDBC

1. Microsoft SQL Server
At http://www.microsoft.com/ SQL /default.mspxand
HTTP:
// Www.microsoft.com/china/ SQL /default.asp: Microsoft SQL
Server Information. We recommend that you install Microsoft SQL Enterprise Manager Microsoft Corporation:
8.0 and Microsoft SQL Server SP3. In addition, you can

Http://www.microsoft.com/downloads/details.aspx?

Displaylang = ZH-CN & familyid = 90dcd52c-0488-4e46-afbf-ace5108fa3 download and obtain
SP3.
Installation is not described in detail.
2. SQL Server 2000 driver for JDBC
1) download. You can
HTTP:
// Www.microsoft.com/downloads/details.aspx? Familyid = 07287b11-0502-461a-b138
-2aa54bfdc03a & displaylang = EN download the latest version of SQL Server 2000 driver for JDBC
SP3.
2) install. Make sure that you have installed j2sdk or JDK. If not, install j2sdk first. If the installation and configuration are complete, continue with the following steps.
Follow the prompts to install. Recommended installation directory: C: \ Program Files \ Microsoft SQL Server 2000 driver for JDBC (here the C disk refers to the system disk ).
3) environment variable configuration.
(1) Confirm that the Windows account is an administrator-level account.
(2) Right-click [my computer]-select [properties] in the pop-up menu-select [advanced] in the pop-up dialog box-click [environment variables]
(3) The following operations are performed in [system variables]. If the system variables already have the same variable name and contain the same variable value, skip this step; if the system variable already has the same variable name but does not contain the same variable value, add the variable value (separated by ";"). If the system variable does not have the same variable name, perform the following operations to [Create] The variable name and assign the variable value.
[New] variable name: jdbc_home variable value: C: \ Program Files \ Microsoft SQL Server 2000 driver for JDBC
[New] variable name: classpath variable value:
% Jdbc_home % \ Lib \ msbase. jar; % jdbc_home % \ Lib \ MSSQLServer. jar; % jdbc_home % \ Lib \ msutil. jar;
Restart the computer and complete the JDBC configuration.
Supplement:
Create
% Jdbc_home % \ Lib \ msbase. jar; % jdbc_home % \ Lib \ MSSQLServer. jar; % jdbc_home %
\ Lib \ msutil. jar to the % java_home % \ JRE \ Lib \ ext directory and % atat_home % \ common \
Lib directory.