IBProvider 3.10. Improved a support of MS DTS and SSIS. Fixed known bugs

Corrections

• [OLEDB.NET] null value of command parameters is now passed in the database as NULL.
• Fixed an error in code for reading a BLOB.
• Reworked the algorithms associated with arrays.
• Added a support of parameters with datatype DBTYPE_ERROR.
• The columns and parameters with datatypes DBTYPE_DBTIME and DBTYPE_DBDATE now defined with precision and scale. Common table of datetime types:
  
  

  Datatype	Precision	Scale
  DBTYPE_DBTIME	8	0
  DBTYPE_DBDATE	10	0
  DBTYPE_DBTIMESTAMP	24	4
  DBTYPE_DBTIME2 (?)	13	4

The support of MS DTS and SSIS was improved

• The IBProvider installation now contains the XML files with rules of datatype transformation for copying from InterBase/Firebird databases into MSSQL (2005, 2008) databases. Look into «LCPI_IBProvider\Integrations\MSSQL DTS» folder.
• Defined a new initialization property «open_rowset__sql«. It allows the execution of SQL through IOpenRowset::OpenRowset method. Install this property to true. You can configure this property through GUI of DataLink dialog:
  
  

Short rules for work with MS DTS and SSIS (MSSQL 2005, 2008)

1. Copy the XML-files from «LCPI_IBProvider\Integrations\MSSQL DTS» into «DTS\MappingFiles» of your MSSQL installation.
2. Configure the next properties:
   • auto_commit=true
   • open_rowset__sql=true
   • unicode_mode=true
   • ctype
   • ctype_none (if your text data have a NONE charset)
3. If your database contains the errors in system tables, try to set «schema_cache=0″.