Odbc driver 11 for sql server for x86 2008 install#
While this preview release of the driver is only officially supported on 64-bit RedHat EL 5, it is not too difficult to install it on 64-bit Debian or Ubuntu. We have been running some preliminary ODB tests with this driver and so far it has been working really well. You can also browse the driver documentation online. About a month ago they pre-announced a Linux driver and a preview version was made available as part of the SQL Server 2012 RC0 release.
Well, you may be surprised, but Microsoft did exactly that. Now you may be thinking, yeah, dream on, Microsoft will never release anything like this. So what we really need is the Microsoft Native Client ODBC driver for Linux. For now we are only interested in making sure that ODB works well with the Microsoft ODBC driver, since that’s what 99% of the users will use anyway. But the main problem with all these alternatives is that we are not really interested in testing any of these drivers. Then there are a number of commercial offerings with convoluted licensing models and restrictions. There is the ODBC driver that is part of the FreeTDS project but it has limited functionality (for example, it doesn’t support the Multiple Active Result Sets (MARS) feature). And that would be a major inconvenience compared to running tests directly from Emacs, which is what I am used to.ĭoing a few web searches didn’t yield anything useful. In our case this meant that while we could still build everything on Linux (using a MinGW cross-compiler), to actually run the tests we would have to copy everything over to a Windows box. The problem is (or rather was, as you will see shortly) that Native Client is only available on Windows. The recommended way to access SQL Server from native applications is using the SQL Server Native Client ODBC driver. This posed an interesting challenge once we started working on support for Microsoft SQL Server. We mainly develop ODB on GNU/Linux and then regularly test it on other platforms.
0 kommentar(er)
