Skip site navigation (1) Skip section navigation (2)

DA-SOFT AnyDAC 4.0.5 released

Posted on Dec. 9, 2010

DA-SOFT Technologies announces the immediate availability of "AnyDAC for Delphi" Winter 2010 release v 4.0.5.1605.

Version Highlights

==================

* Major rework of the help system. A lot of new "Developer Guide" articles.

* Multiple additions and changes to the Service components.

* Multiple optimizations of the PostgreSQL, SQLite, Firebird drivers and the general dataset code.

* Improved SQL Server, PostgreSQL and Informix support.

* Added mkCatalogs and mkSchemas metacommands.

* Added EhLib support.

And more. Please, check the detailed change log at bottom.

AnyDAC for Delphi

=================

AnyDAC is an unique set of Universal Data Access Components for developing applications on Delphi, C++Builder and Free Pascal. With its powerful common architecture AnyDAC enables native high-speed direct access to Firebird, SQLite, MySQL,

MS SQL Server, Oracle, PostgreSQL, IBM DB2, SQL Anywhere, MS Access, Informix and more. For complete list of features and availability, please check:

* AnyDAC home - http://www.da-soft.com/anydac/

* AnyDAC shop - http://www.da-soft.com/anydac/order.html

* AnyDAC trial - http://www.da-soft.com/anydac/download.html

AnyDAC Core Features

====================

* Native access to PostgreSQL, Firebird, MySQL, MS SQL Server, Oracle, SQLite, DB2, InterBase and more. Including latest DBMS versions.

* Optimized for best possible performance (2 times faster than dbGo, 25% faster than dbExpress).

* Generic access to any database supported through dbExpress and ODBC data sources.

* Reach API, including 50 Delphi VCL components.

* Unified API for access to cross-database features.

* First-class support for many database-specific features, including DBMS services like backup, validate.

* Unique ADO.NET-like data engine for Win32.

* Advanced Data Access Options.

* Full support for international applications, including full Unicode support in Delphi 2009 and later.

* Cross-platform support though Free Pascal (FPC).

* Perfect integration as back-end driver for TMS AdvGrid, RemObjects Data Abstract, Fast Report, C4D kbmMW and more.

AnyDAC Natively Supported Databases

===================================

* Enterprise - Oracle, MS SQL Server, IBM DB2.

* Workgroup - PostgreSQL, Firebird, MySQL, SQL Anywhere, Interbase, Advatage DS.

* Database in clouds - Microsoft SQL Azure.

* Desktop - SQLite, MS Access, BlackFish SQL, MS SQL CE.

* Embedded - SQLite, Firebird Embedded, MySQL Embedded.

* Bridges - DbExpress, ODBC.

Newsletters

===========

To subscribe to the newsletter with the AnyDAC release notifications and other DA-SOFT Technologies product and company news, you can create an account at DA-SOFT web site, then go to your user profile and set "Subscribe to newsletters" to "Yes".

Change Log

==========

v 4.0.5.1605 (24.11.10)

  • added: SQLite: TADSQLiteValidate component

  • added: SQLite: SharedCache connection definition parameter

  • added: ADTable: Open(ATableName) method

  • added: Phys: MetaCurSchema / MetaCurCatalog = '*' avoids implicit inclusion of schema / catalog names into full object name

  • added: mkCatalogs, mkSchemas meta data kinds and GetCatalogNames, GetSchemaNames methods

  • added: base x64 support

  • added: AddOn: EhLib support

/ updated: Help: major cleanup and multiple extensions

/ updated: ADDataSet: major optimization

/ changed: DatS: optimized view building code

/ changed: IB: optimized driver code

/ changed: DatS: improved fetch performance

/ changed: PgSQL: improved fetch performance

/ changed: AddOn: updated SQL Ini File

/ changed: DBX: added AnyDAC_DBX define to control AnyDAC linking to dbExpress

/ changed: multiple extensions and changes to AnyDAC service components

/ changed: SQLite: optimized build defines

/ changed: ADManager: the GetDriverNames method now has AValidate, allowing to check is the DBMS CLI installed and it may be loaded

  • fixed: SQLite: few multi-threading issues in encryption code

  • fixed: SQLite: does not use TFormatOptions.StrsTrim and StrsEmpty2Null

  • fixed: SQLite: "Cannot rollback transaction - SQL statements in progress" on Rollback with active result sets

  • fixed: SQLite: CheckEncryption fails to validate DB. Also, improved reporting.

  • fixed: SQLite: TADSQLiteSecurity.RemovePassword was not working

  • fixed: MSSQL: "The data types varbinary(max) and image are incompatible in the equal to operator"

  • fixed: MSSQL / ASA: "No column was specified for column 1 of 'A'." on a query with RecsMax specified

  • fixed: MSSQL: "invalid object name" on SELECT FROM ::fn_xxxx()

  • fixed: MSSQL: MARS is always enabled for a connection and cannot be disabled

  • fixed: PgSQL: returns incorrect value for TIMESTAMPTZ columns

  • fixed: PgSQL: escape functions CURDATE, CURTIME, NOW does not work

  • fixed: PgSQL: AV when fetching UTF8 string with mapping WideString -> AnsiString

  • fixed: PgSQL: fails to edit query with ONLY keyword

  • fixed: IB/FB: fails to use quoted identifiers

  • fixed: FB/IB/MySQL: possible AV at application exiting, when using embedded engines

  • fixed: Oracle: fails to execute AnyDAC QA scripts

  • fixed: Oracle: a failed execution in autocommit mode leads to an active transaction

  • fixed: DB2: fails to fetch meta data after SET SCHEMA=xxx command

  • fixed: ASA: fails to execute stored proc with inout params in a loop

  • fixed: ADS: memory corruption at metadata retrieval

  • fixed: MSAccess: does not support ` and " as object name quote chars

  • fixed: Informix: exception is not raised on posting update using invalid SQL in TADUpdateSQL

  • fixed: ODBC: improved compatibility with old drivers

  • fixed: ODBC: does not recognise ADS DSN as mkADS

  • fixed: ODBC: fails to execute PostgreSQL parameterized query

  • fixed: Stan: AV is possible on application exiting

  • fixed: Phys: Memo -> String mapping is completely broken

  • fixed: Phys: transaction properties are not updated after reconnection

  • fixed: Phys: MetaDefXxx and MetaCurXxx are not visible in connection editor

  • fixed: Phys: issues with executing COMMIT / ROLLBACK commands directly

  • fixed: Tracing: impossible to set TADMoniXxxClientLink.Tracing to True at design-time

  • fixed: ADDataSet: SaveToStream does not store field captions

  • fixed: ADDataSet: Refresh on indexed detail dataset empties dataset

  • fixed: ADDataSet: BeforeGetRecords / AfterGetRecords does not fire for async queries

  • fixed: ADDataSet: AV is possible on ADConnection destroying

  • fixed: ADDataSet: refresh on detail dataset does not work if master dataset is in editing / inserting state

  • fixed: ADDataSet: after deletion of last fetched record the query position may change to next+1 record

  • fixed: ADDataSet: AV at assigning empty string to TGuidField

  • fixed: ADDataSet: setting UpdateOptions.CheckRequired to False after Open and before Append has no effect

  • fixed: DApt: fails to edit dataset with quoted field names

  • fixed: Query Editor may hang up at design-time

  • fixed: DatS: BeginBatch / EndBatch fails with unidirectional query

  • fixed: GUIx: connection editor fails to store database path

  • fixed: GUIx: few ADUpdateSQL editor issues

  • fixed: GUIx: wrong help link

  • fixed: ADConnection: possible AV at application exiting

  • fixed: AnyDAC fails to install on Delphi XE Professional

  • fixed: memory leak is possible on application exiting

  • fixed: Demo: TADEventAlerter demo was broken

  • fixed: D5: major incompatibility

--

With best regards,

DA-SOFT Technologies Team

http://www.da-soft.com

This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.


Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group