IBProvider 3.0.0.1959 [Beta]. IBProvider 2.4.6.1989 [Release]

Bug fixes

• Data loading mode checking with DBMEMOWNER_PROVIDEROWNED
• Bug in IDBSchemaRowset::GetSchemas(). Parameter prgRestrictionSupport can be Null
• Schema columns names was corrected:
• PROVIDER_TYPES::CASE_SENSITIVE
• PROVIDER_TYPES::BEST_MATCH
• CHARACTER_SETS::NUMBER_OF_CHARACTERS
• FOREIGN_KEYS::DELETE_RULE
• TABLE_CONSTRAINTS::INITIALLY_DEFERRED
• Bug in type and columns size:
• VIEWS::DESCRIPTIONS
• Bugs in Rowset properties descriptions

IBProvider 3.0.0.1959 [Beta]

• Was compiled with VC8 (VS2005). Named signature is _IBProvider_x3_xxx.dll
• FPU management code was removed from IBProvider v3
• Now support loading data from MSSQL 2000 linked-server
• Now support Microsoft Excel 2003 data exporting
• New schemata’s:
• COLUMNS
• PROCEDURES
• PROCEDURE_PARAMETERS
• PROCEDURE_COLUMNS
• New command and data source property ado_exec_sp. Replace std_exec_sp.
Avaliable values:
0 — convert query «exec SP» to the «select * from SP»
1 — convert query «exec SP» to the «execute procedure SP»
2 — [default value] automatic conversion mode


• odbc_call_sp property was improved by new value:
2 — [default value] automatic conversion mode for stored procedures queries


• New Connection String property schema_sp_params.
Detect schemata’s loading modes: PROCEDURE_PARAMETERS or PROCEDURE_COLUMNS:
0 — PROCEDURE_COLUMNS contains all stored procedure OUT-parameters
1 — PROCEDURE_PARAMETERS contains all stored procedure OUT-parameters with IN-parameters. IBProviders v1 and v2 supports only this mode
2 — [default value] automatic mode. If stored procedure return result set, OUT-parameters will be in PROCEDURE_COLUMNS schema, else if SP return OUT-parameters then its info will be in PROCEDURE_PARAMETERS

IBProvider detect stored procedure returned type by SUSPEND keyword and returned values list (RETURNS). It analyze stored procedure BLR or stored procedure source code

IBProvider v3 now included in commercial release and available for customers.