Additional
Overview
Features
Try
Discuss
News
Docu
FAQ
Testimonials
Requests
Partners
Firebird Associate
 
Personalized API PDF Print E-mail
Mar 12, 2010

Just because AnyDAC for Delphi provides unified access to different DBMS, that does not mean you need to give up using the powerful and advanced features that make these databases unique ! AnyDAC for Delphi native drivers provide the first class personalized access to the DBMS-specific features.

The Content

 

AnyDAC and Firebird

Firebird with Delphi AnyDAC for Delphi Firebird/Interbase driver supports Firebird specific features, additionally to the general AnyDAC features:

  • Firebird v 1 and up, Interbase v 6 and up, Yaffil.
  • Standalone and Embedded servers.
  • Trusted authentication.
  • Password expiration and changing.
  • 1-3 SQL dialects.
  • All character encodings, including UTF8 and UNICODE_FSS.
  • Binary encoding OCTETS.
  • Multiple transactions, with all varieties of parameter sets.
  • All data types, including BLOB and ARRAY.
  • BOOLEAN domains. Firebird 3.0 and Interbase 7 BOOLEAN data types.
  • RDB$DB_KEY columns for fast data editing and refreshing.
  • RETURNING clause for fast data refreshing.
  • EXECUTE BLOCK statements.
  • Query execution aborting.
  • Array DML with EXECUTE BLOCK utilizing.
  • Stored Procedures. Firebird 3.0 PSQL packaged procedures and PSQL functions.
  • Generators.
  • Events.
  • IBScript SQL script dialect.
  • DB services - backup, restore, validate, security, etc.

 

AnyDAC and MySQL

MySQL with DelphiAnyDAC for Delphi MySQL driver supports MySQL specific features, additionally to the general AnyDAC features

 

  • MySQL v 3.27 and up. 
  • Standalone and Embedded servers. 
  • SSL connections.
  • Password changing.
  • All data types, including BLOBs, ENUM and SET.
  • All character encodings, including UTF8.
  • AUTO_INCREMENT columns and retrieving of last inserted value.
  • Batch commands with multiple result sets.
  • Query execution aborting.
  • Full support for MySQL 5 stored procedures.
  • MySQL SQL script dialect.

 

AnyDAC and Microsoft SQL Server

SQL Server with Delphi

AnyDAC for Delphi SQL Server driver supports SQL Server specific features, additionally to the general AnyDAC features


  • SQL Server 2000 and up.
  • SQL Azure support.
  • LocalDB support.
  • OS authentication (SSPI).
  • Password changing.
  • Application name and workstation identifier.
  • All data types, including SQL_VARIANT, NCHAR, NVARCHAR, XML, CHAR(MAX), VARCHAR(MAX), DATETIME, TIME, DATE2 and UNIQUEIDENTIFIER (GUID).
  • IDENTITY columns and retrieving of last inserted value.
  • Extended metadata to describe fields origin table and column.
  • PRINT / RAISERROR clauses for the database notifications.
  • All cursor types, including client and server side cursor types.
  • Batch commands with multiple result sets. 
  • Query execution aborting.
  • Stored Procedures.
  • Query Notifications, Message Broker Messages.
  • ISQL SQL script dialect.

  

AnyDAC and Oracle Database

Oracle with Delphi

AnyDAC for Delphi Oracle driver supports Oracle specific features, additionally to the general AnyDAC features:


  • Oracle v 8.0.3 and up. 
  • Standard, Express and Instant clients.
  • Multiple Oracle homes.
  • Login as SYSDBA, SYSOPER or by using OS authentication.
  • Password expiration and changing.
  • CLIENT_IDENTIFIER for user identification.
  • All character encodings, including UCS2 and UTF8.
  • All data types, including BLOB, CLOB, BFILE, TIMESTAMP and INTERVAL.
  • Full support for Oracle high precision numbers up to 38 digits.
  • ROWID columns for fast data editing and refreshing.
  • RETURNING clause for fast data refreshing.
  • SELECT FOR UPDATE clause.
  • Varieties of CURSOR types, including SELECT CURSOR (…) and REF CURSOR.
  • Stored Procedures, including PL/SQL packaged procedures.
  • Stored procedure RECORD OF and BOOLEAN parameter types.
  • DBMS_OUTPUT for the database notifications.
  • Query execution aborting.
  • Sequences.
  • Events, including DBMS_ALERT and DBMS_PIPE.
  • SQL*Plus SQL script dialect.

  

AnyDAC and PostgreSQL

PostgreSQL with Delphi

AnyDAC for Delphi PostgreSQL driver supports PostgreSQL specific features, additionally to the general AnyDAC features:


  • PostgreSQL v 7.3 and up. 
  • SSL connections.
  • Password expiration and changing.
  • All character encodings, including UTF8.
  • All simple data types, including ENUM, TIMESTAMP, INTERVAL.
  • All structured data types, including ADT, Custom Defined, Array.
  • Large Object data types.
  • Full support for PostgreSQL high precision numbers up to 1000 digits.
  • SERIAL columns and retrieving of last inserted value.
  • OID columns for fast data editing. 
  • RETURNING clause for fast data refreshing.
  • Varieties of CURSOR types and multiple cursors per statement.
  • Query execution aborting.
  • Stored Procedures, including PostgreSQL 9.0 named parameters.
  • PostgreSQL 9.0 anonymous blocks.
  • Sequences.
  • Notifications.

 

AnyDAC and SQLite

SQLite3 with Delphi

AnyDAC for Delphi SQLite driver supports SQLite specific features, additionally to the general AnyDAC features:


  • SQLite v 3.0 and up.
  • Oracle Berkeley DB v 5 and up in SQL mode.
  • Static (no DLL's is needed) and Dynamic linking with Delphi application.
  • AES 128/192/256 bit database encryption.
  • Data type "smart" recognition.
  • Data type specialization (col::datatype). 
  • All character encodings, including UTF8, UTF16, ANSI.
  • Custom functions. Preinstalls all local expression engine functions (~50) into SQLite.
  • Custom collations. Preinstalls ANSI and Unicode collations.
  • OnProgress, OnAutorize, OnUpdate callbacks.
  • Database events, simulating Firebird events.
  • Auto incrementing columns and retrieving of last inserted value.
  • Batch commands with multiple result sets. 
  • Query execution aborting.
  • DB services - backup, security, etc.

 

AnyDAC and Sybase SQL Anywhere

SQL Anywhere with Delphi

AnyDAC for Delphi SQL Anywhere driver supports SQL Anywhere specific features, additionally to the general AnyDAC features:



  • SQL Anywhere v 5 and up.
  • All connection types.
  • All data types, including BLOB's.
  • IDENTITY columns and retrieving of last inserted value.
  • MESSAGE and message callback.
  • Batch commands with multiple result sets. 
  • Query execution aborting.
  • Stored Procedures.
  • DB tools - backup, validate, etc.

AnyDAC and Microsoft Access database

MS Access with DelphiAnyDAC for Delphi Microsoft Access driver supports MS Access specific features, additionally to the general AnyDAC features

 

  • Microsoft Access 2000 and up.
  • Password protected databases.
  • Readonly databases.
  • Unicode data.
  • All data types, including BLOB's.
  • IDENTITY columns and retrieving of last inserted value.
  • Multivalued columns.
  • Compacting and repairing the database.
  • DB services - create, compact, repair.

 

AnyDAC and IBM DB2 Server

IBM DB2 with DelphiAnyDAC for Delphi DB2 Server driver supports DB2 specific features, additionally to the general AnyDAC features:

 

  • IBM DB2 Server v 8 and up.
  • Alias or direct connections.
  • Unicode data.
  • All data types, including BLOB's.
  • IDENTITY columns and retrieving of last inserted value.
  • FINAL TABLE clause clause for fast data refreshing.
  • Stored Procedures.

 

AnyDAC and Advantage Database

Advantage with Delphi                    AnyDAC for Delphi Advantage driver supports Advantage DB specific features, additionally to the general AnyDAC features:

  • Advantage Database v 8 and up.
  • Remote and Local servers.
  • Password changing.
  • All character encodings.
  • Nested transactions.
  • All data types, including MEMO and BLOB.
  • Auto-incrementing columns.
  • ROWID columns for fast data editing and refreshing.
  • Query execution aborting.
  • Array DML.
  • Stored Procedures.
  • Events (notifications).
  • DB services - backup, restore, validate, security, etc.

 

AnyDAC and DataSnap server

DataSnap with Delphi                                              AnyDAC for Delphi DataSnap driver supports DataSnap specific features, additionally to the general AnyDAC features:

  • DataSnap servers built with RAD Studio 2007 and up.
  • HTTP, HTTPS and TCP/IP protocols. 
  • Authentification.
  • Server methods.
  • Server methods metadata.
  • Server methods returning datasets.