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.