HitSoftware Open up your Data
Buy Download Contact Us

Chinese Website 
Japanese Website 


Products and Services
Technical Support
Knowledge Base
Customer Portal
Release History/Notes
Update Packs
FAQs
DB2 Products

HiT OLEDB/400 and HiT OLEDB Server/400 Release Notes
 
Version
Date
Changes
4.0.0.0

10/22/07

  • Added support for Microsoft Windows Vista and passed Windows Vista certification;
  • Added support for the New Data Source View wizard in Visual Studio 2005 (Integration Services Project);
  • Fixed a problem where the Foreign Keys Catalog did not manage errors properly.
3.0.0.5

09/02/05

  • Fixed a problem where HiT Server Manager was not included in the HiT OLEDB Server/400 releases;
  • Added support for Microsoft Windows 64-bit environments.
3.0.0.4

08/12/05

  • Fixed a problem for C++ exception in ICommand::Execute, ICommand::Prepare and other ICommand methods. This unpredictable memory problem occurred specially when running application servers or web servers;
  • Fixed a SQL Server lock problem that occurred when using V5R3. V5R3 sometimes behaves like versions V3R7 or below by not using extended formats, due to an unexpected problem in setting attributes. This caused lock problems in SQL Server;
  • Fixed a problem where a PWS0001 error was generated for every query when running on V3R7 or below. Query Timeout (CommandTimeout) is no longer used for versions V3R7 and below;
  • Added a workaround to completely disable Query Timeout (CommandTimeout) settings. Add a minus sign (-) to the value set in the Communications tab Timeout Value field (data link configuration dialog);
  • Modified update pack setup to enable updating of OLEDB/400 when installed with DB Moto;
  • Fixed a problem where the number of rows affected from an update statement was not returned properly;
  • Changed the Primary Key catalog support where a query used a SELECT statement instead of a ROI database request because, for primary key column names longer than 10 characters, the primary key name returned by the AS/400 was the internal one (a short form of just 10 characters) instead of the real one.
3.0.0.2
02/02/05
  • Fixed a problem with DBCS characters as output parameters of stored procedures. Part of the resulting string in some cases was corrupted;
  • Fixed conversion problem for characters ‘~’ and ‘\’ with CCSID 5026 - Japanese Katakana-Kanji Host Mixed;
3.0.0.1
Update Pack Only
07/27/04
  • Improved TCP/IP performance by changing the way the connection timeout value is handled;
  • Fixed a problem with SQL Server when calling a stored procedure through a linked server;
  • Fixed a locking problem when running 1PC (single phase commit) transactions in objects created in .NET running under COM+ and requiring transactions.
3.0.0.0
05/28/04
  • Improved performance of insert, update and delete statements;
  • Added support for LOB data types of small size (the length is between 1 and 32KB) where the Lob locator cannot be used to reference the LOB value;
  • Added full support for the CommandTimeout property: its value was not properly used and the timeout for the command was set to the AS/400 job’s query timeout;
  • Fixed some concurrency issues with two-phase commit;
  • Introduced a new form for inserting the HiT license key during setup;
  • Updated the installation process for silent installation (no GUI or user input during installation).
2.1.1.6
Update Pack Only
04/21/04
  • Fixed a problem with some specific DBCS characters;
  • Improved performance when working with OS/400 V4R5, especially for INSERT/UPDATE/DELETE statements.
2.1.1.5 03/29/04
  • Fixed a problem with double byte parameters where the length was not set correctly.
2.1.1.4 02/26/04
  • Fixed problems and extended support for direct statements with double byte characters (DBCS);
  • Updated the SSL support with the latest cipher suites;
  • Fixed problems with bookmarks encountered using static cursors in VB6 with ADO and SELECT statements. The number of returned rows was in general about 500 rows less than the real number - and it was 0 if the number of rows to be returned was less than 500;
  • Improved SystemInfo trace.
2.1.1.3 12/29/03
  • Fixed performance regression retrieving (SELECT) DECIMAL/NUMERIC SQL types. The regression has been introduced in version 2.1.0.7. Writing DECIMAL/NUMERIC was not affected.
2.1.1.2
12/01/03
  • Added a checkbox in the Data Source General tab to enable the driver to override the CCSID settings for the Catalog functions. Setting the checkbox will force the driver to use the CCSID connection instead of the column connection when performing a Catalog function. This will allow the use of non-standard characters for table/column names;
  • Fixed a problem with 2PC. The problem occurred when abort requests were initiated by a host other than OLEDB/400. Another synchronizing event was added to avoid race conditions;
  • Fixed a number of problems with connection properties: LocalSettings property and 2PC enabling property were exchanged in GetAllProperty procedure. Also fixed GetDataSourceProperty procedures because some property offsets were mixed up.
2.1.1.1
09/18/03
  • Fixed a problem with double-byte string: The length of some returned values was bigger that the actual field’s length;
  • Fixed a regression in EbcdicToAnsi conversion that freezes an application when it retrieves UCS2 fields.
2.1.1.0 08/06/03
  • Added support for BIGINT data type. Now the driver fully supports the 64bit length integer values;
  • Fixed a problem in tokens management that causes a unhandled C++ exception when an unrecognized command text is entered;
  • Fixed bug in IDBInfo::GetKeywords procedure that occured when using HiT WinAllora. An access violation occurred when releasing the shared buffer containing the keywords string. The bug made the calling application hang because the shared buffer was on stack and not in system memory;
  • Added a new tracing feature to the high-level trace. In the trace you can now see the actual value of each output parameter;
  • Fixed a problem with the high-level trace related to GetNextRows API. Now all the input/output values of this API are traced correctly;
  • Introduced Multi-language support for literals and data fields.
2.1.0.9 07/07/03
  • Fixed _mbslen problem under Windows XP;
  • Added application name recognition for HiT DBMoto;
  • Fixed problem reading DECIMAL/NUMERIC with scale = 0 introduced in version 2.1.0.7

2.1.0.7 06/19/03
  • Improved DECIMAL and NUMERIC precision. DECIMAL and NUMERIC fields can be respectively 38 and 25 digits long;
  • Fixed problems with LONGVARCHAR fields management as ISequentialStream in SQL Server InProcess Linked Server;
  • Improved low level error management in multithreading - mode;
  • Fixed problem in UCS2 fields management : now you can read and write correctly into that kind of fields;
  • Fixed a problem in DPC Support related that causes failure in the connection to the server;
  • Fixed a problem EBCDIC to ANSI conversion related to conversion tables loading;
  • Improved Alias Management in positional insert/update/delete statements;
  • Improved Alias Management in IcolumnsRowswet interface;
  • Fixed a problem in catalog query related to GRAPHICS and VARGRAPHICS UCS2 fields management;
  • Fixed a bug in GetData management that causes a C++ Unhandled Exception iin retrieving columns rowset;
  • Low level trace improvement : now Process ID, Thread ID and timing are traced;
  • Added a workaround in stored procedure management : the provider exits with no errors and warnings when the OS/400 returns a warning about the numbers of recordset returned by the SP execution;
  • Now it is possible to execute Catalog Queries using Case Sensitive restrictions;
  • Fixed a problem in accessor management : when the accessor is created after the prepare and not after the execute, the getdata doesn’t find valid binding informations;
  • Removed memory leaks in accessor management.
2.1.0.6
04/14/03
  • Added Parameters CCSID management: now the EbcdicToAnsi & AnsiToEbcdic are performed using the conversion table related to parameter CCSID;
  • Improved performance in column CCSID management;
  • Improved Two Phase Commit Support : Can now correctly process read-only transactions;
  • Fixed memory leaks in low-level trace file management;
  • Fixed concurrency problems in error management;
  • Solved concurrency issues in Two Phase Commit Management ;
  • Added asyncronous management for ItransactionResourceAsync Interface;
  • Improved Performance in RLE Compression Management;
  • Added RLE Compression for AS/400 hosts older than V5R1 (starting from V4R3);
  • Improved handling of SQL stored procedure and external stored procedure user-defined error codes. Specific errors codes (return codes) are also returned;
  • Fixed bug: Stored procedure not using parameters with multiple result sets only returned one result set. Rowset object was closed when set to MultipleResults. The fix now checks for statements and rowset is closed for statements other than stored procedure calls.
2.1.0.5 02/07/03
  • Removed a defect that caused unwanted cursor thrashing when performing non-parametrical inserts/updates/deletes using ADO on connection objects (using commands the defect did not show up);
  • Added RLE Compression Support for V5R1 Hosts;
  • Fixed a problem in Remote Program Call with unqualified program name (Error Description: HiTOLEDB400: a C++ exception occurred in the Ole Db Provider.Caller function: COleDb400Command::Prepare);
  • Fixed a sporadic problem wih Date Time fields and Convert Date Time option enabled. The problem occured when running four level select query in Microsoft SQL Server (metadata changed at execution time);
  • Improved performance regarding the communication with OS/400 through ODBS;
  • Improved Graphics / VarGraphics DBCS only field management : catalog management;
  • LoadAliases: cursor did not close properly. There were unexpected effects when used with HiT Server Manager;
  • PrimaryKey support: Fixed problems with the returned index name for older version of OS/400.
2.1.0.4
10/28/02
  • Fixed problems in the management for Graphics and VarGraphics DBCS only field;
  • Fixed a sporadic problem with GetData while reading data, caused by a format conversion on the bookmark field;
  • You can now enable or disable the Use of Local Settings using data link properties;
  • You can now enable or disable Two Phase commit support using data link properties;
  • Fixed a sporadic problem with the Toolbox: The creation or the editing of a data link file didn’t create a valid data link file under some specific conditions;
  • From the Toolbox, you can now insert the connection password to save in the UDL file;
  • Fixed a problem with output parameters for stored procedure. Previously, the length of the output parameter wasn't returned, so the value was not returned properly;
  • Fixed a problem with Two Phase Commit Support: When we are in a distributed transaction, only xa_commit has to be sent;
  • Fixed a problem in column CCSID management : When column CCSID is not supported, the provider uses default CCSID;
  • Fixed a problem in large trace files management : Sometimes a trace didn’t start;
  • Fixed a problem in retrieving data from AS/400 : A random C++ Unhandled Exception occured in CNewRowset::GetData when the binding points to the bookmark;
  • Modified RowsetChange/InsertRow/DeleteRows methods of the IRowset interface to handle fields whose name contains lower case characters (used double-quotes in the SQL statement of positional queries);
  • Remove use of RowsetCreated command property (it created an OLEDB exception when used by the OLEDB consumer software - winAllora) and replaced with an instance variable in the command class.

2.1.0.3

09/06/02
  • Added management for large trace files.

2.1.0.2


08/22/02
  • Added C# (C-Sharp) Toolkit (Developer Edition only);
  • Added Two Phase Commit Support with Recovery Management;
  • Fixed a bug in IColumnRowset::GetColumnRowset : now all interfaces and cursors are released correctly;
  • Fixed a lock problem during execution of parametric distributed program call;
  • Introduced UCS-2 support for CCSID 13488 data and for GRAPHIC data types;
  • Added Two Phase Commit support with Recovery Management (DB2 Server V5R1 or later required);
  • Fixed a problem where in some sequence of executions and preparations (SetData and regular SELECTS) cursors got closed while the positional update believed them to be still open and usable at the next SetData call: This fix creates a new ODBS cursor every time a command is prepared.

2.0.1.3

06/10/02

  • HiT OLEDB/400 is now compatible with .Net DataSet Update commands and OLEDB Adapter Wizard for Visual Studio .Net;
  • When Crystal Report calls a Stored Procedure with a DBTYPE_STR or DBTYPE_WSTR parameter, it does not pass the length of the parameter. To get it we need to force a strlen or wcslen for the parameter;
  • Bug Fix: using ADO Recordsets to retrieve multiple result sets returned by a Stored Procedure right after finished retrieving another result set by a SELECT query caused the provider to loop indefinitely, retrieving an infinite number of result sets, as with the SELECT result set. The problem typically appeared in VB (or VBS) + ADO environments;
  • Now possible to call a Stored Procedure even if the driver is read-only. Removed the “Window's Name Loop...” problem, there is no need to do a loop anymore to detect the calling application;
  • Added support for the following additional columns in: GetColumnsRowset method of IColumnsRowset: DBCOLUMN_BASECATALOGNAME, DBCOLUMN_BASECOLUMNNAME, DBCOLUMN_BASESCHEMANAME, DBCOLUMN_BASETABLENAME and DBCOLUMN_KEYCOLUMN. Now the provider supports updates through the Client Cursor Engine. Problems related to “Insufficient base table information for updating or refreshing” error message;
  • Fixed a problem in getting correct character parameter length;
  • Fixed the following problem: when using the toolbox and changing the trace file; name, in the past one could not trace anything until the toolbox was restarted. Now that can be done without restarting the toolbox;
  • Fixed a problem related to trace file: A trace file is created and eventually existing file is overwritten only when the DLL is loaded.

2.0.1.2

03/05/02

  • Fixed a problem in field conversion using CCSID: now the driver does it instead of OS/400.
  • Fixed a problem in Convert CCSID 65535.
  • Add “Remote Command Call” feature: now it is possible to call a remote command with the following syntax: {{ command }};
  • Fixed a problem with parsing the blanks before EXEC CALL statement: now the blanks are skipped correctly;
  • Resolved a C++ exception, detected only when executing a parametric statement without having set the parameters;
  • Fixed a problem with Positional Operations when table name is in the following format : <catalog name>.<lib name>.<table name>.
  • Fixed a problem with the low traces file creation.
  • Introduced a structured management in using HSTABLEs: sometimes a delay is needed because concurrent threads can access the same table at the same time returning “ODBS error: Conversion table not found” errors.

2.0.1.1

01/02/02
  • Fixed problems while retrieving messages in Distributed Program Call
  • Added Columns CCSID Conversion.
  • Fixed the start problem of the low traces;
  • Added Update License Key menu item to Toolbox for updating product license keys.

2.0.1.0

12/04/01

  • We now permit a stored procedure to be called even if the setting is read-only, but only for Crystal Reports. Previously, Crystal Reports 8 set the driver to read-only before calling a stored procedure, which caused the driver to malfunction;
  • ALIAS Support : Corrected error in SELECT statement using ORDER BY clause and ALIAS;
  • Introduced support for OUT OF PROCESS work mode;
  • Fixed a problem with SQL Server DTS: When executing an Import DTS twice, data wasn’t correctly replicated the second time. The SQL target tables contained only blanks and 0s instead of the correct data;
  • Added support for insert/update of BLOB fields and for inline bindings (other than ISequentialStream bindings);
  • Introduced early memory release in update/insert/delete operations;
  • Fixed a memory leak using recordsets with IMultipleResults interface.

2.0.0.2

10/11/01

  • Setup verifies if Microsoft Visual Basic is installed on the system, before proceeding to HiT OLEDB/400’s installation and the use of HiT VB Toolkit;
  • Added silent installation.

2.0.0.1b

09/07/01
  • AS/400 Password Expired: now after changing the expired password, the new password is visible in Properties.
  • Fixed a problem (in debug mode): if the connection failed, another error occured, caused by the notification to the agent of the connect function’s termination;
  • Fixed an error in PROCEDURE_PARAMETERS schema rowset: the schema was filled using 15 columns instead of 17, as the OLE standard requires.

2.0.0.1

 

07/31/01

 

  • Resolved memory leak problems during insert command. Making a loop of inserts either with the ICommand or the IRowsetChange interfaces, the memory allocation used by the process grew up, caused by accessor bindings not freed after their use;
  • Resolved problems with GetKeywords command. Now OLEDB/400 works with VISIO 200X in order to do DB reverse engineering;
  • Resolved a C++ exception, detected only in debug mode, running a CALL of a stored procedure which returns no resultsets;
  • Fixed a synchronization problem detected with Microsoft Web Application Stress Tool running a number of threads greater then 1.
  • It’s now possible upgrade HiT OLEDB Server/400 version 1.0 to version 2.0.
2.0.0.0 06/01/01
  • Added “Convert Date Time” checkbox in the Advanced tab: this feature enables the client application to read date/time fields as char fields. This can be useful any time users set the date/time field to non-date/time values (like 0, NULL, or a very old date) to a NULL data. This behavior is allowed by the AS/400 server, but sometimes can create problems if applications (like those using ADO, for instance) try to read that field expecting a correct date/time value. The ADO error is usually the following: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done." Converting the date/time field to char, we avoid this error;
  • Added the feature “4 part naming for SQL queries” to the Advanced tab as “Skip Catalog Field” check;
  • Added HiT Server Manager to HiT OLEDB Server/400 to provide services for monitoring server activity and connection pooling;
  • Added support for large binary objects: BLOB and CLOB;
  • Added Change License Key menu item to Toolbox for updating product license keys;
  • Removed Workshop. Both Client and Server versions include the Toolbox;
  • Updated installation to include Microsoft Data Access Components (MDAC) version 2.6.
  • Added COLUMN ALIAS support for Positional Update Request where performing a Positional Update using ALIAS on Columns that contain special chars in their names.
  • Added support for FOREIGN_KEYS and PRIMARY_KEYS schema rowset.
  • Added support for AS/400 Password Expired
1.1.2.10
07/31/01
  • Resolved a C++ exception, detected only in debug mode, running a stored procedure CALL which returns no result sets.
1.1.2.9 06/21/01
  • Resolved memory leak problems during insert command. Making a loop of inserts either with the ICommand or the IRowsetChange interfaces, the memory allocation used by the process grows, caused by accessor bindings not being freed after their use.

1.1.2.8

01/23/01
  • Added a feature to use 4 part naming for SQL queries from Microsoft SQL Server, excluding the catalog name, like in the example below:
    select * from linked_server..libname.tabname
  • If the value of the RegKey "SkipCatalogField" = 1, the Catalog name (RDBNAME) will be returned as NULL; if the key does not exist or the value is set to 0 (Default), the actual value on the AS/400 will be returned by our OLE DB provider.
  • Resolved a multithreading problem in ODBS32.dll in ODBS_Transact.
  • Resolved a memory leak problem caused by non deallocated property strings after calling an IDBProperties::GetProperty.
1.1.2.7 11/16/00
  • Resolved a parser problem using stored procedures CALL statements with Use Unqual. Table Name property: using 3-level qualifications (like Crystal Reports does) caused problems, because the CALL query wasn’t checked for the UUT parsing option.
  • Added a feature using ADO to call stored procedures: if SP is the stored procedure name, the ADO command text “call SP” was accepted only by setting the command Type property to adCmdText and not to adCmdStoredProc.

  • Fixed a problem with sp_columns_ex and SQLserver/QueryAnalyzer for char fields.

  • Fixed an error calling INewRowset::ReleaseRows, causing a C++ exception.

  • Modified error messages due to invalid key and added expiration date and max number of connections in the About dialog in the Workshop.

  • Added a feature to resolve queries containing column aliases in the SELECT clause, but referring to them by the column name (and not by alias) in the ORDER BY clause. The query parser has been modified in order to send the correct query to the server;
    Resolved an error calling IDBInfo::GetLiteralInfo OLE DB function. Using Seagate Crystal Reportsâ, it’s important to create a registry key (under [HKEY_LOCAL_MACHINE\SOFTWARE\HiT Software\HiT OLE DB/400]) called DisableWindowLoop, DWORD type and value 1.
1.1.2.6 08/04/00
  • Introduced use of decimal separator symbol depending on the user locale settings.
  • Fixed a problem with Catalogs returning Unhandled Exception when working with V4R3M2 and V4R5. it’s related to ODBS400.DLL only.
  • Fixed a problem where a warning during Fetch in ODBS was treated as an error.
  • Sometimes EBCDIC data were not converted to ASCII when running catalog queries or select queries. This happened because the AS/400 optimized server sometimes returns the wrong information about the number of rows returned.
1.1.2.5 07/14/00
  • Introduced alias support for AS/400 multimember tables: several aliases can be defined on the same table for different members with the same set of columns.
1.1.2.4 07/05/00
  • Resolved a backward compatibility problem with Connect Timeout property: old DTS packages did not recognize the new property; the problem has been resolved introducing a provider-specific property named Init Timeout which can be saved statically and whose value is used as socket timeout value;
  • Fixed an error with memory allocation. In the case where Rowset Locate was selected, some memory blocks were not reused.
  • Resolved an update error with decimal types, with a precision greater then 19: length of field was not always correctly calculated.
  • Fixed a problem with DPC introduced in build 1.1.2.0: DPC parameters were provided to the AS400 DPC server padded with ODBS Null Indicators causing errors.
1.1.2.3 06/19/00
  • Resolved a setting problem with Use Unqual. Table Name property: connecting with prompt during initialization set always to FALSE the value of this property;
  • Fixed an error, when Use Unqual. Table Name property was checked, calling one of the following schema rowsets: COLUMNS, PROCEDURES and PROCEDURE_PARAMETERS rowset: the parser was not correctly called to support *SYS NAMING OPTION syntax;
1.1.2.2 06/16/00
  • Fixed a problem updating BINARY data with Convert CCSID 65535 checked: correct values were displayed but not effectively sent to the database;
  • Fixed a problem updating CHAR OLE data (DBTYPE_STR, DBTYPE_BSTR, DBTYPE_WSTR) with values exceeding the maximum length: an error occurred returning results into the consumer’s buffer;
  • Resolved a compatibility problem with MS SQL Server DTS: Connect Timeout property was not recognized in old DTS packages saved in provider version preceding the 1.1.2.0;
  • Implemented IRowsetUpdate interface in order to manage delayed updates;
  • Fixed an error for Mode property: it was always set to Write value;
  • HSTABLEs 420 – Arabic and 838 – Thai added to the tables list;
  • Fixed an error in schema columns with aliases: the TABLE_NAME column retrieved always the original table name, instead of the alias one (and this brought about an error when DbXpress was enabled);
  • Fixed a small problem in parsing a CALL DPC query: calling a program with a string without blanks before “?” was not recognized as a parametric query.
1.1.2.1 05/09/00
  • Memory exception during the execution of a select statement performing the following operations:

    - create a command

    - run a select with a number n of result columns

    - run a select with a number m>n of result columns

    - C++ exception.

  • Toolbox: global trace value into oledb400.ini was set wrong;
  • Resolved a memory exception in CreateAccessor when trace is active
1.1.2.0 04/27/00
  • Fixed a problem with MDAC 2.5 saving Connect Timeout and Port Number fields into a UDL file (HiT Toolbox/Workshop saves these properties);
  • Introduced alternative memory management, only when Rowset Locate is checked: every request for new memory for the local rowset allocate an entire block of a fixed number of fixed size rows, in contrast of the standard method of allocating single rows every time is needed;
  • Unqualified table names support – behavior is the same than ODBC/400;
  • Support SSL Strong released for all versions;
  • Setup: updated MDAC version (2.50.4403.12);
  • Toolbox: only one level of global trace.
1.1.1.1 02/25/00
  • Introduced dbXpress feature.
  • Updated trace structure. Now trace file (level 3) contains also info about local machine, some MDAC files version and last writing time, version and key of the installed product.
  • Using trace option will be available only if the toolbox is active. Closing the toolbox all traces (global or local) will be disabled.
  • Fixed a problem with packages into the workshop, the isolation level was always “0 - None’.
  • Fixed a problem with DECIMAL type: formatting function was not correct, particularly in case with leading zeros and with precision major then 19.
  • Added DBCS support;
  • Updated conversion table 280 and 37 and added euro-conversion tables from 1140 to 1149 and for double byte 933, 935, 937, 4039, 5026 and 5025;
  • Introduced Performance Tab into Data Source Configuration and changed the position of some entries.
  • License key now visible from “About” of Toolbox/Workshop
  • Added handling of packages and debug from Toolbox;
  • Setup: The runtime version can be installed only on machines with Microsoft Windows 95/98, Windows NT4.0 Workstation and Windows 2000 Professional;
  • Setup: Dcom 98 replaced from Dcom95 latest version (1.3).
1.1.0.2 12/03/99
  • Updated help files
1.1.0.1 11/22/99
  • Fixed problem with SCHEMA_COLUMNS and Alias Tables (especially for member defined as Aliases).
  • Added new Data Source property called “Alias Support” – when set to true Alias Catalog info is cached.
  • Added support for performance counter (available only on recompilation).
  • Fixed memory leak problem (only for DB_MEM_PROVIDER options) – detected only by running queries with varchar fields and QueryAnalyzer.
  • Changed registry setting for OLEDB_SERVICES – set to supporting everything but distributed transactions.
  • Fixed problem with the INIT_PROVIDER_STRING property: now it can handle the field “Data Source” set to point to a udl file.
  • Fixed a problem with udl files having an empty string for the “Libraries” property.
  • Changed the default value for the OLEDB_SERVICES Data Source property.
  • Removed support for SCHEMA_INDEXES catalog rowsets (rather than being taken as key descriptions, they were mistakenly taken for record level access indexes).
  • Fixed a memory leak with Column Names (following release of a select resultset)
  • Fixed problem related to converting large precision decimal fields to char (0’s were converted to blanks).
  • Fixed more memory leak related to _HSModule collections.
1.1.0.0 11/05/99
  • SSL Support – New Release
1.0.1.24
09/22/99
  • Added support for the IMultipleResults interface
  • Added support to call stored procedures using MS Sql7 Query Analyzer.
  • Added support to call stored procedures that returns multiple result sets and that support output parameters.
  • Fixed a number of problems related to cursors not being released (within a single connection).
  • Fixed problem when preparing queries in sequence reusing the same cursor number. Now, before re-preparing a cursor, the cursor is closed and released.
  • Fixed problem when either a Prepare or an ExecDirect fail: now the generated cursor is closed and released.
  • Fixed problem with InsertRows (IRowsetChange interface): sometimes the “*N substringing function error” happened. To fix the problem NULL values are submitted as parameters.
  • Fixed a problem with output parameters: they are only processed when stored procedures are queried.
  • Fixed problem with SetCommandText: cursors are closed and released only when a rowset is created.
  • Fixed problem with output parameters that are set to NULL on input to a parametric query.
  • Added support for the ?=call xxx(?,?,…?);1 syntax for stored procedures (as generated by SqlServer 7).
  • The IMultipleResults rowset interface is supported only by rowsets that are not generated by the GetResult method (IMultipleResults interface and ADO 6.0).
  • Columns Schema queries had a consistency problem with binary data and the ConvCCSID flag set to true.
  • Fixed problem with UDL file support (as provide in the data source property) and UserID, Password and Library properties.
  • Fixed problem with uppercase conversion and ConnectTPN, Package Name and Package Library properties;
  • Fixed some problems with VB toolkit and installation of Msvbvm50.dll in windows system if not exist;
  • Updated MDAC version to 2.1.2.4202.3
1.0.1.23 09/02/99
  • Fixed the infamous “invalid operation” problem. The problem was due to having Sql 7 requesting transactions on non-journaled tables. The problem was fixed by not starting a transaction when no-commit was selected in the connection string.
  • When running COLUMN_SCHEMA Schema Rowset queries, column catalogs are now sorted based on the ordinal position (Sql 7 has a problem when sorting on ordinal positions is not in place).
  • OpenRowset now does not fail on invalid rowset properties (Sql 7 has problems when that happens).
  • The BookmarkType rowset property was added.
  • Fixed the column info trace (there was a problem when bookmarks are used).
  • The trace was improved in a number of different areas.
  • Added the LITE version support.
  • License keys with the read-only flag set are now properly handled.
  • Sql Server 7 stored procedures Sql syntax is now handled by the driver.
  • Data sources using UDL files had a problem when the full path was specified.
  • Fixed a problem with package names when UDL files are supplied as Data Sources.
  • Fixed an unlikely problem: combination of stored procedures with result sets/isolation level != 0/hold cursors=off è the end result was that no resultset was obtained.
  • The Remove Blanks feature (as for the ODBC driver) was added to Connection dialog box and the set of connection properties
1.0.1.22 08/12/99
  • Fixed problem double quote support and CrystalReport Designer
  • Added updated help file and release notes.
1.0.1.21 08/09/99
  • Fixed problem with NULL and InsertRow method of IrowsetChange.
  • Fixed problem with error strings being cleared unnecessarily by a QueryInterface call.
  • Added support for connection property settings within the datasource property
  • Added support for data link settings within the datasource property
  • Fixed problem with Rollback/Commit during transaction with Isolation Level != from 0
1.0.1.20 06/28/99
  • Added support for bookmarks
  • Added support for IrowsetLocate to handle Sql7 QueryAnalyzer Update/Insert/Delete statements on LinkedServers
1.0.1.19 06/15/99
  • Added support for IrowsetChange for Update and Delete
  • Added support for ISequentialStream (binary data with Sql7 linked servers).
  • Improved trace to handle more interfaces and properties
  • Fixed multi-thread problems for concurrent update/delete/insert in the same connection.
1.0.1.18 05/27/99
  • Added support for IRowsetChange for Insert Rows only;
  • Fixed problem with parsing parameter markers (?) if not preceded by blanks;
  • Created new parsing tool based on stack of identifiers;
  • Inserted MDAC 2.1 during setup.
1.0.1.17 05/04/99
  • Fixed problem with input parameters: when field is char and binding is of type Variant, the parameter string was truncated to 16 chars;
  • Fixed problems with locks on input parameters: there was a situation when a critical section object was not released;
  • Fixed problem with char fields containing the Null char (0x00): the string was truncated to the first null - now the entire char content is returned;
  • Fixed problem with the Conv CCSID Data Source: sporadically the input parameter was set either to true or false randomly


All Rights Reserved © 2008 HiT Software, Inc.
All other trademarks or registered trademarks herein are the property of their respective owners.