JDBC Type 4 SQL Server Driver announced

Microsoft has announced the availability of JDBC Driver for SQL Server that implements full compliance with JDBC Specifications 4.1 and 4.1. It supports the JDK 1.8 and the Transport Layer Security (TLS) for security over the Internet.  The JDBC 4.2 driver also supports the SQL Server's Always on feature.

Download link for JDBC 4.2 Driver is here (http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774)

JDBC is an important component of Microsoft Data Connectivty scheme:

JDBCMicrosoft.png\
The source for this information and image is here .

Review here for the usage of this driver while connecting to data source.

Review this connecting to SQL Server from PHP.

Using SQL Server with PHP 5.5

PHP is adopted worldwide and Microsoft has been providing hooks in the past  so that PHP applications can access SQL Server data. Extending connectivity to SQL Database on Microsoft Azure need no explanation.

SQL Server driver (SQLServer31.exe, 499KB, version 3.1.CTP) for PHP is now available as a CTP. Now PHP scripts can access Microsoft SQL Server and Microsoft Azure SQL Database.

You can download the CTP here:
http://www.microsoft.com/en-us/download/details.aspx?id=20098&WT.mc_id=Blog_SQL_Announce_DI

Details of this version:

This version

• Supports PHP Version 5.5 and requires Microsoft ODBC driver 11 (or higher)
• It supports SQL Server 2012; LocalDB and AlwaysOn features
• Buffered Queries are included

All SQL Server user can get it at no extra cost.

This widens the interoperability range.

The soon to be released JDBC driver compatible with JDK7 for SQL Server will enable applications to connect to SQL Server widening connectivity with Java Platform.

I have covered in detail how to use PHP applications (PHP versions 5.2.4 or later) to access data on Microsoft Azure SQL Databases (formerly called  Microsoft SQL Azure) using PHP Data Objects. Details are on pages 369-373, Chapter 10 in my 2010 book here:

 

You can buy or join the library here:

https://www.packtpub.com/application-development/microsoft-sql-azure-enterprise-application-development