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):
| |
| 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 https://www.ibprovider.com/eng required.