We are pleased to announce availability of the Microsoft JDBC 4.2 Driver for SQL Server! The updated driver provides robust data access to Microsoft SQL Server and Microsoft Azure SQL Database for Java-based applications. Download the Microsoft JDBC Driver 6.0 for SQL Server, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Editions. Download the Microsoft JDBC Driver 6.4 for SQL Server, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Editions. Baixe o Microsoft JDBC Driver 6.0 para SQL Server. 6.0 para SQL Server from Official Microsoft Download. SQL Server 2014 • Microsoft SQL Server 2012.
- Overview of the JDBC Driver.; 2 minutes to read Contributors. In this article. Download JDBC Driver. The Microsoft JDBC Driver for SQL Server is a Type 4 Java Database Connectivity (JDBC) 4.2 compliant driver that provides robust data access to SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2.
- Hello: I am running SQL Server 2014 with the JDBC driver I downloaded. Server Name: ADMINIB-9N5D719 Instance Name: VENKAT Database name: IPM I have configured the.
Baixe o Microsoft JDBC Driver 6.0 para SQL Server. 6.0 para SQL Server from Official Microsoft Download. SQL Server 2014 • Microsoft SQL Server 2012.
-->This page contains the support matrix and support lifecycle policy for the Microsoft JDBC Driver for SQL Server.
Microsoft JDBC Driver support lifecycle matrix and policy
The Microsoft Support Lifecycle (MSL) policy provides transparent, predictable information regarding the support lifecycle of Microsoft products. JDBC driver versions 3.0, 4.x, 6.x, and 7.x have five-year Mainstream support from the driver release date. Mainstream support is defined on the Microsoft support lifecycle website.
Extended and custom support options are not available for the Microsoft JDBC Driver.
The following Microsoft JDBC Drivers are supported, until the indicated End of Support date.
| Driver Name | Driver Package Version | Applicable JAR(s) | End of Mainstream Support |
|---|---|---|---|
| Microsoft JDBC Driver 7.4 for SQL Server | 7.4 | mssql-jdbc-7.4.1.jre12.jar mssql-jdbc-7.4.1.jre11.jar mssql-jdbc-7.4.1.jre8.jar | August 2, 2024 |
| Microsoft JDBC Driver 7.2 for SQL Server | 7.2 | mssql-jdbc-7.2.2.jre11.jar mssql-jdbc-7.2.2.jre8.jar | April 16, 2024 |
| Microsoft JDBC Driver 7.0 for SQL Server | 7.0 | mssql-jdbc-7.0.0.jre10.jar mssql-jdbc-7.0.0.jre8.jar | July 31, 2023 |
| Microsoft JDBC Driver 6.4 for SQL Server | 6.4 | mssql-jdbc-6.4.0.jre9.jar mssql-jdbc-6.4.0.jre8.jar mssql-jdbc-6.4.0.jre7.jar | February 27, 2023 |
| Microsoft JDBC Driver 6.2 for SQL Server | 6.2 | mssql-jdbc-6.2.2.jre8.jar mssql-jdbc-6.2.2.jre7.jar | June 30, 2022 |
| Microsoft JDBC Driver 6.0 for SQL Server | 6.0 | sqljdbc42.jar sqljdbc41.jar | July 14, 2021 |
| Microsoft JDBC Driver 4.2 for SQL Server | 4.2 | sqljdbc42.jar sqljdbc41.jar | August 24, 2020 |
| Microsoft JDBC Driver 4.1 for SQL Server | 4.1 | sqljdbc41.jar | December 12, 2019 |
The following Microsoft JDBC Drivers are no longer supported.
| Driver Name | Driver Package Version | End of Mainstream Support |
|---|---|---|
| Microsoft JDBC Driver 4.0 for SQL Server | 4.0 | March 6, 2017 |
| Microsoft SQL Server JDBC Driver 3.0 | 3.0 | April 23, 2015 |
| Microsoft SQL Server JDBC Driver 2.0 | 2.0 | December 31, 2012 |
| Microsoft SQL Server 2005 JDBC Driver 1.2 | 1.2 | June 25, 2011 |
| Microsoft SQL Server 2005 JDBC Driver 1.1 | 1.1 | June 25, 2011 |
| Microsoft SQL Server 2005 JDBC Driver 1.0 | 1.0 | June 25, 2011 |
| Microsoft SQL Server 2000 JDBC Driver | 2000 | July 9, 2010 |
Download Jdbc Driver For Sql Server 2014
SQL version compatibility
| Driver Version | SQL Server 2008 | SQL Server 2008R2 | SQL Server 2012 | Azure SQL Database | PDW 2008R2 AU34 | SQL Server 2014 | SQL Server 2016 | SQL Server 2017 | SQL Server 2019 |
|---|---|---|---|---|---|---|---|---|---|
| 7.4 | N | N | Y | Y | Y | Y | Y | Y | Y |
| 7.2 | N | Y | Y | Y | Y | Y | Y | Y | N |
| 7.0 | N | Y | Y | Y | Y | Y | Y | Y | N |
| 6.4 | N | Y | Y | Y | Y | Y | Y | Y | N |
| 6.2 | Y | Y | Y | Y | Y | Y | Y | Y | N |
| 6.1 | Y | Y | Y | Y | Y | Y | Y | N | N |
| 6.0 | Y | Y | Y | Y | Y | Y | Y | N | N |
| 4.2 | Y | Y | Y | Y | Y | Y | Y | N | N |
| 4.1 | Y | Y | Y | Y | Y | Y | Y | N | N |
| 4.0 | Y | Y | Y | Y | Y | Y | Y | N | N |
| 3.0 | Y | Y | Y1 | Y2 | N | Y5 | N | N | N |
| 2.0 | Y3 | Y3 | N | N | N | N | N | N | N |
| 1.2 | Y3 | N | N | N | N | N | N | N | N |
| 1.1 | N | N | N | N | N | N | N | N | N |
| 1.0 | N | N | N | N | N | N | N | N | N |
| 2000 | N | N | N | N | N | N | N | N | N |
1Microsoft SQL Server JDBC Driver version 3.0 can connect to SQL Server 2012 as a down-level client.
2Support for Azure SQL Database was introduced in the 3.0 driver as a hotfix. We recommend that Azure SQL Database customers use the latest driver version available.
3Microsoft SQL Server JDBC Driver version 2.0 and Microsoft SQL Server 2005 JDBC Driver version 1.2 can connect to SQL Server 2008 as a down-level client. When down-level conversions are allowed, applications can execute queries and perform updates on the new SQL Server 2008 data types, such as time, date, datetime2, datetimeoffset, and FILESTREAM. For more information about how to use these new data types with the JDBC driver, see Working with SQL Server 2008 Date/Time Data Types using JDBC Driver and Working with SQL Server 2008 FileStream using JDBC Driver. For more information about the down-level compatibility of these new data types, see Using Date and Time Dataand FILESTREAM Support topics in SQL Server Books Online.
4Support for connections between the Microsoft JDBC Driver and Parallel Data Warehouse was first introduced in the Microsoft JDBC Driver 4.0 for SQL Server and Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance Update 3.
5Microsoft SQL Server JDBC Driver version 3.0 can connect to SQL Server 2014 as a down-level client.
Java and JDBC specification support
| JDBC Driver Version | JRE Versions | JDBC API Version |
|---|---|---|
| 7.4 | 1.8, 11, 12 | 4.2, 4.3 (partially) |
| 7.2 | 1.8, 11 | 4.2, 4.3 (partially) |
| 7.0 | 1.8, 10 | 4.2, 4.3 (partially) |
| 6.4 | 1.7, 1.8, 9 | 4.1, 4.2, 4.3 (partially) |
| 6.2 | 1.7, 1.8 | 4.1, 4.2 |
| 6.1 | 1.7, 1.8 | 4.1, 4.2 |
| 6.0 | 1.7, 1.8 | 4.1, 4.2 |
| 4.2 | 1.7, 1.8 | 4.1, 4.2 |
| 4.1 | 1.7 | 4.0 |
| 4.0 | 1.5, 1.6, 1.7 | 3.0, 4.0 |
| 3.0 | 1.5, 1.6, | 3.0, 4.0 |
| 2.0 | 1.5, 1.6 | 3.0, 4.0 |
| 1.2 | 1.4, 1.5, 1.6 | 3.0 |
| 1.1 | 1.4 | 3.0 |
| 1.0 | 1.4 | 3.0 |
| 2000 | 1.4 | 3.0 |
Supported operating systems
The Microsoft JDBC driver is designed to work on any operating system that supports the use of a Java Virtual Machine (JVM). Some commonly used platforms include Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2008 R2, Windows Vista, Linux, Unix, AIX, MacOS, and others.
The JDBC product team tests our driver on Windows, Sun Solaris, SUSE Linux, and RedHat Linux. Customer Support is available to customers on all platforms, however we may ask you to reproduce the issue on a platform such as Windows.
Application server support
The Microsoft JDBC Driver for SQL Server is tested with various application servers. Consult your application server vendor for additional details on which driver version is compatible with their product.
We have recently migrated to SQL server 2014 with JAVA 5 on one machine and JAVA 6 on another (this is a requirement). When I try to connect to database I get follwoing exception.
Following is the configuration:
- OS: Windows server 2012
- SQL server 2014
- JAVA version: JDK5u11 and JDK6u24
- Jar file: sqljdbc.jar for JDK5 and sqljdbc4.jar for JDK6
2 Answers
You will need to upgrade your SQL Server JDBC driver to at least version 4.0 (download here). Then you can use its versions of
- sqljdbc.jar for Java 5, and
- sqljdbc4.jar for Java 6
to access SQL Server 2014.
Gord ThompsonGord ThompsonWe discarded the sqljdnc4.jar and used jtds jar instead and everything works like a charm.