Show: Object Pascal C++
Display Preferences

Databases (FireDAC)

From Appmethod Topics
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
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)
MacOS
  • UnixODBC (libodbc.dylib) x86 ODBC driver manager library.
  • SQL Anywhere (libdbodbcNN.so) 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)
DataSnap Server DataSnap server built with Appmethod 2007 and higher. DataSnap client built with Appmethod XE2 Enterprise and higher Win32 DataSnap dbExpress driver is statically linked. No additional libraries required. TFDPhysDSDriverLink,

FireDAC.Phys.DS

DataSnap
Win64
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
MacOS

libfbclient.dylib (x86)

InterBase Server Interbase v 6 and higher Win32 gds32.dll TFDPhysIBDriverLink,

FireDAC.Phys.IB

IB
Win64

ibclient64.dll

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

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 and higher, SQL Native Client 2005 and higher
  • Microsoft SQL Azure, SQL Native Client 2008 and higher
  • Microsoft LocalDB, SQL Native Client 2012 and higher
Win32
  • ODBC driver from MDAC 2.8
  • SQL Native Client 2005 and higher
  • SQL Native Client 2008 and higher
  • SQL Native Client 2012 and higher
TFDPhysMSSQLDriverLink,

FireDAC.Phys.MSSQL

MSSQL
Win64
  • ODBC driver from MDAC 2.8
  • SQL Native Client 2005 and higher
  • SQL Native Client 2008 and higher
  • SQL Native Client 2012 and higher
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
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
MacOS libclntsh.dylib (x86)
PostgreSQL Server v 7.4 and higher Win32 libpq.dll (x86) TFDPhysPGDriverLink,

FireDAC.Phys.PG

PG
Win64 libpq.dll (x64)
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
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
MacOS Teradata ODBC Driver for Mac 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
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

(Object Pascal 5 to Appmethod 2006)

Win32 dbExpress drivers v 1-3 TFDPhysDBXDriverLink,

FireDAC.Phys.DBX

DBX
dbExpress Data Source dbExpress v 4

(Appmethod 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 ODBC drivers v 1-3
MacOS UnixODBC
Note: (**) The bpl includes the product version (<nnn>) in its name.


Additional Connections

See Also

Personal tools
In other languages