Microsoft SQL Server versions and FreeTDS
Geoff Montee <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAA7biFMkuuGW8LxajDQ+vgSU_C+LzhN9KOftR2Qns8oe_0AzFQ@mail.gmail.com> |
I wrote an open source TDS foreign data wrapper for PostgreSQL using your implementation of DB-Library: https://github.com/GeoffMontee/tds_fdw I mainly wrote it to connect to Sybase databases, but its compatibility with Microsoft SQL Server is a nice added benefit. Your TDS protocol page hasn't been updated in a while: http://www.freetds.org/userguide/choosingtdsprotocol.htm It's missing MS SQL Server 2008 R2, MS SQL Server 2012, and MS SQL Server 2014. I'm curious, does your implementation of DB-Library support these newer versions of MS SQL Server? I ask because Microsoft's own documentation says that they may drop DB-Library support in the future: http://technet.microsoft.com/en-us/library/aa174484%28v=SQL.80%29.aspx "While the DB-Library API is still supported in Microsoft SQL Server 2000, no future versions of SQL Server will include the files needed to do programming work on applications that use this API. Connections from existing applications written using DB-Library will still be supported in the next version of SQL Server, but this support will also be dropped in a future release. When writing new applications, avoid using DB-Library. When modifying existing applications, you are strongly encouraged to remove dependencies on DB-Library." Thanks, Geoff Montee