IBProvider v1.7.6.350 and v1.8.0.350 beta
Updates in the provider
1. Property of initialization and command «named_param_prefix«. This property determines prefix of the named parameters in the query text. Default value is «:». Provider supports prefixes, which consist of several characters, for example, «##». The characters of prefix can be any. If you set empty string into «named_param_prefix«, then provider will not support named parameters. This functionality is necessary with the executing of DDL queries.
2. Now COM+ transactions use isolation level indicated in the property of the initialization of the data source «auto_commit_level«. Focus your attention, that after connection you can change isolation level through «Autocommit Isolation Levels» property. From a technical point of view, COM+ transactions use the isolation level ISOLATIONLEVEL_UNSPECIFIED (-1).
By default «auto_commit_level» determines SNAPSHOT isolation level.
If you put «auto_commit_level» in -1 (ISOLATIONLEVEL_UNSPECIFIED), then SNAPSHOT isolation level will be used.
3. Work with BSTR data type is changed. Some OLE DB clients cannot interpret NULL as empty string. Therefore now IBProvider returns the available pointer to the empty string. The symmetrical problem is corrected in the client library — NULL-equaled BSTR is not passed to OLE DB providers.
4. The type of rowset bookmarks is changed. Now bookmarks are of DBTYPE_BYTES type and have unfixed length. Maximum size is 4 bytes.
Beta version 1.8
The basic purpose of version 1.8 is the implementation of the interfaces of the modification of the results of queries. In this case the foregoing mechanisms optimized for the read-only mode will remain in the provider. It are tested completely and do not cause any claims.
Nevertheless, there are the global changes in provider, which can disrupt the work of your applications. Therefore we imperatively recommend not to put aside functional test of beta 1.8 in your applications. If only you do not plan to remain to 1.7 after release of 1.8.
Focus your attention, during the registration DLL beta 1.8 and 1.7 mutually exclude each other. Therefore only one of these versions can be registered in the system.
The registered users can appeal to obtain limit-free beta-version.
Updates
1. The maximum size of the bookmarks is 8 bytes. Server cursor mode ceased to work in ADOExpresse. It is possible, entire matter is in the realization of OleVariant. We tested ADOAnywhere and ADO Express from BCB5. If you have a possibility to do tests with Delphi and BCB6, please, report to us about the results. When working with ADODB directly such problems were not discovered.
2. For tests, IOpenRowset will return the new realization of rowsets. At present this is the valuable and thoroughly tested replacement of foregoing read-only mechanism, and it is intended for the running-in of the new manager of rowsets.