ODBC Data Access Components

A feature-rich and high-performance library of components that provides data access for data sources exposed through ODBC.

ADO.Net VCL Download

Overview

ODBC Data Access Components (ODBCDAC) is a feature-rich and high-performance library of components that provides data access for data sources exposed through ODBC. The components support both 32-bit and 64-bit platforms. ODBCDAC-based applications connects to any data source exposed through ODBC using the .NET Framework Data Provider for ODBC.ODBCDAC aims to assist programmers in developing of fast and native database applications. ODBCDAC uses the native ODBC Driver Manager (DM) to enable data access. ODBCDAC uses the native ODBC Driver Manager (DM) to enable data access.

ODBCDAC-based DB applications are easy to deploy, requires installation of ODBC drivers, uses ADO.Net technologies and works faster than the ones based on standard Delphi data connectivity solutions.

ODBCDAC requires the x86 or x64 ODBC driver to be installed according to ODBC specification. Please see the following ODBC documentation:

Component List

OdbcConnection

TOdbcConnection
Lets you set up and control connections to a data source through ODBC drivers.

OdbcCommand

TOdbcCommand
Executes a Transact-SQL statement or stored procedure against a data source.

OdbcDataReader

TOdbcDataReader
Provides a way of reading a forward-only stream of rows from a data source.

OdbcDataAdapter

TOdbcDataAdapter
Lets you fill Virtual Table components with data and update a data source.

OdbcQuery

TOdbcQuery
Uses SQL statements to retrieve data from tables in a data source and pass it to one or more data-aware components through a TDataSource object.
This component provides a mechanism for updating data.

OdbcTable

TOdbcTable
Lets you retrieve and update data in a single table in a data source without writing SQL statements.

OdbcStoredProc

TOdbcStoredProc
Executes stored procedures and functions in a data source. Lets you edit cursor data returned as parameter.

Features

  • Direct access to server data via ODBC providers.
  • Interface compatible with standard data access methods, such as BDE and ADO
  • Unicode support
  • Easy to deploy
  • Transmission is via XML format, therefore can pass through firewalls
  • High overall performance
  • Fast controlled fetch of large data blocks
  • High performance of applying cached updates with batches
  • Advanced connection pooling
  • High performance batch processing
  • Intelligent fetch block size control
  • Support prefetching rows - specifies the number of rows that are to be fetched per server round trip. This is controlled by FetchOptions.RowsetSize property
  • CachedUpdates operation mode which is controlled UpdateOptions.UpdateMode property
  • Automatic data updating with TOdbcQuery, TOdbcTable, and TOdbcStoredProc components
  • Fast data retrieval with TOdbcDataReader component or using Server CursorKind property of the TCustomDbDataSet
  • Automatic record refreshing and locking
  • Automatic query preparing
  • Data export and import to/from XML
  • Advanced design-time component and property editors
  • ... and many more

Microsoft-Supplied ODBC Drivers

  • Microsoft Access Drivers
    • Microsoft Access Driver (*.mdb, *.accdb)
    • Microsoft Access Driver (*.mdb)
  • Microsoft Excel Drivers
    • Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)
    • Microsoft Excel Driver (*.xls)
  • Paradox Drivers
    • Microsoft Paradox Driver (*.db)
  • Dbase Drivers
    • Microsoft dBase Driver (*.dbf)
  • Text Files
    • Microsoft Text Driver (*.txt; *.csv)
  • ODBC Driver for Oracle
    • Microsoft ODBC for Oracle
  • Microsoft SQL Server
    • SQL Server Native Client 11.0
    • SQL Server Native Client 10.0
    • SQL Native Client
    • ODBC Driver 11 for SQL Server
    • SQL Server

Compatibility

Any database using OBDC driver

IDE Compatibility

  • Embarcadero RAD Studio 10.2 Tokyo
    • Embarcadero Delphi 10.2 Tokyo for Windows 32-bit & 64-bit
  • Embarcadero RAD Studio 10.1 Berlin
    • Embarcadero Delphi 10.1 Berlin for Windows 32-bit & 64-bit
  • Embarcadero RAD Studio 10 Seattle
    • Embarcadero Delphi 10 Seattle for Windows 32-bit & 64-bit
  • Embarcadero RAD Studio XE8
    • Embarcadero Delphi XE8 for Windows 32-bit & 64-bit
  • Embarcadero RAD Studio XE7
    • Embarcadero Delphi XE7 for Windows 32-bit & 64-bit
  • Embarcadero RAD Studio XE6
    • Embarcadero Delphi XE6 for Windows 32-bit & 64-bit
  • Embarcadero RAD Studio XE5
    • Embarcadero Delphi XE5 for Windows 32-bit & 64-bit
  • Embarcadero RAD Studio XE4
    • Embarcadero Delphi XE4 for Windows 32-bit & 64-bit
  • Embarcadero RAD Studio XE3
    • Embarcadero Delphi XE3 for Windows 32-bit & 64-bit
  • Embarcadero RAD Studio XE2
    • Embarcadero Delphi XE2 for Windows 32-bit & 64-bit
  • Embarcadero RAD Studio XE
    • Embarcadero Delphi XE
  • Embarcadero RAD Studio 2010
    • Embarcadero Delphi 2010
  • CodeGear RAD Studio 2009
    • CodeGear Delphi 2009