At the Professional Association of SQL Server (PASS) Summit 2011, Microsoft's cvp Quentin Clark announced a preview of the Microsoft SQL Server ODBC Driver for Linux will soon be widely available to customers.
"Many of our developers who rely on native connectivity to SQL Server primarily use ODBC for their connectivity needs. We have been supporting ODBC as a part of the SQL Native Access Client (SNAC) libraries. In our continued commitment to interoperability, today we also announced that we will be releasing the Microsoft SQL Server ODBC Driver for Linux," Microsoft official said.
Shekhar Joshi, Program Manager for the driver shared the following details about the driver:
Joshi also said that his team is confident that this is will be a high-quality release, in part due to how the driver is being developed. Ad, that his team is using the existing, reliable ODBC for Windows driver (a.k.a. SQL Server Native Client, or SNAC) as a starting point. They are carefully modifying the existing code so that it will compile for Linux/Unix operating systems, and testing it rigorously.
- The preview release will be a 64-bit driver for Red Hat Enterprise Linux 5. His team plans to implement support for Red Hat 6 for the RTM release of the driver. Plans to release a 32-bit version of the driver are on the roadmap.
- The release will include BCP and SQLCMD utilities.
- Notable driver features (in addition to what you would expect in an ODBC driver) include support for the Kerberos authentication protocol, SSL, and client-side UTF-8 encoding.
- Features that are not supported in this release include support for Always On Availability Groups (though this is on the roadmap) and mirroring.
He said, "We will be releasing first community technology preview (CTP) around mid-November and will be available along with SQL Server 2012 when it is released."