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
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
ADMonitor was closed in the middle
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
asObjNotExists
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
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
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
at connecting to a database
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
different datasets
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.