BEFORE upgrading from Medisoft 15 to 16, make sure you upgrade your Advantage Database from 9.0.x to 9.1.x:

Free Advantage 9.1 upgrade

Currently version 9.10.0.21 is the latest.

 

For Medisoft Network Professional users, it's best to update your Advantage Database Server just like you would update Windows or even Medisoft itself.

It's fairly easy to update Advantage Database, follow these steps:

  • Download the latest Advantage that works with your system.  It is most likely going to be named adswin_x86_32.exe  (if you're not sure, don't do it!)
  • Make a note of your Advantage SN# and other configuration settings (in case you need them)
  • Stop your Advantage Database Server
  • Extract and run the Advantage file you downloaded earlier

 

 

Start, Programs, Advantage Database Server, Advantage Database Configuration Utility

Then click on the Installation Info tab:

advantage-configuration-utility-installation-info.png

This Service Update of the Advantage Database Server addresses the following issues:

  1. Fixed a bug that allowed applications to store invalid IEEE floating point values in fields of type double.


  2. Fixed an issue that could cause a 5035 and 7078 error when multiple local server threads or processes were logging in as ADSSYS at the same time.


  3. Fixed an issue where a subindex build on a shared master index could return a 9071 error if other users modified the master index while the subindex was being built.


  4. Updated the server to not log spurious 7008 and 7039 errors during replication.


  5. Fixed a broken link in the help file "Supported SQL Statements" topic.


  6. Fixed an error logging issue that caused the server to log a 9094 error in a situation caused by a client communication error. 9000 class errors cause the server to produce a crash dump file. It now logs a 7000 class error and continues processing.


  7. Fixed an issue that can lead to a server crash after a corrupt index file is opened.


  8. Enhanced the sp_restoredatabase() procedure to allow members of the DB:Backup and DB:Admin groups to restore the database.


  9. Fixed an issue where the server could write a crash dump file when shutting down with active users currently committing a transaction.


  10. Fixed a bug that could cause periodic delay on a busy server performing a large number of updates.


  11. Fixed a bug in the query engine that allowed stale data to be read when using ROWID in the WHERE clause of a SELECT statement.


  12. Changed the behavior of DLL caching for AEP and trigger DLLs in Advantage Database Server for NT and Linux. Rather than unload the DLLs when the last user disconnects who was referencing the DLL, the server now keeps the DLLs loaded until the DLL is either replaced or until the server is shut down. This change was made to work around memory leaks in DLLs created with Delphi.


  13. Fixed a 9066 error when canceling a query that was in the process of building a temporary index.


  14. Fixed a 9009 error when opening a Visual FoxPro DBF table when the number of fields is greater than the stored information in the data dictionary.


  15. Improved Linux server's handling of Server-Side aliases that are configured with UNC paths.


  16. Fixed a bug that caused a 9055 error to be logged when replicating a DBF table with memo data that had been updated inside a transaction.


  17. Fixed a bug that caused a table-autocreation failure when the table was encrypted and the operation being performed was inside transaction. For example, when a trigger is being fired and it requires an encrypted table to be auto-created.


  18. Fixed a bug where a cascading RI update would fail if the primary key was a compound key and one of fields in the compound key was an autoinc field.


  19. Addressed an issue in the server that could result in large numbers of 6221 errors being logged.


  20. Fixed a bug that could result in an access violation in the server or in the client code or possibly result in a 6605 being returned to the client. It could occur in very specific situations involving live cursors having WHERE clauses exceeding 64K.


  21. Fixed a bug in the server that made it possible for an access violation to occur if an invalid authentication request was made for an existing data dictionary connection.


  22. Fixed a bug that could result in a server crash if the WHERE clause of a query was slightly less than 1024 bytes in length. Additional conditions had to be met for this to occur: 1) Field names involved in the WHERE clause had to be 2 characters in length, and 2) the column position had to be 10 or greater.


  23. Fixed a bug in the server that resulted in an access violation when ALTER FUNCTION changed a function having one or more parameters to one that had no parameters.


  24. The Advantage help file has been repackaged as a Microsoft Compiled HTML Help.


  25. Fixed a bug that caused backups of Visual FoxPro DBF tables with long field names to return a 5012.


  26. Fixed a 9071 error when using VFP tables with after insert triggers.


  27. Fixed an issue that would prevent sp_DisableQueryLogging from disabling the query log if the current connect path differs from the connect path used to enable query logging.


  28. Fixed an error that can cause a 9095 to be logged when shutting down a server with an expired evaluation license.


  29. Fixed an issue that could lead to an incorrect 5088 error when executing certain SQL statements that reference DBF tables with numeric fields.


  30. Modified the server to not generate crash dump when invalid data is received from the connection request listening socket.


  31. Fixed an issue where backup and table creation could sometimes create filenames with all uppercase characters, rather than preserving the character case.


  32. Fixed a bug that caused mixed cased file name/extension being stored in the data dictionary for the auto-open index files. The mixed cased file name may cause table open failure on Linux server.


  33. Fixed an issue where a reindex operation would lose index conditions on IDX index files.


  34. Fixed an issue where running multiple backups at the same time would report blurry snapshots (error 5200) even when other threads where not active and could not affect the validity of the backup image.


  35. Fixed a bug in the server that caused OEM data in DBF tables to be replicated incorrectly if the table was replicated to more than one target.


  36. Fixed a 7105 error when cleaning up a failed transaction on an FTS index at startup.


  37. Modified replication processing algorithm for improved performance when there are many deleted records in the replication queue.


  38. Fixed a memory leak that can be caused by replicating OEM memo data to multiple targets. The error only exists in v9.10.0.20.


  39. Fixed a rare deadlock situation with referential integrity.


  40. Fixed bug in the server that caused incorrect result being returned when setting an AOF in the form "EMPTY(fld) = FALSE". This bug also affected SQL statement with such expression in the WHERE clause.


  41. Changed the DBF header date to be compatible with 3rd party utilities.


  42. Fixed an issue that could cause the server to deadlock and hang when shutting down with active users.


  43. Fixed a bug that may cause 4004 error when an index is built using expression with LEFT(), RIGHT() or SUBSTR().


  44. Fixed an issue where using a special character in a column alias name could cause the server to hang.


  45. Fixed bug that caused 7112 error being returned when trying to zap a temporary table using the sp_ZapTable() stored procedure.


  46. Fixed a bug that may cause server crash when subquery is used as the count expression in a "SELECT COUNT( DISTINCT ... )" query.


  47. Fixed an issue where using a binary parameter or variable inside a user defined function (UDF) could sometimes result in a native error 2101, "Memory Allocation Error".


  48. Fixed a bug that caused the SQL engine to erroneously short circuit the execution of a user defined function.


  49. Fixed a performance issue when executing a query that used a temporary index on a rapidly changing table.


  50. Fixed a bug that caused query performance to degrade when the data distribution in the underlying tables changed. The query optimizer was using stale information to generate the execution plan.


  51. Fixed a bug in the SQL engine that caused a 9111 error on the server when a UDF was used in the statement's WHERE clause, and predicate substitution optimization was a viable option.


  52. Fixed a bug that causes incorrect query result or incorrect error when multiple UDF are present in the GROUP BY clause.


  53. Fixed an issue with the IIF and CASE scalars when they return BLOB values.


  54. Fixed issue where time value comparison behavior in SQL changed from v8.1.


  55. Enhanced the SQL query engine to use available index to optimize YEAR(), MONTH(), DAY() and EMPTY() scalar if the corresponding indexes are available.


  56. Fixed a bug in the SQL query execution plan retrieval that may cause server crash.


  57. Fixed a bug that caused access violation when a user defined function returned character string that is longer than the function's declared return type.


  58. Fixed an issue where a static query can return the wrong results if using a <= or >= operator in the WHERE clause and the field reference is on the right side of the comparison.