AnyDAC
ContentsIndexHome
PreviousUpNext
Connect to dbExpress data source

Describes how to connect to dbExpress data source.

Group
Links
Supported versions

The AnyDAC 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 higher.

 

Windows client software

AnyDAC requires that a dbExpress driver must be installed according to the topic "Deploying dbExpress Database Applications" of the Delphi/RAD Studio online help. 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:

To link the dbExpress v 4 driver:

 

Connection definition parameters

Connection definition parameters are specific for each driver and are taken from dbxdrivers.ini. The connection definition editor, after specifying the DriverName parameter, fills the connection parameter list by the parameters specific for this driver. Additionally, AnyDAC DBX bridge driver supports the following parameters:

  • 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 will omit the catalog name in object names if it is equal to MetaDefCatalog. 
Northwind 
MetaDefSchema 
Specifies the default schema for the application. The design time code will omit the schema name in object names if it is equal to MetaDefSchema. 
dbo 

 

Usage cases
  • Connect to Blackfish SQL. Note the parameters case:

 

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
What do you think about this topic? Send feedback!