Version 3.0.0.3 Build 0 - July 2, 2008

• de-reference name conflicts.
• Heap Allocation Error fix.
• Fix SQL_NTS use in Bound Parameter.
• Fix 64bit ODBC support
• Fix implicit inner join.
• Logging changes to ReadIndexFile (_read).

Version 3.0.0.0 Build 0 - April 9, 2008

• Allow four part names when used from SQL Server.
• Unicode/Wide Character conversions corrected in the OLEDB Provider
• Optimized Omnidex Keyword searches when more than one key can be used for a table.
• Permit long Image passwords (Eloquence)
• odbc.ini search directory fix for Mac OSX.

Version 2.2.8.0 Build 0 - January 25, 2008

This is a general or "push" release. This release contains important modifications and improvements that should be deployed to all sites.

•  OJ mixed form multiple "on" clause fix.
• Added Ignore UID/PWD option.
• Fixed syslogd message leak.
• Log IP address on connection error.
• Added MSTRACELOGON.
• DECODE return value type now string.
• Mismatched quotes.

Version 2.2.7.6 Build 3 - November 15, 2007

This is a "pull" release. Please contact Minisoft support for update files.  A general release is planned with these changes and a new manual.

• Include version information.
• Allow tracing SQL Statements without fully enabling tracing.
• Increased tracing details.
• Support for UNIX based qsort routine.
• Configurable temporary directory.
• Support for CYYMMDD.
• Fix Packed number conversion for non-MPE.
• Support Omnidex on UNIX.
• Fix Unsigned Integer conversions.
• Option added to use native Eloquence calls.
• Fix defunct processes left when launching from a shell script.
• Fixed locking level on record delete and insert.
• Fixed dblock descriptor Endean issue with Windows based Eloquence.
• Added option to Ignore UID/PWD.
• Fixed 64bit Endean issues.
• Correct handling of GROUP BY syntax.
• Fixed handling of scaled constants.
• Corrected JOIN processing.
• Support for 64bit libraries.
• Cleanup memory when disposing of Statement Handles.
• Fixed multiple SQLGetData calls for truncated data.
  

Version 2.2.7.0 Builds as of  October 12, 2006

• Build for Release.
• Return 08S01 in place of 08004 if server disconnects unexpectedly.
  (i.e. Job stopped for backup.)
• Long File Names.
• Return Item Type Meta Information.
• Performance (speed) optimizations.
• Adding ROWID.
• Consolidate platform source.
• Omnidex support with Eloquence
• Supports Robelle SD Files on UNIX

Version 2.2.6.5 Builds as of March 31, 2005

• 8 Option for no auto _TPI suffix."
• 7 Add limit to write packet size."
• 6 Dynamic allocation of space for tracing buffer."
• 5 Remove Uppercase only Database name"
• 4 Remove requirement for {oj ... } syntax"
• 3 Add Trace for SQL statement size (OPNS).
     Add url_unescape ( Value );"
• 0 Refine TPI Token parsing."

Version 2.2.6.4 Build 2 - June 14, 2004

Problems Corrected:

• Fix for parameterized Big Integers.
• Fix for truncation of record sets over 2000 bytes.
• Fix for TPI token parsing. If the search value contained a '-' the record would not be found unless the wildcard '@' was used.

  Version 2.2.6.4 Build 0 - January 21, 2004

New Features:

• Modifications for source code portability.
• Support for SQLDECIMAL and SQLBIGINT.
• Added results for SQLColumns when no table is given.
• Logging improvements.
• Diagnostic messages enhanced.
• Support for multiple server types.
• Support for multiple client types.
• Improved support of long server transactions.
• Added the functions ROUND, COALESCE, ISNULL, ISNUMERIC, SIGN, and DECODE.
• Added statement type HOSTCOMMAND.
• Allow 3kodbc.dll to self-install.

Problems corrected:

• Fix for ADO and NULLABLE columns.

Version 2.2.6.2 Build 7 - August 5, 2003

New Features:

• Speed improvements.
• Improvements to the tracing facilities.
• Additional Oracle support.
• Consolidation of code from different operating systems.
• Added ROUND function.

Version 2.2.6.2 Build 0 - July 3, 2003

New Features:

• The primary feature added to this release is support for a variety of client types. In addition to Windows, we now support the driver running from HPUX, Solaris, Linux, and Mac OSX. Clients other than Windows must be licensed either individually (based upon HW) or by client type.
• Support for Oracle.
• An OS independent logging facility has been added to enhance support.
• Exception conditions (such as sign on failure) can now be logged to OS dependant processes (Application Event Log under Windows and syslogd under UNIX).
• The space between some of the properties is now optional. "Account Password" can now be represented as "AccountPassword". This feature was added for web based (primarily Java) tools that could not parse connection properties that included an embedded space.

Problems corrected:

• CONCAT now handles data types other than CHAR and VARCHAR.
• Timing for checking whether the client is still alive was not accurate and has been fixed.
• Syntax errors in UPDATE statements are now reported.

Version 2.2.5

Features:

• Added support for open clients (UNIX).

Version 2.2.4

Features:

• Added support for open servers (Eloquence).

Version 2.2.3.7 Build 2 - January 24, 2003

New Features:

• DllRegisterServer added for ease of deployment to users.
• A new environment variable for the server named "MSDECADEDIGITS" is defined to help support many variations of 2 digit years in date items. "MSDECADEDIGITS" should be set in MSJOB, before the RUN statement. Its value should be 20 characters that represent the 20 decades from 1900 to 2099. The default is "0123456789:;<=>?@ABC". These values will apply to the decade digit in any X item with a date mask that has only 2 year digits.
• A new parameter 'F' on ODBCSRVR will cause all records of a query to be read when the query is executed, instead of possible deferring the reads until rows are requested.

Problems corrected:

• SUBSTRING function with start and length parameters that went beyond the length of the string caused and endless server loop.
• Timing for checking whether the client is still alive was not accurate and has been fixed.
• Server calls from a multiple threads using the same connection have been serialized so that server return information does not go to the wrong thread.
• Packed and Zoned fields incorrectly scaled.
• SQL_NUMERIC number that were scaled and pass to the driver as parameters for an INSERT UPDATE statement, were not getting scaled correctly. This was mainly a problem using the ADO methods.

Version 2.2.3.0 - December 5, 2001 (through build 5)

New Features:

• The logic to check whether the client is still alive has been extended to when records are fetched from the server. Also the logic is changed to check on the interval (set by MSQUERYCHECKINTERVAL), even if very few records qualify. Before it would only check the interval every 1024 qualified records, now it checks every 1024 reads from the db.
• Pause between Lock-Retries. After DBLOCK is issued, there is a pause for 0.25 seconds if the lock mode was conditional and the status return indicated that the attempted lock had failed.

Problems corrected:

• Null Terminated Strings and string length size client software inconsistency.
• SQLGetInfo checks return buffer space.
• Some very large SQL statements prepare into a request to the server that was too large for the input buffer. This was detected with a large IN predicate, but may have also been a problem with other very large SQL statements.
• A statement with the following where clause: where <btree key> >= <value1> and <btree key> <= <value2> would retrieve all the records.
• If there were two or more statements in a transaction that modified the same table, where one caused a set level lock and the other caused an item level lock, an error "Two descriptors conflict" would be returned. Now the set level lock overrides any item level locks on the same table and the item level locks are not attempted.
• Problem with negative values in P and Z types and ADO fixed.
• DBCLOSE mode 2 is called after each call to DBINFO mode 202 when the list of tables is retrieved right after the DBOPEN. This reduces the number of files that are open.

Version 2.2.1.1 - May 9, 2001 (through build 3)

New features:

• SQLConnect parameters:
  UserName format: [<jobname>,]<user>[.<account>[,<group>]]
  Authentication format: [[<user password>][/[<account password>][/[<group password>][/[<security password>]]]]
• SELECT * now returns the columns from all tables in the table list, not just the first one.

Problems corrected:

• SQLSetCursor caused GPF
• FLOOR and CEILING functions return incorrect results
• Real constants were not scaled correctly.
• Accessing the same dataset in one query did not work correctly.
• Problem with REPLACE function fixed.
• Column aliases could not be used in ORDER BY and GROUP BY clauses.

Version 2.2.1.0 - March 12, 2001

New features:

• All conditions in the ON clause of LEFT OUTER JOINS are used in the join.

Problems corrected:

• Key definitions lost when reading from an old schema editor file. The problems was with the related table information.

Version 2.2.0.0

New features:

• Schema file format changed to xml. Fixes limit on number of key components.
• Able to specify keys in detail data set as unique.
• Able to specify a lock item for data sets in schema file
• BETWEEN and LIKE predicates now cause key read for KSAM files.
• Server will detect if client closes the connection in the middle of a query. The interval to check (in seconds) is set with the MSQUERYCHECKINTERVAL CI variable. The default is 60 seconds.

Problems corrected:

• DISTINCT looks at all columns, it should only look at columns in the select list.
• Conversion of character data type to Big Integer caused the server to abort. (fixed 2 cases)
• Conversion of character data type to Big Integer caused the server to abort. (fixed 3rd and last case)
• If you save a Catalog Editor file in the middle of editing it then import another Schema or Database it duplicates the schemas/databases you have already loaded.

Version 2.1.9.1

New features:

• For self describing files, numeric items that follow character items are having the Signed Flag set to No instead of Yes.

Problems corrected:

• Problem with automatic multiple database opens (typically done in ADO apps) causing server aborts fixed.
• Zoned fields in HP self-describing files sometimes had left truncation occurring.
• Bad data conversion of zoned and packed fields would yield unpredictable results. Now the column is set to NULL.
• SQLBindParameter fixed to use a length of SQL_NTS if StrLen_or_IndPtr is null.
• Functions in GROUP BY clause or nested functions in ORDER BY clause would cause the driver to abort.
• Additional debug markers put in to track down a site specific problem.

Version 2.1.9.0 - August 10, 2000

New features:

• Immediate return from SQLExecute is expanded to include all SELECT statements without all of the following:
  DISTINCT keyword
  Aggregate functions
  GROUP BY clause
  HAVING clause
  ORDER BY clause
  Any SELECT statement without all of the above constructs and is only accessing tables in databases will defer reading of the databases until the client software actually requests data via SQLFetch, SQLExtendedFetch, or SQLFetchScroll. This allow partial results to be viewed much quicker.
• Additional DBOPENs will be issued automatically if a dataset is accessed more than once in a statement, or if more that one statement in a connection is accessing the same dataset. This allows the following type of statement: 
  SELECT a.item1, b.item2, c.item3 FROM set1 as a, set2 as b, set2 as c WHERE ...
  Access to set1 and the first reference of set2 will be through one DBOPEN, while access to the second reference of set2 will be through a second DBOPEN.

Problems corrected:

• Allow joining via TPI keys.
• Lost query column information when SQLCloseStmt ( or equivalent ) was called.
• No indexes reported if one of the TPI keys is based upon items the DB password does not grant access to.
• Scaling for parameters of type SQL_C_NUMERIC.
• SQLBindParameter ( hStmt, 1, 1, 1, 12, 0, 0, e1, 0, nil ), will now not cause a driver crash when e1 contains a value.
• SQLGetInfo - SQL_DRIVER_NAME=6 will now return the filename with extension (3kodbc.dll).
• Support for SQL_ODBC_SAG_CLI_CONFORMANCE in SQLGetInfo.