Publish date: 2006-08-28
IBProvider 3.0.0.2065 [Beta]. IBProvider 2.4.7.2034 [Release]. MS SQL 2000/2005 integration improvement
IBProvider v2.4.7.2034
- New implementation of ITransactionJoin interface. See below.
- Memory usage optimized.
IBProvider v3.0.0.2065 [Beta]
- New implementation of ITransactionJoin interface. See below.
- RowsAffected bug was fixed. For Stored procedure queries and select queries RowsAffected parameter will be set to -1.
- Yaffil SQL Server connection bug was fixed.
- Now support stored procedure parameters view through the Server Explorer VS 2005. Schemata PROCEDURE_COLUMNS now contains column PARAMETER_NAME.
- Schemas’ reading was optimized. Database usage and Restriction Processing optimization.
- Some bugs were fixed.
MS SQL integration
We fixed a critical bug in the ITransactionJoin interface. Now IBProvider is most compatible with MSSQL and you can use manual transaction management. For beginning transaction, execute «BEGIN DISTRIBUTED TRANSACTION» query. Before update data you must execute «SET XACT_ABORT ON» command. Read article for details. Here you can find an updated example of MSSQL Linked Server interaction.
When you configure MS SQL 2000/2005 linked server, do not forget to check «Allow InProcess» option.
Publish date: 2006-08-28. Copyright: IBProvider. This material may be reproduced on other web sites, without written permission but link https://www.ibprovider.com/eng required.