Universal Data Access Components Delphi 2005

Developer’s Description

Universal Data Access Components Delphi 2005

By Devart
Universal Data Access Components (UniDAC) is a library of non-visual cross-database data access components for Embarcadero RAD Studio XE, Embarcadero RAD Studio 2010, CodeGear Delphi 2009, C++Builder 2009, CodeGear RAD Studio 2007, Delphi 2007 for Win32, C++Builder 2007, Borland Developer Studio 2006, Delphi 2005, Turbo Delphi, Turbo Delphi for .NET, Turbo C++, Delphi 7,6, C++Builder 6, Lazarus and FreePascal for Win32 and Linux. We combined experience of long-term successful development into one great product, which provides unified access to the popular database servers like Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite and others. Using UniDAC with its server-independent interface is the best way to create cross-database applications. UniDAC brings outstanding flexibility and independence to your projects

Universal Data Access Components

Universal Data Access Components (UniDAC) is a library of components that provides direct access to multiple databases from Delphi and C++Builder including Community Edition, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms.

Unified Connectivity Solution

UniDAC provides transparent server-independent interfaces for working with different databases, and lets you change the client engine for a specific server type just by changing single connection option. It means that you can easily switch between different database servers in your cross-database UniDAC-based application.

Advantages of UniDAC Technology

UniDAC is easy to setup and use. It provides transparent server-independent interface for working with different databases. Selected database provider ensures the best way to perform operations on the server.

Server-Aware Providers

UniDAC chooses the best way specific to the server to perform most operations. Every UniDAC data provider uses server-specific native connectivity. All operations with data are performed by providers automatically considering the selected database server peculiarities.

Cross-Platform Solution for Delphi, C++Builder, and Lazarus

UniDAC is a cross-platform solution for developing applications using various IDEs: RAD Studio, Delphi, C++Builder, Lazarus (and FPC) on Windows, macOS, Linux, iOS, and Android, for both x86 and x64 platforms. UniDAC also provides support for the FireMonkey platform, which allows you to develop visually spectacular high-performance desktop and mobile native applications.

Server-Independent SQL

When developing database applications that allow working with several databases, one of the key points is writing of server-independent SQL. In UniDAC, the server-independent SQL support is implemented by means of the powerful macros engine, producing dynamic SQL by replacing parts of the query statements with user-defined code.

General usability

  • Direct access to server data. Does not require installation of other data provider layers (such as BDE)
  • Access without using client library [Oracle, SQL Server, MySQL, PostgreSQL, SQLite, DBF]
  • Interface compatible with standard data access methods, such as BDE and ADO
  • VCL, LCL and FMX versions of library available
  • Separated run-time and GUI specific parts allow you to create pure console applications such as CGI
  • Unicode support
  • National charset support [Oracle, MySQL, InterBase, PostgreSQL]
  • Unified SQL for writing server-independent queries
  • Highly usable design time support
  • Easy to deploy

Network and connectivity

  • Disconnected Mode with automatic connection control for working with data offline
  • Local Failover for detecting connection loss and implicitly reexecuting certain operations
  • Ability to search for installed servers in a local network [SQL Server, MySQL, PostgreSQL]
  • Connection timeout management [Oracle, SQL Server, MySQL, PostgreSQL, ODBC]
  • Support for OS authentication
  • Support for Proxy Authentication
  • Support for the change expired password
  • Support for both IPv6 and Ipv4 protocol


  • Support for the latest server versions
  • Support for embedded server versions
  • Support for Delphi 6, C++ Builder 6, and later versions up to RAD Studio 11 Alexandria
  • Support for Lazarus 2.0.12 and Free Pascal 3.2.0
  • Support for reporting components, including InfoPower, ReportBuilder, FastReport
  • Support for all standard and third-party visual data-aware controls
  • Support for Professional Edition of Delphi and C++Builder for developing client/server applications

Server-specific features

  • Oracle
    • Multiple Oracle Homes support
    • Oracle sequence support
    • Direct LOB access support
    • Temporary LOB management routines
    • Temporary LOBs for updating LOB fields
    • OCI connection pooling, proxy session pooling, and statement caching
    • Oracle optimizer control
    • DBMS_ALERT support with the TUniAlerter component
    • Secure connections with SSL, SSH, and HTTP tunneling
    • Oracle package support
    • Oracle 9i scrollable cursor support
    • DML array operations support
    • ProxySession support
    • External Procedure support
    • ROWID values retrieval
    • Overloaded stored procedures support
    • Support for WITH FUNCTION clause
  • SQL Server
    • Possibility to change application name for a connection
    • Possibility to change workstation identifier for a connection
    • Configuration of OEM/ANSI character translation
    • Enhanced support for SQL Server Compact Edition
    • Enhanced support for User-defined Types of SQL Server
    • Ability to lock records and tables
  • MySQL
    • HANDLER syntax support
    • Transaction isolation level support
    • Possibility to retrieve last auto-incremented value
    • Session identifer retrieval
    • Server object information retrieval
    • Row-level and table-level locking support
    • Secure connections with SSL, SSH, and HTTP tunneling
  • InterBase/Firebird
    • Advanced BLOB support
    • Streaming (non-caching) BLOB access support
    • Advanced generator support
    • Advanced support for the character set OCTETS
    • Support for the Firebird 2 EXECUTE BLOCK syntax
    • Support for the Firebird 2 RETURNING clause
    • Advanced locking for Firebird 2
    • Automatic updates by DB_KEY unique field for Firebird 2
    • Multiple transactions support with the TUniTransaction component
    • InterBase events support with the TUniAlerter component
    • Comprehensive array data type support
    • Default value support for stored procedures
    • InterBase services components for configuring server parameters and security
    • Support for the Firebird 3 BOOLEAN datatype
    • Support for the Firebird 2.1 trusted authentication
    • Support for InterBase OTW encryption
  • PostgreSQL
    • Advanced sequences support
    • Advanced Large Objects support
    • Ability to control Fetch block size
    • Returning result sets from stored procedures
    • Secure connections with SSL, SSH, and HTTP tunneling
    • Notifications support with the TUniAlerter component
    • Support for PostgreSQL Asynchronous Notification with the TUniAlerter component
    • Supports the possibility of retrieving last inserted OID value
    • Advanced errors support
    • Support for the PostgreSQL notices
  • SQLite
    • Support for all commonly used data types
    • Support for autoincrement fields
    • Possibility to retrieve last auto-incremented value
    • SQLite database encryption in Direct mode using different encryption algorithms
    • Data Type Mapping
    • Support for automatic database creation on connect
    • Support for Shared-Cache mode
    • Support for SQLite user-defined functions
    • Support for SQLite user-defined collations
    • Support for SQLite extensions loading
    • Support for SQLite R*Tree module
    • Support for SQLite FTS3 and FTS4 extensions
    • Support for multi-SQL statements executing
  • MongoDB
    • Support for all commonly used data types
    • Support for native MongoDB query and update commands syntax
    • Support for displaying/modifying documents using regular data-aware controls like TDBGrid
    • Support for simply modifying documents in code using “fluent” interface
    • Support for reading/writing documents in the Extended JSON format
    • Support for working with collections via regular SQL using VirtualDAC
  • DB2
    • Advanced sequences support
    • Schema and function path support
  • DBF
    • Support for a variety of database formats: dBaseIII-dBase10, dBase for Windows, HiPer-Six, FoxPro 2, Visual FoxPro
    • Support for all native data types
    • Support for native dBase functions
    • Support for autoincrement fields
    • Support for .dbt (dBase), .fpt (FoxPro) and .smt (HiPer-Six) MEMOs
    • Support for .mdx (dBaseIV+) and .cdx (Visual FoxPro) indexes
    • Support for index management commands: CREATE/DROP INDEX

Universal Data Access Components 9.1.1 Full Description

Universal Data Access Components (UniDAC) is a library of components that provides direct access to multiple databases from Delphi and C++Builder including Community Edition, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms. Key features: * Data access to all most popular databases * Direct MySQL and PostgreSQL connectivity * Support for Windows, macOS and Linux development * Support for all IDEs, from Delphi 6 up to latest RAD Studio * Best performance and memory management * Timely and professional customer support * On-demand night builds with fixes * Mobile application development * Direct connection in Oracle, SQL Server, ASE, SQLite, and DBF * Data encryption and decryption * DataSet Manager * Source code * Lazarus and Free Pascal support You can always find the latest version of the product on the official Devart website.

Use this library of components in order to access multiple databases directly, from Delphi, C++ Builder, Lazarus and Free Pascal programming environments

What’s new in Universal Data Access Components 9.1.1:

  • The PoolId connection pool option is added
  • Fixed bug with freezing multiply connection pools in threads
  • Fixed bug with leading spaces getting trimmed in strings loaded from XML in VirtualTable
  • Fixed bug with using the AsDate property when working with fields of the ftDate type


Developers who base their work on the Delphi, C++ Builder, Lazarus or Free Pascal programming environments, might, at some point, require to establish a connection to multiple databases.

Relying with databases such as Oracle, Microsoft SQL Server, MySQL, PostgreSQL and others, could be difficult to achieve without a centralized access platform.

Universal Data Access Components was designed precisely with this purpose in mind and it will provide people a way of accessing the aforementioned databases from their preferred programming environment, regardless of their choice.

Developed as a library of components, UniDAC will function on both 32 and 64-bit platforms and it will enable users with universal access to multiple databases.

Offering this unified approach to the database-related applications in the development process, Universal Data Access Components will therefore allow users to easily switch between the different databases when specific characteristics are required.

Featuring a server-independent interface, it will provide people with an efficient way of creating cross-database applications, with outstanding flexibility and independence in their projects.

Being easy to set up, it provides a transparent, server-independent interface that is fully-compatible with the required databases. Choosing the appropriate way of performing server operations, Universal Data Access Components will enable each data provider with server-specific native connectivity.

All the data operations are performed automatically, in accordance with the different database characteristics and particularities.

System requirements


Limitations in the unregistered version

  • 60-day trial

Leave a Reply

Your email address will not be published. Required fields are marked *