Microsoft has official ODBC drivers for MS SQL Server, for Linux. Great! Nice installation instructions for all the major distros, too.
Unfortunately, their ODBC drivers, going back to the oldest version I can find 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?