2017/05/09

Connect SQL Server from FireDAC in Ubuntu

FireDAC + Ubuntu + SQL Server the Frame Diagram photo

Now, We could connection database from Ubuntu to SQL Server use Delphi 10.2 FireDAC.

The SQL Server in AWS and Ubuntu version comparison.  For AWS version have support all feature like for Windows version. It's best solution!

If you would understand more about it. You can go to the URL:
Ubuntu(FireDAC)を使ってMS SQL Server(RDS)に接続する。[JAPAN]
Connect to Microsoft SQL Server (FireDAC)

 

仍然建議使用三方元件 -- 2024/02/15 更新

因為官方連結已失效,故參考 EMBT docs 重新整理本篇。

FireDAC 要在類 Unix (Unix-like) 系統上連結 MSSQL,一定要使用 ODBC:

  • UnixODBC (libodbc.dylib)
  • FreeTDS (libtdsodbc.dylib) ODBC driver (MAC)
  • SQL Server 的 Microsoft ODBC Driver 11 (Linux)

原始主文是以 AWS 的 SQL Server 為主軸,然而在 stackoverflow 上則有網友表示 FireDAC 在這方面還很有問題,會建議採用 Devart Driver (SDAC 或 dbExpress Driver
for SQL Server)。

See Also