IBProvider - New providers versions in the Professional Edition now can be used with Microsoft SQL Server 2005 Business Intelligence Development Studio [13-09-2007].

Home

News

Forum

New providers versions from Professional Edition now can be used with Microsoft SQL Server 2005 Business Intelligence Development Studio

The following features were implemented:

Parsing queries, which contain names with square brackets. For example: "select [column1] as c1, [column2] from [table_name]"

Firebird and Interbase not allowing square brackets for names (only for array indexes), but SQL Server 2005 Business Intelligence using them by default. That's why we are implemented this feature in the IBProvider. For enabling processing square brackets you must set support_square_delim_name property in the connection string. By default processing will not be performed.

IBProvider support 2 processing modes. When sql-parser will find square brackets in sql query:
- it will replace them with the double quotation marks [ support_square_delim_name = 1];
- there are 2 ways: if name in square brackets placed after reserved keyword, brackets will be replaced with double quotation marks, otherwise IBProvider assume what name in square brackets is array index and it will be kept [ support_square_delim_name = 2] (only in IBProvider v3);

ICommand::Cancel behavior was revised according to OLE DB documentaion. Now provider check active command. This is fix the problem with "Can't cancel query" message in the SQL Server 2005 Business Intelligence.

You can use Firebird or Interbase database in the SQL Server 2005 Business Intelligence Development Studio only with IBProvider Professional Edition:

IBProvider v1 (1.9.2.2210) (read only mode)
IBProvider v2 (2.5.2.2210) (read/write mode)
IBProvider v3 (3.0.0.2887) (read only mode)

Change notes for all editions:

IB GDS32 Version property was renamed to IB Client Level
IB Version property was renamed to IB Base

IBProvider v3 [build 2887]

Reserved words are defined for concrete server type and major version (IB/FB/Ya). In OLE DB they can be retrived through the IDBInfo::GetKeywords function and in ADO - through the adSchemaDBInfoKeywords schema.
[bug fixed] Parser was ignore database dialect when it was convert query "table_name" to "select * from table_name".
[bug fixed] Incorrect parsing of names with double quotation marks, for example: "select * from "table_name""".
Nested transactions now fully supported for Interbase DBMS.
keywords_list Initialization property was added.
IB Release Savepoint After Rollback property was removed.
IB Savepoint Support information property was added.
New information properties for checking client library were added:
Values are read from VERSIONINFO resource of the client library (gds32 or fbclient).

IBProvider 2.5.2.2210/1.9.2.2210. Release.

New ODBC functions for OBDC sequences are implemented: BIT_LENGTH, LCASE, CHAR_LENGTH, CHARACTER_LENGTH, OCTET_LENGTH, CONCAT, LTRIM, RTRIM, SUBSTRING, LEFT, LENGTH, RIGHT, IFNULL.
[bug fixed] CAST to SMALLINT was added for the following ODBC functions: DAYOFWEEK, DAYOFYEAR, QUARTER, WEEK. This is required for stable work in the ADO library.
[bug fixed] ignore_err_param property wasn't available in the IDBProperies collection.

C++ library. New sources are available. Look into the lib/structure folder for details.

Download IBProvider Professional Edition.. Soon we are will publish samples and states of using IBProvider with Microsoft SQL Server 2005 Business Intelligence Development Studio. Please subscribe to the our rss feed.

P.S. IBProvider Free edition will be updated later.

All

Publish date: 13-09-2007. Copyright: IBProvider. This material may be reproduced on other web sites, without written permission but link to http://www.ibprovider.com required.

All IBProvider news:

	06-11-2008	New IBProvider � support of 49 code pages, ability to work without provider registering, prevention of memory leaks in Firebird client.
	03-10-2008	In the new edition of IBProvider Professional 7 codepages support was implemented, bugs were fixed, BLOB-fields access and memory management was improved
	25-08-2008	The 6 world-wide Firebird Conference in Bergamo, Italy
	30-07-2008	IBProvider updates are available. Operation with NUMERIC-types and connection pooling were improved. External and temporary tables support in metadata schemes was added. Disabled metadata cache mode performance was increased in 2.5 times.
	08-07-2008	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.
	17-06-2008	IBProvider releases have appeared. OCTETS character set support, data type converter release, 64 bits values in metadata schematics.
	12-05-2008	IBProvider releases have appeared. New implementation of the data types converter.
	07-04-2008	New IBProvider v3 for 64 bits operational systems.
	11-03-2008	New build No 3965 of IBProvider v 3.0 RC2 has appeared.
	08-02-2008	New IBProvider releases have appeared. Visual Studio 2008 support and DTC support were improved, known bugs were fixed and Firebird/Interbase compatibility was enhanced.
	26-12-2007	We have changed the IBProvider license agreements and now give discounts.
	08-11-2007	The second Russian Firebird and Interbase conference will take place in Moscow, November 23, 2007
	30-10-2007	IBProvider Free Edition (3.0.0.3313 Release Candidate 2 [RC2]) has appeared.
	29-10-2007	IBProvider v3 Release Candidate 2 (RC2) has appeared.
	18-10-2007	New release of the IBProvider Professional Edition appears. We have improved Integration with Microsoft office and fixed known bugs.
	13-09-2007	New providers versions in the Professional Edition now can be used with Microsoft SQL Server 2005 Business Intelligence Development Studio
	20-07-2007	The latest editions of IBProvider Professional and IBProvider Free now support new features of Firebird 2.1
	25-05-2007	Download engine now working. All customers will receive personal releases more quikly.
	27-04-2007	The latest editions of IBProvider Professional and IBProvider Free are available for download.
	13-12-2006	C++ client library for OLE DB-providers now support the Unicode project types (which based on unicode strings).
	04-12-2006	New releases appear: IBProvider Professional Edition - is a professional developer kit for Interbase and Firebird. IBProvider Free Edition - is an absolutely free of charge and most powerful version based on the commercial core of IBProvider v3.
	07-10-2006	IBProvider 3.0.0.2385 [RC1] and IBProvider 2.5.0.2088 [Release] now avaliable. New properties aliases: Charset, PSWD. Metadata reading algorithm and SQL parser was optimized. Supporting arrays in ADO .Net.
	28-08-2006	IBProvider 3.0.0.2065 [Beta]. IBProvider 2.4.7.2034 [Release]. MSSQL 2000/2005 integration improvement.
	13-08-2006	IBProvider 3.0.0.1959 [Beta]. IBProvider 2.4.6.1989 [Release]. �++ library for OLEDB providers now support VC8 (VS2005)
	25-05-2006	IBProvider 3.0.0.1324 [Beta]. IBProvider 2.4.5.1953 [Release]. Client Library for C++.
	05-05-2006	IBProvider price will be changed after 23 may 2006. New demo versions are avalible
	30-03-2006	IBProvider release v.2.4.4 (v.1.7.26) build 1885 now available. IBProvider v.3 [build 1107. beta]
	27-02-2006	IBProvider v.1/v.2 [build 1877 Release Candidate 1]. IBProvider v.3 [build 1062. beta]
	30-11-2005	IBProvider 2.4.3.1859. Release.
	01-11-2005	Fix of problem with arithmetic errors in .NET applications.
	28-09-2005	IBProvider v3 [build 913] [beta version].
	22-09-2005	IBProvider v3 [build 890] [beta version]. IBProvider v2/v1 [build 1811].
	01-09-2005	The InterBase and Firebird Developer Magazine.
	28-07-2005	IBProvider v3 [build 789] [beta version]. IBProvider v2/v1 [build 1802].
	15-06-2005	IBProvider v3 [build 779] [beta version]. IBProvider v2/v1 [build 1795].
	12-04-2005	IBProvider User Forum is Open
	22-03-2005	IBProvider 2.4.2.1772. Release.
	28-02-2005	IBProvider 3.0.0.639 beta. Change of the corporate license.
	11-02-2005	IBProvider 3.0.0.573 beta.
	24-12-2004	IBProvider 3.0.0.449 beta.
	12-11-2004	IBProvider 2.4.1.1720/1.7.23.1720. Release.
	31-05-2004	IBProvider 2.4.0.1607/1.7.22.1607. Release.
	14-05-2004	Release Candidate 2.4.0.1588/1.7.22.1588
	30-04-2004	Version 2.3.3.1523 beta
	29-03-2004	Version 2.3.3.1416 beta
	17-12-2003	Version 2.3.3.1300
	18-10-2003	Version 2.3.2.1233
	22-08-2003	Version 2.3.1.1184
	25-06-2003	Version 2.3.0.1134 - extended support of MS AS, MS SQL
	23-04-2003	Version 2.2.0.969 - Data Links dialog support, localization
	31-03-2003	Version 2.1.2.
	26-03-2003	Version 2.1.1.
	04-03-2003	Version 2.1. The error processing mechanism is completely reconstructed.
	26-02-2003	Discounts on IBProvider.
	18-02-2003	Changes in License Terms
	23-01-2003	Version 2.0.1.735. Bug fix, optimization, HTML help
	10-12-2002	The second generation IBProvider
	21-11-2002	Version 1.7.11.584 and 1.8.0.584 beta
	06-11-2002	Version 1.7.10.542 and 1.8.0.542 beta
	20-10-2002	Version 1.7.9.481 and 1.8.0.481 beta
	12-08-2002	Version 1.7.6.350 and 1.8.0.350 beta
	30-07-2002	Version 1.7.5.311 - Bugs fixing
	10-07-2002	Version 1.7.4.289
	20-06-2002	Version 1.7.3.269
	30-05-2002	Version 1.7.2.255
	08-05-2002	Version 1.7.1
	22-04-2002	Version 1.7.0.227. Support of UNICODE. New prices.
	29-03-2002	Version 1.6.3.213
	28-02-2002	Version 1.6.2.201
	08-02-2002	Version 1.6.2.199
	19-01-2002	Version 1.6.1.185
	24-12-2001	Free Version 1.5.2
	13-12-2001	Version 1.6
	14-11-2001	1.5.1 - Change of Compiler. Optimization. IColumnsRowset. etc.
	30-08-2001	IN-OUT Parameters. Arrays. ....
	16-07-2001	Error with test of connection in Data Links
	21-05-2001	Support of stored procedure
	16-05-2001	New samples on Delphi for MTS from Andrei Semak
	14-05-2001	The final touches to RowSet
	30-04-2001	Commercial release
	20-04-2001	Support of DTC and Resource pooling
	04-04-2001	Support of null-containing character arrays
	16-03-2001	Implementaion of IOpenRowset::OpenRowset
	15-03-2001	Support of DECIMAL and NUMERIC
	12-03-2001	Errors correction...
	01-03-2001	Fix bug in command prepare
	03-01-2001	The main cardinal change is in accordance with implementation of operation auto-commit support.
	01-12-2000	IBProvider and client library Reconstruction.
	15-09-2000	New version of IBProvider for IB6.

Firebird and Interbase related articles

Site Build No. 3.0.0.1660