Publish date: 2003-06-25

IBProvider v2.3.0.1134 — extended support of MS AS and MS SQL

We are glad to inform you that the work on new version of OLE DB provider is completed. The version ensures the new level of integration of InterBase with Microsoft data processing services.

Builds no. 2.3.0.1134 and 1.7.18.1134 are included in distributive kit.

Thanks to

  • Gabhan O’Loughlin. Professional testing of provider with ADO Express.
  • Vladislav Shumov. Interaction with MS Analysis Services.
  • Sean Rudd. Call-in of InterBase stored procedures through MS SQL.

Provider initialization properties

Informative properties

Rowset properties

Updates

  • Restoration of property default value is realized. Assign to a property empty to restore its initial value.
  • Support of obtaining the result of command in form of object with IMultipleResults interface is realized.
  • There are many other changes directed toward an improvement in the code and a correspondence to OLE DB standard.

Support of ODBC-function in command text

  • Date and time functions: CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURDATE, CURTIME, DAYNAME, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, EXTRACT, HOUR, MINUTE, MONTH, MONTHNAME, NOW, QUARTER, SECOND, WEEK, YEAR.
  • Data conversion function: CONVERT
  • System function: USER
  • String function: UCASE

The most complete support of ODBC-functions is achieved when working with the databases of the third dialect.

Support of ODBC call-in of stored procedures

New SQL parser allows improved support of ODBC-queries for executing stored procedures:

{[?=]call procedure-name[([parameter][,[parameter]]…)]}

Currently the provider:

  • supports default parameters. If in-parameter is not defined or DEFAULT keyword is indicated, then the provider assigns to the parameter NULL.
  • allows to indicate markers for out-parameters.

See the new examples, which show the using of ODBC call-ins of the stored procedures.

New SQL parser

We shut one of the most complex problems existed in provider — the correct identification of the SQL queries. In other words: we realized more or less full-fledged SQL parser. It does not mean that the provider carries out full analysis of SQL queries. As yet there is no need for this. The basic merit of new mechanism of executing SQL queries is its scaling as with respect to «real» queries, which will be executed on server, so those, which execution is emulated by the provider (e.g. drop database, ODBC call-in of stored procedure).

Compatibility

All accomplished work was started for the solution of the problems of the use of the provider in the composition with:

  • MS Analysis Services.
  • MS SQL Server. Call-in of stored procedures. MSSQL uses sort of ODBC queries to call stored procedures.

New examples

New examples were created with use of Windows Script Host (WSH) components. PrimalScript 3.0 was used for editing (www.sapien.com). Source downloading is accessible.

Publish date: 2003-06-25. Copyright: IBProvider. This material may be reproduced on other web sites, without written permission but link https://www.ibprovider.com/eng required.
All news
Previous news
IBProvider v2.2.0.969 — «Data Links» dialog support, localization
Next news
IBProvider v2.3.1.1184