Ritmo/i5 v3.0.x.x Release Notes

Note: This version of Ritmo for iSeries is for Microsoft .NET Framework 1.0 and 1.1.
Please click here if you are using .NET Framework 2.0.
 

Version	Date	Changes
3.0.0.1	04/21/06	Added a feature to support expired iSeries/AS400 passwords: if the iSeries/AS400 user password is correct but expired, and the driver prompt option is set to something other than NoPrompt, the application front-end will be prompted with the Change Password dialog box where the user can provide the new password; Fixed a problem where the empty string was not managed properly for CLOBs with Locator data type; Improved package management to work properly with parametric statements only; In the Toolbox, added a check to stop system packages QSYS/QSQLPKG2 or QSYS/QSQXDPKG from being accidentally deleted in the management of SQL packages; Fixed an anchoring problem with the Help button in the Command Designer; Introduced a workaround for Reporting Services: the report preview did not work properly when the table was big enough to require more than one fetch because Visual Studio 2003 disposed the command; Extended support for special characters inside host code page 280-Italian; Modified the GetDecimal method of the Sql400DataReader to support .Net Framework 2.0; Fixed a problem where parametric queries using numeric data types with negative values were sent to the iSeries/AS400 with positive values; Introduced support for Arabic host code page (CCSID 420); Introduced the public method SetLicense(string licenseKey) for Sql400Connection, allowing users to set the license key at runtime so the driver doesn't need to read it from the Sql400.dll.Config. The "licenseKey" parameter is the LicenseKey value obtained from the Sql400.dll.Config file; Introduced OEM support; Disabled Command Timeout for old systems (OS/400 version <= V3R7) where it did not work correctly; Added support to read/write data from/to iSeries/AS400 with custom CCSID. Introduced a new property "Ccsid" for a Sql400Parameter object to set the CCSID to use for the parameter, and the new public method "SetContentCcsid" for a Sql400DataReader object to override the default CCSID on the iSeries/AS400 side. Furthermore, to read data according to a specific CCSID, different from the default one specified on the iSeries/AS400, the following public overload methods for the Sql400DataReader class have been added: GetChar(int i, int ccsid GetChars(int i, long dataIx, char[] buf, int bufIx, int len, int ccsid GetDateTime(int i, int ccsid) GetString(int i, int ccsid GetValue(int i, int ccsid) GetValues(object[] values, int[] ccsids)
3.0.0.0	08/01/05	Added Visual Studio .NET developer tools for tight integration with the VS.Net environment with designers, wizards, automatic code generation, command editor, data connections explorer; Added a Microsoft SQL Server Reporting Services data processing extension. Ritmo for iSeries is now available as a data source within Reporting Services to connect to DB2 running on iSeries, and generate reports; Unified support for .NET Framework 1.0 and 1.1; Modified the “UsePackages” property of the Sql400Connection object to be disabled by default; Fixed a problem where BIGINT values larger than 2,147,483,647 were not converted properly; Added management of SQL packages to the toolbox; Fixed a problem where the GetSchemaTable method didn’t work properly with query with joined tables; Fixed a problem where the DeriveParameter method didn’t set the correct DB type for each parameter; Added support for Unicode (UCS-2) SQL statements. The query statement is sent to the database server in Unicode format when the new connection property UseUnicodeSQL is set to true (put “Use Unicode SQL=true” in the connection string); Added the “HasRows” property to the Sql400DataReader class which enables you to determine if the Sql400DataReader has returned any results before reading from it for a SELECT statement; In the Toolbox, made a change so that the name of the data source file includes the extension “.xml” as it should be specified in the connection string when a data source file name is used (i.e.: connectionstring = ”data source=myDataSourceFile.xml”); In the Toolbox, added “simplified” and “just data source name” connection string support to have just the needed properties without including default property values; In the Toolbox, added "Open Containing Folder" menu to locate the folder containing the data source xml files; Added the DesignTimeVisible property to the Sql400Command object; Fixed problem where the connection string didn’t support special characters; Fixed a problem with transactions where the rollback didn’t work properly with stored procedures; Improved performance of non parametric Call stat; Fixed a problem where the Sql400DataReader GetOrdinal() method didn't perform a case-insensitive search if a first case-sensitive search failed; Fixed a problem where the Sql400DataReader GetValue() method threw an exception instead of returning DBNull when dealing with null values; Fixed a problem with parametric queries where the query was re-prepared every execution; Added support for Catalog functions using the new method “GetSql400SchemaTable()” of the Sql400Connection object that returns schema information from a data source as indicated by a GUID, and after applying the specified restrictions; Added support for the ConnectionState.Broken state value. As soon as the driver realizes that a connection (usually in the pooling) is no longer valid, the driver sets the connection state property to ConnectionState.Broken, throws the exception related to the socket error and fires an InfoMessage event; Added the “ServerVersion” property to the Sql400Connection class. It returns a string containing the version information of the database server to which the connection is being made; Fixed a problem where the Sql400DataReader.Item property didn’t return the DBNull value correctly when expected; Fixed a parser problem with statements containing sub-selects and special functions.
2.1.0.0	06/19/04	Added a Ritmo for iSeries Server Developer edition and a Ritmo for iSeries Client Developer edition that include a C# Toolkit; Fixed a problem with decimal conversion that failed in some language environments; Improved connection time for some environments where the DNS server was slow to resolve IP addresses; Fixed a problem where parametric queries with parameters value set to DBnull were not managed properly in some specific cases; Fixed a problem where output parameters of a Stored Procedure were not managed properly when returned as null value; Fixed a problem where the GetSchemaTable() method of the Sql400DataReader didn’t return the column “ProviderType” as a native Sql400DbType type; Improved synchronization for the connection pooling object and for trace purposes; Fixed a problem where the Clone() method of the Sql400Command object didn’t clone the command parameters correctly; The CreateParameter() method of the Sql400Command object no longer appends the parameter object onto the Parameters collection of the command object. It now has to be coded explicitly according to the .NET standard; Improved performance of INSERT, UPDATE and DELETE statements; Fixed a problem using connection pooling where synchronized code access to a dictionary was missing; Added support for the Receive Timeout for the TCP/IP connection. This value is now obtained from the ConnectionTimeout property; Fixed a problem where the data type of a Char For Bit Data field was not returned as string when the ConvertCCSID65535 was enabled.
2.0.0.2	01/09/04	Fixed a problem with the CommandTimeout: its value was not properly set; Fixed a problem: data binding using Sql400DataReader to bind data to a control didn’t work properly; Fixed a problem adding a Sql400Parameter to the Sql400ParameterCollection of the Sql400Command when the connection object was not passed to the Sql400Command constructor; Removed the ‘Public’ attribute from the Sql400ParameterCollection constructor method; Added support for LOB data type of small size (between 1 and 32KB) where the LOB locator cannot be used to reference the LOB value; Extended support for Stored Procedure Output parameters by the ExecuteNonQuery() method: now the parameters are populated with data returned; Removed a limitation in the maximum number of statements executed by ExecuteNonQuery() method and improved parametric query execution; Fixed a problem on Graphic data type with insert statements.
2.0.0.1	10/08/03	Installation: Added config file for Toolbox and improved GAC registration; Added Error Code Number: The error code number was missing in the ‘Error’ collection property of the Sql400Exception class. Improved support for Graphic and Vargraphic data types; Implemented specific override Dispose() methods; Added the 'Message' public property to class Sql400Error to return the string that identifies the error message.
2.0.0.0	09/19/03	Released “Ritmo for iSeries” and “Ritmo Client for iSeries”.