MS SQL Server 2000 ODBC driver for Linux
2
votes
2
answers
4757
views
Microsoft has official ODBC drivers for MS SQL Server, for Linux. Great! [Nice installation instructions for all the major distros, too.](https://blogs.msdn.microsoft.com/sqlnativeclient/2016/10/20/odbc-driver-13-0-for-linux-released/)
Unfortunately, their ODBC drivers, going back to the [oldest version I can find](https://www.microsoft.com/en-us/download/details.aspx?id=28160) only support SQL Server 2005 and newer:
> Native Data Access APIs – ODBC and OLE DB – for SQL Server 2005 and later.
I need to connect to a very old SQL Server (2000):
SELECT @@VERSION
→
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
I've confirmed that the v13 driver **does not work**:
$ sqlcmd -U XXXX -S 10.1.2.3
Password:
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : ODBC Driver 13 for SQL Server does not support connections to SQL Server 2000 or earlier versions..
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Client unable to establish connection.
—
Is there an official MS SQL ODBC driver that will run on a modern 64-bit Linux and connect to SQL Server 2000?
Or do I need to go to third party drivers like the open-source [FreeTDS](http://www.freetds.org/userguide/prepodbc.htm) ?
Asked by Dan Lenski
(121 rep)
Jan 19, 2017, 08:55 PM
Last activity: May 12, 2017, 05:34 PM
Last activity: May 12, 2017, 05:34 PM