AnyDAC Features

Native access

• IBM DB2 Server
• Interbase or Firebird Server
• Microsoft SQL Server
• MS Access database
• MySQL Server
• Oracle Server
• Sybase SQL Anywhere

Generic access

• dbExpress data sources
• ODBC data sources

Unification

• Data Types
• SQL dialects
• SQL script dialects
• Data editing
• Error reporting
• Quoted Identifiers
• Transaction Support

Personalization

• MS SQL Server
• Oracle Server
• MySQL Server

Performance

• Rowset Fetching
• Array DML Execution
• Command Batches
• Asynchronous Command Execution
• Metadata Caching
• Update Commands Caching
• Direct mode

Advanced

• Options System
• Automatic connection recovery
• Disconnected connection mode
• Dataset persistance
• International applications

Cross Platform support

• Delphi on Win32
• C++Builder on Win32
• FreePascal & Lazarus on Win32

Data Abstract

Other

• Dataset advanced API (LocateEx, LookupEx)
• Phys and DatS programming
• Utilities
• Monitoring and tracing