Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.

ID: 27123, Universal Data Access Components

by Dmitry Nikolaenko Email: Anonymous

Provides high performance direct access to Oracle, Microsoft SQL Server, MySQL, PostgreSQL, SQLite, InterBase, and Firebird databases.
Download Details
FTP  download also available
CDN Login Required to Download. (You will be redirected to the login page if you click on the Download Link)
To download this, you must have registered:
A free membership

For Delphi, Version 6.0  to 14.0 493 downloads
Copyright: All rights reserved

Size: 5,352,392 bytes
Updated on Mon, 17 Aug 2009 03:42:02 GMT
Originally uploaded on Mon, 03 Aug 2009 08:02:31 GMT
SHA1 Hash: 3A4026208E5C102E7111D159DAE0637E805BFF60
MD5 Hash: 8B23390009296DA298D5818D91970141

    Explore the files in this upload

Universal Data Access Components (UniDAC) is a powerful library of nonvisual
cross-database data access components for Delphi, Delphi for .NET,
and C++Builder. We have combined the experience of long-term successful
development into one product, which provides unified access to the popular
database servers like Oracle, Microsoft SQL Server, MySQL, PostgreSQL, SQLite, InterBase, and Firebird.

UniDAC offers unified approach to the database-related applications development
process. That means you can switch easily between different databases in your
projects without going deep into their specifics.

Using UniDAC with its server-independent interface is the best way
to create cross-database applications. UniDAC gives outstanding
flexibility and independence to your projects.

UniDAC includes the following components:

TUniConnection - lets you set up and control connections to different servers
TUniTransaction - provides discrete transaction control over sessions. Can be used to manipulate both simple and distributed transactions for certain providers
TUniQuery - uses SQL statements to retrieve data from tables and pass it to one or more data-aware components through a TDataSource object. This component provides a mechanism for updating data
TUniTable - lets you retrieve and update data in a single table without writing SQL statements.
TUniStoredProc - executes stored procedures and functions. Lets you edit cursor data returned as parameter
TUniSQL - executes SQL statements and stored procedures, which do not return datasets
TUniScript - executes sequences of SQL statements and provides control over the execution process
TUniMetaData - allows to retrieve comprehensive metadata on the specified SQL object
TUniUpdateSQL - lets you tune update operations for a DataSet component
TUniDataSource - provides an interface for connecting data-aware controls on a form and UniDAC dataset components
TUniSQLMonitor - interface for monitoring dynamic SQL execution
TUniConnectDialog - allows you to build custom prompts for provider name, server name, port number, database, user name, and password
TInterBaseUniProvider - links the InterBase provider to an application
TMySQLUniProvider - links the MySQL provider to an application
TOracleUniProvider - links the Oracle provider to an application
TSQLServerUniProvider - links the SQL Server provider to an application
TPostgreSQLUniProvider - links the PostgreSQL provider to an application
TSQLiteUniProvider - links the SQLite provider to an application
TVirtualTable - provides dataset functionality for data that has no real database connection. This component is placed on the Data Access page of the Component palette, not on the UniDAC page
TCRBatchMove - transfers data between all types of TDataSet descendants. This component is placed on the Data Access page of the Component palette, not on the UniDAC page

Using Universal Data Access gives you the following advantages:

- Support for most popular databases
- Full support for the latest server versions
- Support for the latest IDE versions
- VCL and VCL.NET versions of library available
- High performance
- Easy to deploy
- Support of all standard and third-party data-aware controls
- Advanced connection management
- Flexible data updating
- UniScript component for scripts execution
- Ability of monitoring commands execution
- Advanced connection pooling
- Unicode and national charsets support
- Includes database-independent data storage
- CachedUpdates operation mode
- Local sorting and filtering by calculated and lookup fields
- Local master/detail relationship
- Ability to retrieve metadata information
- Support for using macros in SQL
- Customizable connection dialog
- Advanced design-time editors


UniDAC supports:
Oracle servers: 11g, 10g, 9i, 8i, 8.0, and 7.3, including Oracle 10g Express, Oracle 8i Personal, and Lite editions.
Oracle x86 clients: 11g, 10g, 9i, 8i, 8.0, and 7.3.

Servers: SQL Server 2005 (including Compact and Express editions), SQL Server 2000, SQL Server 7, and MSDE.
Clients: SQL OLE DB and SQL Native Client.

MySQL servers: 5.1, 5.0, 4.1, 4.0, and 3.23.
MySQL Embedded servers: 5.1, 4.1, and 4.0.
MySQL clients: Direct mode, 5.1, 5.0, 4.1, 4.0, and 3.23.

PostgreSQL server versions since 7.1 up to 8.3.

SQLite server version 3.

InterBase: versions 5.x and higher.
Firebird: versions 2.x, 1.x.

The following development environments are supported by UniDAC:
Embarcadero Delphi 2010 for Win32
Embarcadero C++Builder 2010
CodeGear Delphi 2009 for Win32
CodeGear C++Builder 2009
CodeGear RAD Studio 2007
CodeGear Delphi 2007 for Win32
CodeGear C++Builder 2007
Turbo Delphi Professional
Turbo Delphi for .NET Professional
Turbo C++ Professional
Borland Developer Studio 2006 including support of Delphi for Win32, Delphi for .NET, and C++Builder personalities
Borland Delphi 2005
Borland Delphi 7
Borland Delphi 6
Borland C++Builder 6

For more information, see

   Latest Comments  View All Add New

Move mouse over comment to see the full text

Could not retrieve comments. Please try again later.

Server Response from: ETNACDC04