The SQL Server team introduced several tools that enable interoperability with SQL Server 2012. These tools help developers to build secure, highly available and high performance applications for SQL Server in .NET, C/C++, Java and PHP, on-premises and in the cloud.
These new tools include a Microsoft SQL Server 2012 Native Client, a SQL Server ODBC Driver for Linux, backward compatibility with ADO.Net and the Microsoft JDBC Driver 4.0 and PHP Driver 3.0.
The tools includes the following:
- SQL Server ODBC Driver for Linux allows native C and C++ applications to leverage the standard ODBC API and connect directly to SQL Server 2012. This offers database administrators and developers greater flexibility when building and managing applications that run on Linux and co-exist with the SQL Server environment. The highlights of this release are native connectivity from Linux to SQL Server via ODBC, support for 64-bit Red Hat Enterprise Linux 5 and 6 and tools such as BCP and SQLCMD. [Download]
- ADO.NET Backward Compatibility: The ADO.NET team modified two features from .NET4.5 to .NET4: SQL Server AlwaysOn and SQL Server Express LocalDB support. Now, customers will be able to leverage SQL Server 2012 from their existing SQL Server applications, without having to wait until the Windows8 release. To take advantage of this new support for AlwaysOn and LocalDB, customers need to install [Update 4.0.3 for the Microsoft .NET Framework 4.]
- Microsoft JDBC Driver 4.0: The JDBC driver for SQL Server provides SQL Server and SQL Azure access from any Java application. The latest driver includes pure Java implementation of Kerberos Integrated security, SQL Server AlwaysOn, support for SQL Server Parallel Data Warehouse, easy access to diagnostic information in the extended events log, UTF-16 support and enhanced SQL Azure support. [Download]
- Microsoft SQL Server 2012 Native Client (SNAC): This native client (SNAC) is a single dynamic-link library (DLL) containing both the SQL Server OLE DB provider and SQL Server ODBC driver. The SNAC driver ships with SQL Server 2012 and contains features such as support for AlwaysOn, SQL Server Express LocalDB, enhanced support for SQL Azure and performance improvements for developers. [Download]
- The Microsoft PHP Driver for SQL Server version 3.0: Coupled with the SQL Server 2012 release, this latest PHP driver makes some big improvements in developing PHP/SQL Server applications. The newly supported SQL Server 2012 features include Buffered Queries and SQL Server AlwaysOn – encompassing support for Multi-Subnet Failover, access to Availability Groups and Read-Only Routing – and support for SQL Server 2012 Express LocalDB.[Download]