AnyDAC Summer 2011 v 5.0.1 released

DA-SOFT Technologies announces the immediate availability of "AnyDAC for Delphi" Summer 2011 release v 5.0.1.1835.

Version Highlights

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

* New Advantage Database native ACE API driver

http://www.da-soft.com/blogs/anydac-for-delphi-advantage-database-support.html

* New TADTable with live data window mode

http://www.da-soft.com/blogs/anydac-tadtable-with-live-data-window.html

* Major refactoring of the drivers infrastructure.

* Major refactoring of the monitoring and tracing infrastructure.

* New FormatOptions.FmtDisplayXxx и FmtEditXxx options.

* New ADConnection Before/After StartTransaction, Commit, Rollback events.

* Multiple enhancements to the help system.

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 PostgreSQL, Firebird, SQLite, MySQL, MS SQL Server, Oracle, IBM DB2, SQL Anywhere, MS Access, Informix, Advantage DB 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 DB.

* Database in clouds - Microsoft SQL Azure.

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

* Embedded - SQLite, Firebird Embedded, MySQL Embedded, Berkeley DB.

* 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".

Follow us on:

* Twitter - http://twitter.com/#!/da_soft

* Facebook - http://www.facebook.com/#!/pages/Da-Soft-Technologies/141014252640000

Change Log

==========

v 5.0.1.1845 (04.07.11)

/ changed: ADDataSet: expression based indexes now are using locale and sort options

• fixed: ADDataSet: expression based indexes are broken

• fixed: Demos: few demo projects fails to compile

• fixed: ADTable: when GotoKey returns False, then ADTable records are corrupted

• fixed: Phys: connection pooling is broken

• fixed: Stan: enXxxx encodings renamed to ecXxxx to avoid conflicting with Indy in C++Builder

• fixed: Stan: AV at converting ' 0 ' to TBcd

v 5.0.1.1835 (27.06.11)

More about major changes:

1) Advantage driver:

http://www.da-soft.com/blogs/anydac-for-delphi-advantage-database-support.html

2) TADTable with live data window:

http://www.da-soft.com/blogs/anydac-tadtable-with-live-data-window.html

3) Other changes:

http://www.da-soft.com/blogs/anydac-5.0-other-changes.html

• added: ADS: native Advantage Database ACE API driver

• added: ADTable: new implementation with live data window,

FormatOptions.SortLocale and SortOptions options,

TADFetchOptions.LiveWindowMode option to control live data window

performance

• added: GUIx: IADGUIxWaitCursor.ForceStopWait method

• added: Oracle: TADPhysOraclDriverLink.VendorHome design-time editor

• added: MSAccess: StringFormat connection def parameter

• added: Stan: UpdateOptions.CheckReadOnly property

• added: ADDataSet: set of FormatOptions.FmtDisplayXxx and FmtEditXxx

options to specify the default fields display and edit format

• added: ADConnection: Before/After StartTransaction, Commit, Rollback

events

/ changed: DFMChanger: added exit code, ability to add, multiple units,

renamed to ADDFMChanger

/ changed: Moni: major refactoring of Stan, Phys and Moni interaction

(removed ADSettings from ADConnectionDefs.ini, removed implicit monitor

activation - now only by TADMoniXxxxClientLink.Tracing, added ability to

turn on / off Tracing, added initial state to MonitorBy, extended connection

info)

/ changed: ADConnection: major refactoring of GetInfoReport (new

declaration, extended information, driver loading reports, session analysis

reports)

/ changed: Phys: major refactoring of the IADPhysManager and IADPhysDriver

infrastructure (removed packaged drivers support, removed unloading of

inactive drivers, CLI library loading moved from driver constructor to Load

method, etc)

/ changed: DApt: "command updated [n] records instead of [1]" now contains

optional DBMS warning message

/ changed: Lazarus: reworked Lazarus / FPC documentation

/ changed: MSSQL: updated event alerter

/ changed: ADManager: allowed to have few TADManager's at design-time

• fixed: Phys: tab character was specified as #7 instead of #9

• fixed: Phys: TADEncoder.Encode / Decode may fail with

ERROR_INSUFFICIENT_BUFFER when ADest address > 3Gb

• fixed: Phys: empty string data's may be returned on UTF8 data sources

• fixed: Phys: FormatOptions.StrsEmpty2Null=False does not work for

strings longer than FormatOptions.InlineDataSize

• fixed: Phys: AV possible on a connection recovering

• fixed: Phys: AV at converting ' 0' to TBcd

• fixed: Phys: event alerter may raise "connection is active" exception on

pooled connection

• fixed: Phys: "manager shutdown timeout" when MonitorBy=Remote and

ADMonitor was closed in the middle

• fixed: Phys: "manager shutdown timeout" when ADQuery + ADTransaction +

DataSnap

• fixed: Oracle: dtXxxMemo -> dtXxxString mapping rule fails

• fixed: Oracle: fails to call a ADStoredProc for a SP with db link

• fixed: Oracle: memory leak at preparing stored ADStoredProc referencing

to a public alias

• fixed: Oracle: fails to recognize "sequence does not exist" as

asObjNotExists

• fixed: Oracle: setting TxOptions.AutoStop=False and AutoStart=True does

not mark a transaction started on first DML command

• fixed: ASE: fails to post updates to table with a NUMERIC(6) column

• fixed: MSSQL: AV in GetFieldNames on a table with long (> 300 chars)

comments or default values

• fixed: MSSQL: SQL State 08S02 is not recognized as ekServerGone

• fixed: MSSQL: fails to get metainformation, depending on server

collation

• fixed: MSSQL: fails to send VARCHAR(MAX) (ftString with Size=MAXINT)

parameter to server

• fixed: FB: EventAlerter may raise "Error writing data to the connection"

• fixed: FB: mkTables with TableKinds=tkTable returns views too

• fixed: FB: "database @1 already exists. To replace it, use the -REP

switch" on TADIBRestore with roReplace

• fixed: FB: does not recorgnize "deadlock update conflicts with

concurrent update" as ekRecordLocked

• fixed: FB: CreateDatabase=Yes ignores CharacterSet

• fixed: FB: "unsuccessful metadata update" error on auto Commit does not

close transaction

• fixed: FB: milliseconds are dropped from dtTime values

• fixed: IB: demo DB fails to install on IB7, 2007, 2009

• fixed: PgSQL: "range check" on ftString parameter with Size >= 40000

• fixed: PgSQL: AV on SQL executing with DirectExecute=True and tracing

enabled

• fixed: PgSQL: "invalid input syntax for type timestamp with time zone"

at connecting to a database

• fixed: PgSQL: fails to recognize "password authentication failed for

user" as ekUserPwdInvalid

• fixed: PgSQL: ADScript does not support $$ quoted string

• fixed: Sybase ASE: fails to transfer SQL_C_DECIMAL value to a DB

• fixed: SQLite: when Encrypt condef parameter is specified, then

Password=xxx and NewPassword= does not work

• fixed: MSAccess: {fn CONVERT(..., VARCHAR)} does not work

• fixed: MSAccess: fails to work with BOOLEAN columns

• fixed: ADQuery: FieldDefs may not refresh after changing SQL

• fixed: ADQuery: AV when uADStanAsync is not linked

• fixed: ADDataSet: an exception raised while refreshing dataset may be

hidden

• fixed: ADDataSet: TADIndex.Assign(TADIndex) fails when indexes belong to

different datasets

• fixed: GUIx: Query Editor does not show precision and scale for non

floating point fields

• fixed: DataSnap: AV in CDS when reading ftWideMemo TADQuery field

• fixed: Lazarus: some demos fail to compile

• fixed: Lazarus: Async Dialog has invalid layout

• fixed: Lazarus: TADConnection.LoginDialog is not published

• fixed: Lazarus: TADConnection.Offline does not work

• fixed: Lazarus: *.lfm, *.lrs files from Source folder are missed

• fixed: C++ Builder: incompatibility with BCB6

• fixed: ADMonitor: does not show ekComponent output

• fixed: ADExplorer: cannot edit connection definition

• fixed: ADExplorer: "step" in SQL scripts executes current and next

commands when first command fails

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.