SQL Server Drivers For PHP and ODBC Updated
Written by Kay Ewbank   
Thursday, 04 February 2016

Microsoft has released a preview version of the latest drivers for PHP for SQL Server, and has also released a community preview of the latest ODBC SQL Server driver for Windows and Linux. 

The Microsoft Driver 4.0 for PHP for SQL Server is an early technical preview, and gives you access to SQL Server, Azure SQL Database and Azure SQL DW from any PHP 7 application.

sqlserver

 

The main change to the new version is support for PHP 7, and it includes both threadsafe and non-threadsafe support. The developers plan on adding PDO Support to future releases, along with plans for a port, more support for SQL Server 2016 features such as being able to handle "Always Encrypted" data.

The preview is available on Github.

Another example of Microsoft's drive to be inclusive in the options for accessing SQL Server is the community technology preview of Microsoft ODBC Driver 13 for SQL Server on Windows and Linux, supporting Ubuntu, RedHat and SUSE distributions. The developers say the updated driver provides robust data access to Microsoft SQL Server and Microsoft Azure SQL Database via ODBC on Windows and Linux platforms.

The main improvement to the updated ODBC driver is the ability to use Always Encrypted. This is a new SQL Server 2016 and Azure SQL Database security feature designed to safeguard sensitive data from being seen in plain text in a SQL Server instance. It lets you transparently encrypt the data in the application, so that SQL Server will only handle the encrypted data and not plain text values.

This means that should the SQL instance or the host machine be compromised, the attacker sees encrypted ciphertext of the sensitive data. However, if you want to use the Always Encrypted feature, you have to use a supported driver such as ADO.NET or the ODBC 13 Driver for SQL Server Preview. These drivers let you  to encrypt the plain text data then store the encrypted data inside SQL Server 2016 or Azure SQL Database. You can then decrypt the data using one of the suitable drivers.

The new driver also adds support for Internationalized Domain Names (IDNs), which allow your web server to use Unicode characters for the server name so adding support for more languages. The driver lets you convert a Unicode serverName to ASCII compatible encoding (Punycode) when required during a connection.

The support for Ubuntu in the Linux ODBC drivers is also new, joining RedHat and SUSE. The new version also updates the drivers to unixODBC driver manager 2.3.1 support.

 sqlserver

 

More Information

SQL Server Blog

MSDN Blog

PHP Driver On Github

ODBC Driver For Windows

ODBC Driver For Ubuntu

ODBC Driver For RedHat

ODBC Driver For SUSE

Related Articles

PHP At 20

PHP Gets A Formal Specification 

The Next Version Of PHP And The Status Of PHPng

SQL Server 2016 And Azure Lake

First Preview Of SQL Server 2016

 

To be informed about new articles on I Programmer, sign up for our weekly newsletter,subscribe to the RSS feed and follow us on, Twitter, FacebookGoogle+ or Linkedin

 

Banner


Google Releases Gemma Open Models
28/02/2024

Google has released a set of lightweight open models that have been built from the same research and technology used to create Google's recent Gemini models.



Google Donates $1M To Rust
26/02/2024

Google has made a donation of $1 million to The Rust Foundation. The contribution has been earmarked to underwrite the Interop Initiative: a new C++/Rust interoperability effort.


More News

 

raspberry pi books

 

Comments




or email your comment to: comments@i-programmer.info

Last Updated ( Thursday, 04 February 2016 )