Databases (FireDAC)

From RAD Studio
Jump to: navigation, search

Go Up to Architecture (FireDAC)


FireDAC supports a wide range of Database Management Systems (DBMS).

Native Connections

For additional information, including support for other platforms, click the links in the "Name" column.

Name Server and client version Platforms Required libraries (Client) Driver link component,

Driver implementation unit

DriverID parameter
Advantage Database Server Server and client v 8.0 and higher Win32 ace32.dll TFDPhysADSDriverLink,

FireDAC.Phys.ADS

ADS
Win64 ace64.dll
Linux64 libace.so
Sybase SQL Anywhere (*) Server and client v 5.0.0 and higher Win32
  • Adaptive Server Anywhere ODBC driver (x86) to connect to v 5-7
  • SQL Anywhere N ODBC driver (x86)
 TFDPhysASADriverLink,

FireDAC.Phys.ASA

ASA
Win64
  • Adaptive Server Anywhere ODBC driver (x64) to connect to v 5-7
  • SQL Anywhere N ODBC driver (x64)
Linux64
  • UnixODBC (libodbc.so) x64 ODBC driver manager library
  • SQL Anywhere (libdbodbcNN.so) x64 ODBC driver
MacOS
  • UnixODBC (libodbc.dylib) x86 ODBC driver manager library.
  • SQL Anywhere ( libdbodbcNN.dylib) x86 ODBC driver.
IBM DB2 Server Server and client v 8.1 and higher Win32
  • IBM DATA SERVER driver for ODBC
  • IBM DB2 ODBC driver
  • IBM DB2 driver for ODBC (x86)
 TFDPhysDB2DriverLink,

FireDAC.Phys.DB2

DB2
Win64
  • IBM DATA SERVER driver for ODBC
  • IBM DB2 ODBC driver
  • IBM DB2 driver for ODBC (x64)
Linux64
  • UnixODBC (libodbc.so) x64 ODBC driver manager library
  • IBM DB2 (libdb2o.so) x64 ODBC driver
DataSnap Server DataSnap server built with RAD Studio 2007 and higher. DataSnap client built with RAD Studio XE2 Enterprise and higher Win32 DataSnap dbExpress driver is statically linked. No additional libraries required. TFDPhysDSDriverLink,

FireDAC.Phys.DS

DataSnap
Win64
Linux64
MacOS
iOSDevice32
iOSDevice64
Android
Firebird Firebird and fbclient.dll v 1.5 and higher Win32
  • fbclient.dll (x86) to connect to Firebird server
  • fbembed.dll (x86) to connect to Firebird Embedded server
 TFDPhysFBDriverLink,

FireDAC.Phys.FB

FB
Win64
  • fbclient.dll (x64) to connect to Firebird server
  • fbembed.dll (x64) to connect to Firebird Embedded server
Linux64 libfbclient.so
MacOS libfbclient.dylib (x86)
InterBase Server Interbase v 6 and higher Win32 gds32.dll TFDPhysIBDriverLink,

FireDAC.Phys.IB

IB
Win64 ibclient64.dll
Linux64 libgds.so
MacOS
iOS Simulator 		libgsds.dylib
iOSDevice32
iOSDevice64 		libibtogo.a
Android libibtogo.a
InterBase Lite / InterBase ToGo Interbase v 6 and higher Win32 ibtogo.dll TFDPhysIBDriverLink,

FireDAC.Phys.IB

IBLite
Win64 ibtogo64.dll
Linux64 libibtogo.so
MacOS libibtogo.dylib
iOSDevice32
iOSDevice64 		libibtogo.a
Android libibtogo.a
Informix Server v 8 and higher. Informix Client SDK v 3.5 and higher. Win32 IBM INFORMIX ODBC driver TFDPhysInfxDriverLink,

FireDAC.Phys.Infx

Infx
Win64 IBM INFORMIX ODBC driver (64-bit)
Microsoft Access Database
  • Microsoft Access 2000 ODBC driver v 4 from MDAC 2.8 and higher
  • Microsoft Access 2007 ODBC driver v 12 and higher
 Win32
  • Microsoft Access Driver (*.mdb) x86 ODBC driver version 3 or later (Microsoft JET ODBC driver) for 95-2003 databases
  • Microsoft Access Driver (*.mdb, *.accdb) x86 ODBC driver version 12 or later for 95-2010 databases
 TFDPhysMSAccessDriverLink,

FireDAC.Phys.MSAcc

MSAcc
Win64

Microsoft Access Driver (*.mdb, *.accdb) x64 ODBC driver version 12 or later for 95-2010 databases

Microsoft SQL Server
  • Microsoft SQL Server 2000, ODBC driver from MDAC 2.8
  • Microsoft SQL Server 2005, SQL Native Client 2005
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2014
  • Microsoft SQL Server 2016
  • Microsoft SQL Azure, SQL Native Client 2008
  • Microsoft LocalDB, SQL Native Client 2012
 Win32
  • ODBC driver from MDAC 2.8
  • SQL Native Client 2005
  • SQL Native Client 2008
  • SQL Native Client 2012
  • ODBC Driver 11
  • ODBC Driver 13
 TFDPhysMSSQLDriverLink,

FireDAC.Phys.MSSQL

MSSQL
Win64
  • ODBC driver from MDAC 2.8
  • SQL Native Client 2005
  • SQL Native Client 2008
  • SQL Native Client 2012
  • ODBC Driver 11
  • ODBC Driver 13
Linux64
  • UnixODBC (libodbc.so) x64 ODBC driver manager library
  • Microsoft ODBC (msodbcsqlNN.so) x64 driver for SQL Server on Linux
  • ODBC Driver 13
MacOS
  • libodbc.dylib
  • libtdsodbc.so
MySQL Server Server and client 3.21 and higher Win32
  • libmysql.dll (x86) to connect to MySQL server
  • libmysqld.dll (x86) to connect to MySQL embedded server
 TFDPhysMySQLDriverLink,

FireDAC.Phys.MySQL

MySQL
Win64
  • libmysql.dll (x64) to connect to MySQL server
  • libmysqld.dll (x64) to connect to MySQL embedded server
Linux64 libmysqlclient.so
MacOS libmysqlclient.dylib
Oracle Server Server and client 8.0.3 and higher Win32
  • Fat Oracle Client (x86)
  • Thin Oracle Instant Client (x86): oci.dll, oraocci11.dll, oraociei11.dll, orasql11.dll
 TFDPhysOracleDriverLink,

FireDAC.Phys.Oracle

Ora
Win64
  • Fat Oracle Client (x64)
  • Thin Oracle Instant Client (x64): oci.dll, oraocci11.dll, oraociei11.dll, orasql11.dll
Linux64 libclntsh.so
MacOS libclntsh.dylib (x86)
PostgreSQL Server v 7.4 and higher Win32 libpq.dll (x86) TFDPhysPGDriverLink,

FireDAC.Phys.PG

PG
Win64 libpq.dll (x64)
Linux64 libpq.so
MacOS libpq.dylib (x86)
SQLite database SQLite database version 3.0 and later. Win32
  • sqlite3_x86.obj
  • sqlite3.dll (x86) v 3 and higher
 TFDPhysSQLiteDriverLink,

FireDAC.Phys.SQLite

SQLite
Win64
  • sqlite3_x64.obj
  • sqlite3.dll (x64)v 3 and higher
Linux64 libsqlite3.so
MacOS libsqlite3.dylib
iOSDevice32
iOSDevice64 		libsqlite3.dylib
Android sqlite.so
Teradata Database Server and client version 13 and higher. Win32 Teradata ODBC Driver for Windows TFDPhysTDataDriverLink,

FireDAC.Phys.TData

TData
Win64 Teradata ODBC Driver for Windows 64
Linux64 Teradata x64 ODBC Driver For Linux
MacOS Teradata ODBC Driver for OS X
MongoDB Database Server and client version 3.0 and higher. Win32
  • libbson-1.0.dll
  • libmongoc-1.0.dll
  • msvcr100.dll
 TFDPhysMongoDriverLink,

FireDAC.Phys.MongoDB

Mongo
Win64
  • libbson-1.0.dll
  • libmongoc-1.0.dll
  • msvcr100.dll
Linux64
  • libbson-1.0.0.so
  • libmongoc-1.0.0.so
MacOS
  • libbson-1.0.0.dylib
  • libmongoc-1.0.0.dylib
Note: (*) For the required libraries (Client), N is the DBMS major version number (8, 9 or 10)

Bridge Connections

Name Server and client version Platforms Required libraries (Client) Driver link component,

Driver implementation unit

DriverID parameter
dbExpress Data Source dbExpress drivers v 1-3

(Delphi 5 to RAD Studio 2006)

Win32 dbExpress drivers v 1-3 TFDPhysDBXDriverLink,

FireDAC.Phys.DBX

DBX
dbExpress Data Source dbExpress v 4

(RAD Studio 2007 and higher) (FireDACDBXDriver<nnn>.bpl) (**)

Win32 dbExpress drivers v 4 TFDPhysTDBXDriverLink,

FireDAC.Phys.TDBX

TDBX
Win64
MacOS
iOSDevice32
iOSDevice64
Android
ODBC Data Source ODBC Level 2, 3 drivers Win32 ODBC drivers v 1-3 TFDPhysODBCDriverLink,

FireDAC.Phys.ODBC

ODBC
Win64, Linux64 ODBC drivers v 1-3
MacOS UnixODBC
Note: (**) The bpl includes the product version (<nnn>) in its name.

Additional Connections

See Also

Retrieved from "http://docwiki.embarcadero.com/RADStudio/Rio/e/index.php?title=Databases_(FireDAC)&oldid=266343"