Article

From:
To:
All
Subject:
8.1 update (8.10.0.26) is now available
Newsgroup:
advantage.announcements
 

8.1 update (8.10.0.26) is now available

An 8.1 service update (8.10.0.26) has been posted to the Developer's Zone 
download area at http://devzone.advantagedatabase.com/dz/content.aspx?key=20&Release=10

This Service Update of the Advantage .NET Data Provider addresses the
following issues:

  Fixed an issue in the .NET Data Provider where numeric parameter   values would cause Invalid DbType exceptions when integer values   were used.
This Service Update of the Advantage Advantage Client Engine (ACE) addresses the following issues:
  Fixed an issue that could lead to a local server exception if an   application created an index in one thread and then performed a   seek on the new index in a second thread.
  Fixed an issue where opening a table without an active connection   could cause SQL queries run on the table's connection to fail.
  Fixed an issue where the [ character is not recognized as a   delimiter in the SQL statement.
  Fixed an issue where the auto-create index functionality may fail   on encrypted tables.
  Fixed an issue where the Advantage Client Engine (ACE) would   create Windows dump files even if users had not explicitly enabled   them.
  Fixed an issue that caused static cursors (from SQL queries) to be   fully populated during the commit of a transaction.
  Fixed an issue in the server where AdsDDDeployDatabase fails when   the data dictionary contains scripted stored procedures.
This Service Update of the Advantage Data Architect (ARC) addresses the following issues:
  Fixed an issue where the Advantage Data Architect environment   check utility would hang every time it was run.
  Fixed an issue where the Advantage Data Architect would open new   DBF tables as free tables if opened directly after creating the   new table on a dictionary-bound connection. If subsequent changes   were then made to the table structure, the structure stored in the   dictionary would not be correctly maintained.
  Fixed 5018 error when importing DBF/NTX tables.Improved the   handling of numeric values less than 0.000050 when importing into   ADT tables with numeric fields.
  Fixed an issue that prevented the Advantage Data Architect context   sensitive help from working.
  Fixed an issue where replicating an exiting user's permissions   when creating a new user in Advantage Data Architect would result   in an exception.
  Fixed an issue where pressing the ENTER key on a table object in   the Advantage Data Architect Connection Repository would not open   the table.
  Fixed an issue where the Advantage Data Architect import   functionality would import memo fields incorrectly, assigning a   different data type to the field.
This Service Update of the Advantage Crystal Reports Driver addresses the following issues:
  Fixed issue in the Crystal Reports driver where temporary tables   created on an external connection passed into the driver could not   be enumerated by the Crystal engine at runtime.
  Fixed an issue where the Crystal Reports Driver quit correctly   parsing <CRWDC> from the front of connection strings.
This Service Update of the Advantage JDBC Driver addresses the following issues:
  Fixed an issue in JDBC driver where a NullPointerException is   thrown during failed connection attempts.
This Service Update of the Advantage ODBC Driver addresses the following issues:
  Fixed an issue in the ODBC driver where calling the SQLNativeSql()   API would cause access violation in the application.
This Service Update of the Advantage TDataSet Descendant and Advantage Delphi Components addresses the following issues:
  Added support for CodeGear RAD Studio 2007.
  Fixed an issue where a 5022 error was raised in a Delphi   application if the dataset's sequenced property was true and a   grid scrollbar was used to change the dataset position.
  Fixed an issue where a SELECT statement with very few fields   (select field1 from table) can cause an access violation if using   the Advantage TDataSet Descendant for .NET.
This Service Update of the Advantage Visual Objects RDDs addresses the following issues:
  Updated VO SQL drivers to re-execute static queries if the   Refresh() method is called.
  Fixed an issue in the VO SQL drivers where the alias and filespec   information was incorrect or missing.
  Fixed an issue in the VO drivers where appending a new record on a   view to a linked data dictionary could fail.
This Service Update of the Advantage Database Server for Windows, Advantage Database Server for NetWare, the Advantage Database Server for Linux, and the Advantage Local Server addresses the following issues:

  Fixed an issue where retrieving the execution plan of an SQL   statement with non-correlated subquery would never return.
  Fixed an issue where an SQL statement with TOP X and ORDER BY on   an aggregated column in the subquery would return incorrect   result.
  Made improvement to the SQL query optimizer to generate more   efficient execution plan for certain data distributions.
  Fixed an issue where it was possible for Advantage Database Server   to produce an access violation if a table that has more than 15   FTS (full text search) indexes is used in an SQL query with the   CONTAINS() scalar function.
  Improved the performance of queries on the system.triggers view.
  Fixed an issue in SQL script execution where FETCH would not work   correctly if the cursor is defined with a SELECT statement with   UNION ALL.
  Fixed an issue in the SQL engine where the server would crash if   the SQL statement contains a subquery with ORDER BY clause that   has outer reference.
  Fixed an issue where the ADS NetWare NLM could cause a CPU HOG   ABEND with certain SQL queries.
  Modified query engine to update the stmt.updatecount to account   for the updates performed inside the EXECUTE IMMEDIATE statement.
  Fixed an issue in the query engine where an error is returned when   retrieving the execution plan of an SQL statement that uses UDF   that returns data, time or timestamp result.
  Fixed an issue where the 2232 error would be return when   performing a division with fixed-point numeric values.
  Fixed an issue in the query engine where 2122 error would be   returned with an UPDATE statement when a table in the FROM clause   references a table in a linked data dictionary.
  Fixed an issue in the query engine where the 2119 (Internal Error)   is returned when executing an UPDATE statement that use INNER JOIN   in the FROM clause and a scalar function is part of the join   condition.
  Fixed an issue that could cause server crash when an SQL script is   executed multiple times and the results of the executions are not   consistently success or failure.
  Reduced memory usage by the SQL parser.
  Modified the server to no longer log 7042 and 7047 errors.
  Modified the ALTER TABLE and restructure functionality to be more   tolerant of DBF tables that do not have field definitions that   match those in the data dictionary. This helps avoid 5041errors   during restructure and ALTER operations.
  Modified the server for Linux to run using a user-specified user   account.
  Fixed an issue where an invalid data dictionary temporary path   would cause logins to fail.
  Modified server to no longer log 8007 errors when an IPX stack is   not available.
  Fixed an issue where backup and/or restore operations on a   directory of free tables would log 7016 and 7014 errors if the   directory contained both ADT and DBF tables. Added a new   TableTypeMap option to allow users to map table extensions to   table types. For example: EXECUTE PROCEDURE sp_RestoreFreeTables(   :srcpath, :destpath, 'tabletypemap=adt=ads_adt,dbf=ads_cdx', NULL   );
  Lowered internet and LAN timeout defaults from 10 minutes to 2   minutes, which also increases the keep alive packet frequency.
  Fixed an access violation in Advantage Local Server when trying to   connect on Windows 98 computers.
  Fixed an issue where a corrupt record count in a table header   could cause Advantage to allocate a very large chunk of memory.
  Fixed an issue where updating a DBF table with a free connection   after the DBF had been updated on a dictionary connection would   cause an access violation in the server if the DBF table had   triggers.
  Fixed an issue where errors various problems (generally connection   related) occur if both the client and the server running Advantage   Database Server have the same host name. If the problem occurred   when using replication, 9087 and 9040 errors could be generated.
  Fixed an issue where the Advantage Local Server would modify the   working set size of the process that loaded it. This could result   in a variety of "out of resource" errors.
  Modified the server to not allow restructuring of tables which   have pending replication updates in a subscription queue.
  Fixed an issue where restoring a database over existing tables   with RI and triggers could cause the triggers to fire.
  Fixed an issue in the server where aborting an automatic rebuild   of a corrupted index could cause an internal error.
  Fixed an issue where the Advantage Configuration Utility would   appear hung when stopping the Advantage Database service.
  Fixed an issue where backup and restore commands would not copy   trigger and Advantage Extended Procedure (AEP) DLL files.
  Fixed an issue where a 9003 error would be logged and the crash   dump generated when the server logs out an inactive user.
  Changed sp_GetSQLStatements to show progress information based off   an individual query, instead of the query currently being   executed.
  Fixed an issue where if the server was automatically reindexing a   corrupt index, it would not allow any other users to connect or   open tables for the duration of the reindex operation.
  Fixed an issue where some SQL queries with WHERE clauses exceeding   65536 bytes in length could result in 7207 and 5005 errors.
  Fixed an issue where non-unique rowversions where generated.
  Fixed an issue where a failure writing to the replication queue   would cause the commit of a transaction to fail.
  Fixed an issue where a rare race condition in referential   integrity operations could cause logical index corruption.
  Fixed an issue where local server could cause index corruption if   using AdsExtractKey, AdsGetRelKeyPos, or referential integrity.   If one of the APIs was called, then an index update was performed   in a separate work area, then the original work area performed a   key update/delete operation, an out of date cached page was used   causing index corruption.
  Fixed an issue where creating a new replication subscription   failed with error 5132 (AE_INVALID_OBJECT_NAME).
  Fixed an issue where the automatic rebuild of a corrupted FTS   (full text index) index would not contain all of the FTS metadata   and resulted in 9123 errors.
  Fixed an issue where abandoned shared memory connections were not   always cleaned up by the watch dog process.
  Fixed an issue that caused 9.0 clients to receive 6633 errors   (instead of 6316) when attempting to connect to 8.1 servers.
  Fixed an issue where selecting the MAX rowversion could return an   incorrect result.
  Fixed an issue where the server would log a 9051 error and create   a crash dump file when there was an AFTER DELETE trigger on a   table that had a self-referencing RI rule and the trigger modified   a record that would later be deleted in the cascade.
  Fixed an issue that caused 9021 errors to be logged when   performing an online backup of a DBF table with the newer style   Visual FoxPro 4-byte memo field.
  Modified the server to log an informational error (7154) if it   automatically reindexes a table after detecting corruption.
  Modified the server to respect the AdsDisableRI API when creating   new RI (referential integrity) rules.
  Fixed a 3011 error returned to Clipper applications when using   index keys that must be generated on the client.
  Fixed an issue where a 7068 error was returned when using an index   on an encrypted free table when the password is not set.
  Added limit to the cache subsystem to use no more than 256MB of   memory when no configuration is specified.
  Fixed an access violation on Windows Small Business Server 2003   when Data Execution Protection (DEP) is enabled on the Advantage   Database Server executable.
FYI: Phrase searches are enclosed in either single or double quotes
 
 
Originally created by
Tamarack Associates
Fri, 29 Mar 2024 10:08:51 UTC
Copyright © 2009-2024
HREF Tools Corp.