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

Source: Internet
Author: User
Tags mssqlserver
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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.