IBProvider v2.1.1

In this build we continued provider’s code verification and its preparation for the further development. We found and removed some errors both old (version 1.5) and of the newest versions. On the assumption of the preliminary tests, now the OLE DB provider can be used in Microsoft Analysis Service. All the corrections and extensions are applied to both 2.1.1 and 1.7.15 versions of IBProvider.

Corrected errors

• Receiving BLOB-fields through OUT-parameters in the «auto_commit=true» mode [Free IBProvider]
• Receiving arrays with text data in the formats DBTYPE_STR, DBTYPE_WSTR. The error appears in the «array_vt_type=false» mode [584 build]
• Converting arrays in DBTYPE_ARRAY | DBTYPE_STR, DBTYPE_ARRAY | DBTYPE_WSTR. The proper size of array item for text format storage [version 1.5] was defining incorrectly.
• Error reading binary and text («unicode_mode=false» mode) BLOB-fields through storage-objects. Incorrect return code. The problem was when reading data through linked MSSQL server [version 2.0 ?]
• Incorrect error code at non-existing information schema request. Data import into Excel didn’t work. [version 2.1]
• Metadata manager blocking was not implemented when reading TABLES_INFO information schema. Potential error for multithreaded applications. [version 1.6]

Updates

• Correct value of the property «DBMS Name«. The provider identifies «Firebird» and «Yaffil». In other cases returns «InterBase».
• Added the property of initialization and rowsets «ignore_unprepare«, which permits/forbids ignoring ICommandPrepare::Unprepare call. By default the provider ignores the call. If during the work of your program database structure changes, set this property in false.
• Added the following information properties:
  • «DBMS Version«
  • «Data Source Name«
  • «User Name«
  • «Catalog Term«
  • «Catalog Usage«
  • «Schema Term«
  • «Schema Usage«
  • «Transaction DDL«
  • «Persistent ID Type«
  • «Multiple Parameter Sets«
  • «Multi-Table Update«
  • «NULL Collation Order«
  • «NULL Concatenation Behavior«
  • «Heterogeneous Table Support«
  
  New properties (like all the previous) are set into the values, which reflect real possibilities of OLE DB provider and database server. I.e. we do not attempt to advance InterBase as Access or MSSQL.
• In the tracing build of the provider, forced log-file data writing on disk is off by default.