航行日志

ODB在1.8.0版本开始支持mssql

Support for the Microsoft SQL Server database. The provided connection
factories include ‘new’ (a new connection is created every time one is
requested) and ‘pool’ (a pool of connections is maintained). The Boost
and Qt profiles have been updated to support this database. For more
information, refer to Chapter 17, “Microsoft SQL Server Database” in
the ODB manual.

Note that with the release of SQL Server Native Client ODBC driver for
Linux it is possible to access an SQL Server database from the GNU/Linux
operating systems. The SQL Server ODB runtime has been tested and is
fully supported on both Windows and GNU/Linux. However, we have found
that the unixODBC 2.3.0 driver manager that is recommended in the Native
Client documentation does not work well, especially in multithreaded
applications. The recently released unixODBC 2.3.1 addressed this issue
and we recommend that you use this version with ODB. For more information,
refer to this blog post:

http://www.codesynthesis.com/~boris/blog/2011/12/02/microsoft-sql-server-odbc-driver-linux/

Note also that similar to Oracle, the SQL Server runtime (libodb-mssql)
is licensed under a different license compared to the open source
database runtimes. For more information, refer to the ODB License page:

http://www.codesynthesis.com/products/odb/license.xhtml

很不错,另外对schemas 也有了支持。

现在最新版已经更新到 2.0.1,更新频率还算活跃。