Connect to dbExpress Data Source (FireDAC)

From RAD Studio
Jump to: navigation, search

Go Up to Database Connectivity (FireDAC)

This topic describes how to connect to dbExpress data source.

Supported Versions

The FireDAC DBX bridge driver supports:

  • dbExpress v 1-3, accessible in Delphi versions 6 - 2005.
  • dbExpress v 4, also called "DBX framework", accessible in Delphi 2007 and later.

Windows Client Software

FireDAC requires the installation of a dbExpress driver. Additionally you can find:

  • the portional list of accessible 3d party drivers here.
  • dbExpress v 1-3 specification here.
  • dbExpress v 4 overview here.

Driver Linkage

To link the dbExpress v 1-3 driver:

  • drop a TFDPhysDBXDriverLink component from the "FireDAC Links" palette page
  • or include the FireDAC.Phys.DBExp unit in a uses clause.

To link the dbExpress v 4 driver:

Connection Definition Parameters

The connection definition parameters are specific to each driver and are taken from dbxdrivers.ini. After specifying the DriverName parameter, the connection definition editor fills the connection parameter list with the parameters specific to this driver. Additionally, the FireDAC DBX bridge driver supports the following parameters (see Defining Connection (FireDAC) for details):

  • DriverID=DBX for dbExpress v 1-3
  • DriverID=TDBX for dbExpress v 4
Parameter Description Example value
MetaDefCatalog Specifies the default catalog for the application. The design time code omits the catalog name in the object name if it is equal to MetaDefCatalog. Northwind
MetaDefSchema Specifies the default schema for the application. The design time code omits the schema name in the object name if it is equal to MetaDefSchema. dbo

Use Cases

  • Connect to Blackfish SQL.

Note: The parameter names are case sensitive.

DriverID=TDBX
DriverName=BlackfishSQL
hostname=127.0.0.1
port=2508
database=c:\addemo
create=True
user_name=sysdba
password=masterkey
  • Connect to Oracle Database:
DriverID=TDBX
DriverName=Oracle
RDBMS=ORACLE
Database=ORA_920_APP
User_Name=addemo
Password=a
  • Connect to Informix Dynamic Server:
DriverID=TDBX
DriverName=Informix
HostName=ol_svr_custom
Database=sysuser
User_Name=informix
Password=informix2

See Also