Latest Flows from this sub-category:

random selection from this sub-category:

NetBulge.com Design and Development Website

OWES - Web development articles

Free Wordpress Blog Master Site Feed

Worldwide Brands Articles

Dotnet Related

{codesqueeze}

www.swprog.com - Articoli

PHP Freaks Content

www.swprog.com - Guide

Rss Directory > Programming > Article > IBProvider - news, releases, manuals

All rss from this site

Print this article

Webmasters ! Get this feed on your site

IBProvider - news, releases, manuals

IBProvider releases notes, documentation, code samples, articles

Mon, 07 Jul 2008 23:00:00 +0200

.:: New IBProvider Release Candidate 3 is available. Support of the integrated Windows authentication (SSPI) for Firebird 2.1, Support of long names and BOOLEAN type in Interbase 7.x and Interbase 2007, etc.::.

New IBProvider Release Candidate 3 is available. (ver: 3.0.0.4773)

Support of the integrated Windows authentication (SSPI) for Firebird 2.1.
Support of the system auth using environment variables: ISC_USER and ISC_PASSWORD.
Feature of enable/disable database triggers for separate connection is available.
Support of long names and BOOLEAN type in Interbase 7.x and Interbase 2007 was added.
Support of arrays was improved. Access to arrays via IBProvider now becomes more robust in comparison with other Firebird database access components.

Support of the Firebird 2.1 integrated Windows authentication (SSPI)

New initialization property Integrated Security allows using integrated Windows auth for Firebird 2.1. If the property will be set, then IBProvider will be ignoring User ID and Password properties.

Integrated Security can be used with FB 2.1 client version or higher.

The property can be set via connection string or in the Data Link editor.

Support of the system autentification using environment variables: ISC_USER and ISC_PASSWORD

User ID and Password initialization properties are defined as not mandatory. IBProvider will use environment variables ISC_USER and ISC_PASSWORD or integrated Windows authentication for Firebird 2.1.

This feature is also implemented in IBProvider v2.

Enable/Disable database triggers

New initialization property enable_db_triggers allows to enable/disable db triggers for separate connection.

Feature is supported only for Firebird client of any version.

Other

Informational property IB Client Level was removed.
Retrieve client version bug was fixed.
Automatic IBProvider core setup algorithms were improved and now it is used information about client version and client type (gds32 or fbclient.dll).
Small fixes were made for 64 bits version. And now it is recommended to update.

Support for long names and BOOLEAN type in Interbase 7.x and Interbase 2007 was added.

BOOLEAN type support was added for simple columns and columns with arrays.
Full Interbase API support was implemented. Long names can be used now (up to 67 symbols).

Configuration requirements:

Interbase client (gds32.dll) for Interbase 7.x version or higher.
Connection to the Interbase 7.x server version or higher.
Database ODS not less than 11.0.

New Interbase features are available only for 32 bits because IB does not have own 64 bits client.

Array's support was improved

IBProvider creates description for text arrays using connection code page and avoid incorrect db server behavior. This feature now is implemented for any server type and version (Interbase, Firebird, Yaffil), not only for FB 2.1.
For better work with arrays from VBScript array_type initialization property was added. It replaces array_vt_type initialization property.

Download IBProvider Professional Edition (64/32 bit) [ver: 3.0.0.4773].

Mon, 16 Jun 2008 23:00:00 +0200

.:: IBProvider releases have appeared. OCTETS character set support, data type converter release, 64 bits values in metadata schematics.::.

New IBProvider release has appeared

OCTETS character set and binary data support in IBProvider v3 was implemented.
Fixed bug occuring when accessing to VARCHAR columns with large size via MS SQL Linked server .
64 bits values in metadata schematics are now supported.
Data type converter was tested by 43000 unit tests.

OCTETS codepage and binary data support was implemented in IBProvider v. 3.0.0.4117

The driver correctly detects and transfers binary data stored in CHAR and VARCHAR columns with OCTETS codepage.
Selection and editing of binary data via ADODB library is now supported.

ActiveX component for working with binary data was released

New ActiveX component LCPI.IBP.Samples.BinaryVector provides simpler binary data work. Source codes are available in "Samples\oledb\sample_com_object" folder. 32 bits and 64 bits compilation has supported.

Fixed bug occuring when accessing to VARCHAR columns with large size via MS SQL Linked Server

Issues with data access to VARCHAR columns with size greater than 4000 via Linked Server were resolved.

64 bits values in metadata schematics are now supported

Data type for metadata columns was changed from UInt32 to UInt64:

COLUMNS::ORDINAL_POSITION
COLUMNS::CHARACTER_MAXIMUM_LENGTH
COLUMNS::CHARACTER_OCTET_LENGTH
PROCEDURE_COLUMNS::ORDINAL_POSITION
PROCEDURE_COLUMNS::CHARACTER_MAXIMUM_LENGTH
PROCEDURE_COLUMNS::CHARACTER_OCTET_LENGTH
PROCEDURE_PARAMETERS::CHARACTER_MAXIMUM_LENGTH
PROCEDURE_PARAMETERS::CHARACTER_OCTET_LENGTH
PROVIDER_TYPES::COLUMN_SIZE
PRIMARY_KEYS::ORDINAL
FOREIGN_KEYS::ORDINAL
KEY_COLUMN_USAGE::ORDINAL_POSITION
INDEXES::ORDINAL_POSITION

Data type for columns in IColumnsRowset was changed from UInt32 to UInt64:

DBCOLUMN_NUMBER
DBCOLUMN_COLUMNSIZE

Read about advantages of 64 bits in the article 10 reasons to upgrade Interbase and Firebird to 64 bits .

Data Type Converter

We have finished developing a new data type converter.

The advantages of the new converter are::

Multi-platform compatibility

The new converter does not use Windows API and OS information for type conversion. All operations are performed in IBProvider core.
Converter now uses memory copy and deallocation operations for VARIANT types in order to avoid problems with unsupported OLE DB types VT_I1, VT_UI2, VT_UI4, VT_I8, VT_UI8 in older Windows versions (9x, NT4, 2000).

Max support for OLE DB types

Support for value types, VARIANT type, arrays, and binary data types has been implemented.

Optimization

New converter has less internal method calls and less memory allocation.

Reliability

More than 43 000 unit tests were coded to test the new converter.

Data type converter and its tests source codes are now available

Converter source codes are located in "lib\ole_lib\oledb\variant" folder.
Converter tests are located in "TestCode\lib\ole_lib\oledb\variant\test_cvt" folder.
Other IBProvider tests are located in "TestCode\ActiveX\IBP" folder.

Download IBProvider Professional Edition (64/32 bit).

Sun, 11 May 2008 23:00:00 +0200

.:: IBProvider releases have appeared. New implementation of the data types converter.::.

IBProvider releases have appeared. New implementation of the data types converter.

New implementation of the data type's converter is available for all IBProvider versions:

IBProvider v.1.9.6.2491
IBProvider v.2.6.0.2491
IBProvider v.3.0.0.4047

In current releases we remove the most old source code of our OLE DB Provider. The first implementation of the type converter was coded at January 2000. The main update reasons are more simple architecture and faster features implementation.

General improvements

Test system was improved and found bugs were fixed. More than 15 000 tests coded.
Stricter control over the type conversion process.
Rounding for numeric conversion.
Support of the FILETIME OLEDB-type.
IConvertType::CanConvert implementation was improved.
OLEDB-types storage was optimized.

Date conversion improvements

Embedded string to date converter.
Supported date formats are:
- YYYY-MM-DD
- DD.MM.YYYY
Supported time formats are:
- HH:MM
- HH:MM:SS
- HH:MM:SS.FRACTION
Correct conversion for 2 digits year presentation.

Data Type converter source codes are available as a part of the IBProvider Professional Edition. See lib/ole_lib/oledb/oledb_variant.h file and classes: DBVARIANT, basic_dbvariant.

Test system for type converter is available in TestCode/lib/ole_lib/oledb/variant/test_cvt folder.

ODBC Escape Sequences Parser

Algorithm for avoiding Year 2000 problem has small bug fixes.

Download IBProvider Professional Edition (64/32 bit).

Sun, 06 Apr 2008 23:00:00 +0200

.:: New IBProvider v3 for 64 bits operational systems.::.

New IBProvider v3.0 RC2 [build 3997] for 64 bits operational systems

IBProvider v3, as well as C++ library for working with OLE DB providers now can be used as a part of 64 bits applications.

A component set of IBProvider Professional Edition is divided into two editions:

IBProvider Professional Edition for 32 bits - a standard version allowing to create only 32 bits applications.
IBProvider Professional Edition for 64/32 bits - a component package allowing to develop 32 as well as 64 bits applications.

IBProvider Professional Edition 64/32 bits component set

The edition includes 3 IBProvider versions for 32 bits and a new IBProvider v3 version for 64 bits.

The editions price:

A new IBProvider Professional Edition for 64/32 bits component set - 219 .
A standard IBProvider Professional Edition for 32 bits edition - 150 .

You may read about the advantages of 64 bits in the article 10 reasons to upgrade Interbase è Firebird application to 64 bits .

Download IBProvider Professional Edition for 64/32 bits

A gift to our clients

For registered clients who bought the IBProvider license after the 7 of April, 2007, 64 bits IBProvider version will be free of charge. IBProvider Professional Edition

Mon, 10 Mar 2008 22:00:00 +0100

.:: New build No 3965 of IBProvider v 3.0 RC2 has appeared.::.

New build No 3965 of IBProvider v.3.0 RC2 has appeared

Support of date and time formats was improved

Validation for date parts and for date ranges has added
Check for the conversion between ISC and OLE DB date formats has implemented
Date range for ISC format was extended:

01.03.0000 [isc code: -678881]

27.5.5881469 [isc code: 2147483647]

Firebird

01.01.0001

Firebird

31.12.9999

Date algorithms are implemented as stand along and do not depend on the fbclient.dll/gds32.dll version

Behavior of the Rollback command has changed

If Rollback command executing and transaction state is inactive then error No active transaction will be raised. This is the default behavior.

For the backward compatibility 2 properties has added:

tr_abort_flags initialization property
Session Transaction Abort Flags session property

Other changes

Small bugs were fixed in OLE DB errors processing code

New IBProvider v 3.0 can be downloaded as a path of the IBProvider Professional Edition.

Thu, 07 Feb 2008 22:00:00 +0100

.:: New IBProvider releases have appeared. Visual Studio 2008 support and DTC support were improved, known bugs were fixed and Firebird/Interbase compatibility was enhanced.::.

New IBProvider releases have appeared. Visual Studio 2008 support and DTC support were improved, known bugs were fixed and Firebird/Interbase compatibility was enhanced.

IBProvider v3 RC2 [build 3.0.0.3861]:

Implemented support of Server Explorer for Visual Studio 2008.
New WIN1258 code page was added.
Loading CHAR-arrays bug was fixed.
Errors handling implementation for Ole DB properties was strongly conformed to OLE DB standard.

IBProvider v1, v2

The bug concerning dynamic memory heap was fixed.

Firebird 2.x compatibility was improved

Firebird 2 and Firebird 2.1

Text arrays' support was improved. Known FB server bugs were fixed on the IBProvider level.

Backward compatibility mode

When you tried to attach database which was created in older versions of FB (FB1.5, FB1, FB 0.9.4) to Firebird 2.x you can get an incorrect behavior. Now all known issues were closed.

ODBC escape sequences parser was improved

ODBC function TIMESTAMPADD gets an optional parameter QUARTER.
ODBC function LOCATE was optimized.

See the completed guide to ODBC Escape Sequences.

VIEWS support was improved

Solving problems while using FB/IB views from MS SQL Linked Server.
COLUMNS scheme. Nullable attribute for view columns is now calculated correctly for Firebird 1.5, FB 2.x, Interbase 2007.
Interbase 4 compatibility was improved. Loading VIEWS scheme issue was fixed.

Essential improvement of the DTC support

DTC - Distributed Transaction Coordinator.

DTC applies in:

MS SQL Linked Server uses DTC for synchronization the local transactions with linked server transactions.
The realization of the distributed transaction through the TransactionScope class in .Net Framework

For all IBProvider versions

Control improvement: Now if transaction is connected to DTC, it can not be finished through session methods (Commit or Rollback).
ITransaction::GetTransactionInfo. If the transaction is connected to DTC, the method returns UOW (UnitOfWork) identifier of the distributed transaction.
Two-phase commit was supported.

Two-phase commit (Two-phase transaction)

The Transaction commit has 2 phases:
Preparation phase - all the members of the distributed transaction are interrogated on commit end.

Commit phase - If all the members are ready to commit transaction, the coordinator sends the commit order.

It is guaranteed that all the members of the distributed transaction stay in agreed circumstances.

IBProvider v3

Additional control for commit the transaction connected to DTC through the SQL requests.

Summary

We constantly work to provide our clients with the reliable, functional and general-purpose decision that lets realize any projects on Firebird and Interbase.

The new release is one more possibility to feel the whole power of modern development tools, reduce the expenses and solve tasks in a short period of time.

New releases are available to anyone.

Tue, 25 Dec 2007 22:00:00 +0100

.:: We have changed the IBProvider license agreements and now give discounts.::.

We have changed the IBProvider license agreements and now give discounts.

About the license agreements:

You can purchase IBProvider using 3 license types:

Single Developer license.
Site license to use the software by the unlimited number of developers within a single physical location (building) of an organization.
Enterprise license to use the software by the unlimited number of developers within a single organization all around the world.

About discounts:

We offer volume discounts for the Single Developer license and a 20% discount for the renewal of the one-year subscription for updates. Price list and the license agreements are available on the purchase page.

Wed, 07 Nov 2007 22:00:00 +0100

.:: The second Russian Firebird and Interbase conference will take place in Moscow, November 23, 2007::.

The second Russian Firebird and Interbase conference will take place in Moscow, November 23, 2007

Participators are Firebird Core developers Dmitry Yemanov, Vlad Horsun and Aleksey Pechkov, IBase company Chief Dmitry Kuzmenko, Code Gear product manager Aleksey Kovyazin, Louis Santos from Unimep, and other known developers and Professionals from Firebird and Interbase world.

IBProvider Team will also be on the conference and present IBProvider v3 Release Candidate 2. IBProvider developers: Kovalenko Dmitry, Piminov Roman and Andrew Merkulov will answer as many questions as time permits.

Andrew Merkulov scheduled presentation "IBProvider. A way to modern developer environments".

Draft plan of the presentation:

Creating solutions for Firebird and Interbase on Microsoft SQL Server 2005

SQL Server Management Studio. Distributed queries and the Linked Server technology.
Microsoft SQL Server 2005 Business Intelligence for Firebird and Interbase

Integrations Services. Developing ETL processes. Extract, transform and load data. SSIS packages.
Reporting Services. Report development.
Analysis Services. OLAP-cubes.

ODBC Escape sequences.

New IBProvider SQL parser which supports ODBC Escape Sequences will be presented and examples will be shown.

We will offer special reduced price on IBProvider CD Edition for conference attendees. You can register attendees from your company and read details on the official conference homepage [RU].

Mon, 29 Oct 2007 22:00:00 +0100

.:: IBProvider Free Edition (3.0.0.3313 Release Candidate 2 [RC2]) has appeared.::.

IBProvider v3 Free Edition (3.0.0.3313 Release Candidate 2 [RC2]) has appeared.

RC2 include the following new features:

New Firebird 2.1 SQL statements;
ODBC Escape Sequences (ODBC 3.5)
New information properties were added. IB Client, IB Client Version and IB Client Name allow reading version info from client library (fbclient, gds32);

IBProvider Free Edition no more support of Interbase servers beginning from version 6.5. This feature will be enabled only in IBProvider Professional Edition.

Sun, 28 Oct 2007 22:00:00 +0100

.:: IBProvider v3 Release Candidate 2 (RC2) has appeared.::.

IBProvider v3 Release Candidate 2 (RC2) has appeared.

IBProvider team is pleased to announce IBProvider v3 Release Candidate 2, which already become a part of IBProvider Professional Edition. We have fixed all known bugs and implemented new unique features.

ODBC Escape Sequences (ODBC 3.5)(ODBC 3.5):

69 ODBC functions (including string, math, system, convert and date time functions);
3 sequences for getting date and time;
The ODBC CALL escape sequence for calling a procedure;

Firebird 2.1 is supported:

New SQL statements:
INSERT OR UPDATE, UPDATE ... RETURNING, DELETE ... RETURNING.
You can read details in the article: Using of Firebird 2.1 features in the ADO .Net
Provider core algorithms were optimized.
RDB$PROCEDURE_TYPE feature was implemented. It is allowing quick Prepare() for stored procedures.

New information properties were added. IB Client, IB Client Version and IB Client Name allow reading version info from client library (fbclient, gds32)

IBProvider Professional Edition.

Integration with Microsoft Office has improved.

Current release is support:

Microsoft Word Mail Merge Wizard. You can retrieve data from Interbase and Firebird and use them in the mailing automation.
Microsoft Excel Import Data Wizard. You can import data from single table or as a join of many tables through the SQL query.

More about improvements you will read in the news from 18 October 2007

IBProvider has known about 13 database server types, include Firebird 2.1 and Interbase 2007 It is automatically setup own core when client connect to a server. Setup has included the following actions:

Defining keywords list and reserved words list;
Loading an ODBC Escape Sequences parser;
Selecting nested transaction algorithms;
Selecting other server algorithms;
Selecting a metadata provider;
Detecting a supported dialect;

IBProvider has made connection stable, standard and simple, thus client do not worry about low level database interaction and only think about own business tasks.

Support of Microsoft SQL Server 2005 and Business Intelligence

Linked Server technology is a simple way to integrate applications based on Microsoft SQL Server with applications, based on another data sources. IBProvider support this technology, therefore integration with SQL Server now available for Firebird and Interbase.

Under Business Intelligence term we have found powerful toolkit for developing wide type of applications. It has included:

Reporting Services for creating and delivering reports;
Integrations Services for developing ETL processes (Extract, Transform, Load );
Analysis Services for effective data mining and multidimensional analysis. OLAP;

IBProvider support ODBC Escape Sequences. This feature allows applying all power of multidimensional analysis in Analysis Services, and with small efforts getting information in time dimensions and doing mathematical calculations.

Currently OLE DB is supported by most environments and toolkits including:

Visual Studio 6.0, Visual Studio .Net;
Microsoft Office, VBA;
C++ Builder and Delphi;
WSH, VBScript, Java Script;
ASP, ASP .Net;
Crystal Reports;
Microsoft SQL Server 2000 and 2005, including Business Intelligence (Integration, Reporting and Analysis Services);

IBProvider is offering solution, which can be easy integrated into the developing process and used with most environments or toolkits.

IBProvider is the ideal solution for desktop applications with embedded database and for large projects with gigabyte-sized databases, with ETL, data mining and analysis processes.

Download IBProvider Professional Edition right now.