Announcing Microsoft SQL Server ODBC Driver for Linux

Greetings Developer community: 

We heard yesterday and today at the PASS conference about the exciting new areas that we are investing in bringing the power of SQL Server to our 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. 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. Please look for announcement on our SQL Connectivity home page and SQL Server blog page.

 We will be showcasing Microsoft SQL Server ODBC Driver for Linux along with our Java and PHP solutions for SQL Server and Azure at PASS conference session “[AD-211-M] Developing Multi-Platform Applications for Microsoft SQL Server and Azure” on Thursday October 13th at 5:00PM at Washington State Convention Center Room #4C4. Also, if you have any questions or feedback on our multi-platform strategy as well as the entire gamut of support we provide to the application developers, I would encourage you to attend the PASS Panel Discussion with SQL Connectivity Leadership “[AD-101-M] SQL Connectivity Leadership Unplugged” on Friday, October 14, 2011, 2:30 PM - 3:45 PM at Washington State Convention Centre Room# 612 where I will be hosting a panel along with the rest of the leadership team that drives the strategy for our application platform.

 

Thanks,

Raghu Ram

Principal Group Program Manager

SQL Server

Comments

• Anonymous
  December 19, 2011
  Hi Raghu Ram, is this compatible with Sql Server 2005? Though it's written so as part of heading, the release overview mentions Sql Server 2008 R2. Appreciate a clarification Regards Salil Ibrahim

• Anonymous
  December 20, 2011
  The Microsoft SQL Server ODBC Driver for Linux was tested against SQL Server 2008 R2 and SQL Server 2012.  It was not tested against SQL Server 2008 or SQL Server 2005.  So, this is not a supported scenario, at this time.  You may find, however, that you can connect to a SQL Server 2005 database using the Microsoft SQL Server ODBC Driver for Linux.

• Anonymous
  December 29, 2011
  Hi

1. I thought the sql native client drivers are only supported for RHEL 5.x (not even for RHEL 6)
2. I am trying to build it using  (fedora core 13  , but when i try to connect to the database I always get connection error IM004 (SQLconnect error on SQL_HANDLE… , when tested using isql ). . I do not get why the connection problem (library installation error , odbc.ini or odbcinst.ini error or fedora 13 is not supported yet ? Can you share how you configure your odbc.ini and odbcinst.ini . When i switch on the trace the trace file shows : input handle of type 2 is allocated succesfully but the error comes within SQLConnect.c (I can ping my database server and connect to it successfully using freetds with unixodbc) ALso why sqlncli.h has been provided where we some attributes SQL_SOPT_SS_QUERYNOTIFICATION_xxx are defined , does that mean we the linux drivers does not support these features yet? Is there a way to verify the correctness of library installation and works by itself without using unixODBC I am trying to use the SQL native client with unixodbc because sql native client does supports some more features of the sql server (not sure if its true for linux driver but definitely for windows like query notifications and MARS). Thanks

• Anonymous
  July 27, 2015
  Unexpected news. Unexpected indeed. But I already found an alternative SQL server ODBC driver for Linux www.devart.com/.../download.html Check it out.