Publish date: 2003-01-01
Updated: 2015-10-29

Frequently asked questions

Question 1 I get the message: The requested feature [idbschemarowset::getschema] is available in the commercial version of IBProvider [www.ibprovider.com] only
Question 2 I get the message while connecting to the InterBase database: Free IBProvider can’t work with Database Server (1) Version (2). Original Server ID=(3). Support of this RDBMS is available in the commercial version of IBProvider [www.ibprovider.com] only.
Question 3 Does IBProvider provide access Firebird Delphi and InterBase Delphi?
Question 4 When I do a simple SQL SELECT, I get an error saying «Automatic transaction is disabled«. Do you have any ideas?
Question 5 Is it possible to combine «auto_commit» with manual transaction handling?
Question 6 How to set such specific for IB/FB properties of transaction as for example «wait» and «no wait«?
Question 7 Why do opening rowsets have the attribute read-only?
Question 8 While using IBProvider v2 in ADOExpress the server cursor doesn’t work. It works in the first version.
Question 9 Why my active connections are still alive?



Question 1: I get the message: The requested feature [idbschemarowset::getschema] is available in the commercial version of IBProvider [www.ibprovider.com] only
IBProvider Free Edition has functional restrictions: metadata schemas and InterBase DBMS greater than 6 version are not supported. To avoid such messages please use  IBProvider Professional Edition.
Question 2: I get the message while connecting to the InterBase database: Free IBProvider can’t work with Database Server (1) Version (2). Original Server ID=(3). Support of this RDBMS is available in the commercial version of IBProvider [www.ibprovider.com] only.
Only IBProvider Professional Edition provide access to the InterBase database greater than 6 version.
Question 3: Does IBProvider provide access Firebird Delphi and InterBase Delphi?
There are 3 way for access to InterBase and Firebird from Delphi (RAD Studio):
  • dbGo (ADO Express) components provide access via ADO library.
  • Direct access to COM-interfaces of ADO library.
  • Direct access to OLE DB-interfaces using 3rd party components (OLE DB Direct/OLE DB Express).
See examples of using Firebird and InterBase from Delphi via ADO + MTS: Firebird Delphi and InterBase Delphi
Question 4: When I do a simple SQL SELECT, I get an error saying «Automatic transaction is disabled«. Do you have any ideas?
To automatically start and commit of transaction need to specify in connection string — «auto_commit=true».
Question 5: Is it possible to combine «auto_commit» with manual transaction handling?
Yes, you can handle transactions manually in «auto_commit» mode. IBProvider begins transactions if only there are no started transaction in current session.
Question 6: How to set such specific for IB/FB properties of transaction as for example «wait» and «no wait«?
This properties can be set only with the starting of transactions through SQL commands (see ADO sample)
For obtaining the more detailed information look in IB/FB documentation syntax of «SET TRANSACTION» command.
Question 7: Why do opening rowsets have the attribute read-only?
Most probably you use Free IBProvider. In this version the columns of the result rowset don’t have the attribute permitting writing. The commercial version has this attribute.
Question 8: While using IBProvider v2 in ADOExpress the server cursor doesn’t work. It works in the first version.
The problem is in ADOExpress. These components can’t work with 8-bytes rows bookmarks used in IBProvider v2. In the first version (also included into the distribution kit of the commercial version) 4-bytes bookmarks, supported by ADOExpress are used. That’s why when working with the second version through the ADOExpress you can use only ClientCursor. Also you can use another access VCL-components which have no such restriction, for example, OLEDBDirect.
Question 9: Why my active connections are still alive?
Most likely it operates the connection pool. To disable connection pooling — specify in the connection string the «OLE DB Services» with null value of first (zero) bit.

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