Connect to dbExpress data source (AnyDAC)

From RemObjects Software

Jump to: navigation, search

This is a AnyDAC Database Connectivity entry
Feel free to add your notes to this topic below.


Contents

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.

Client software

AnyDAC requires that dbExpress driver must be installed according to topic "Deploying dbExpress Database Applications" of the Delphi / RAD Studio online help. You can find:

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

Connection definition parameters

DriverID=DBX for dbExpress v 1-3
DriverID=TDBX for dbExpress v 4

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

Parameter

Description

Example value

MetaDefCatalog

Specifies default catalog for application. The design time code will omit catalog name in object names, if it is equal to MetaDefCatalog.

Northwind

MetaDefSchema

Specifies default schema for application. The design time code will omit schema name in object names, if it is equal to MetaDefSchema.

dbo

Usage cases

  • Connect to Blackfish SQL DBMS: 

[My_BSQL]
 DriverID=TDBX
 DriverName=BlackfishSQL
 hostname=127.0.0.1
 port=2508
 database=c:\addemo
 create=True
 user_name=sysdba
 password=masterkey

See Also

Product: RemObjects AnyDAC
Current version: AnyDAC 2.0

Glossary — Features — How To — Components — Tools — Samples — Articles — Architecture — Issues

Retrieved from "http://wiki.remobjects.com/wiki/Connect_to_dbExpress_data_source_%28AnyDAC%29"
Personal tools