TIBConnection class

In unit IBConnection

TIBConnection: Firebird/Interbase specific TSQLConnection.

Declaration

pascal

TIBConnection = class(TSQLConnection)

Inheritance

Description

TIBConnection is a descendant of TSQLConnection and represents a connection to a Firebird/Interbase server.

It is designed to work with Interbase 6, Firebird 1 and newer database servers.

TIBConnection by default requires the Firebird/Interbase client library (e.g. gds32.dll, libfbclient.so, fbclient.dll,fbembed.dll) and its dependencies to be installed on the system. The bitness between library and your application must match: e.g. use 32 bit fbclient when developing a 32 bit application on 64 bit Linux.

On Windows, in accordance with the regular Windows way of loading DLLs, the library can also be in the executable directory. In fact, this directory is searched first, and might be a good option for distributing software to end users as it eliminates problems with incompatible DLL versions.

TIBConnection is based on FPC Interbase/Firebird code (ibase60.inc) that tries to load the client library. If you want to use Firebird embedded, make sure the embedded library is searched/loaded first. There are several ways to do this:

Include ibase60 in your uses clause, set UseEmbeddedFirebird to true
On Windows, with FPC newer than 2.5.1, put fbembed.dll in your application directory
On Windows, put the fbembed.dll in your application directory and rename it to fbclient.dll

Pre 2.5.1 versions of FPC did not try to load the fbembed library by default. See FPC bug 17664 for more details.

An indication of which DLLs need to be installed on Windows (Firebird 2.5, differs between versions:

fbclient.dll (or fbembed.dll)
firebird.msg
ib_util.dll
icudt30.dll
icuin30.dll
icuuc30.dll
msvcp80.dll
msvcr80.dll

Please see your database documentation for details.

The TIBConnection component does not reliably detect computed fields as such. This means that automatically generated update SQL statements will attempt to update these fields, resulting in SQL errors. These errors can be avoided by removing the pfInUpdate flag from the provideroptions from a field, once it has been created:

MyQuery.FieldByName('full_name').ProviderFlags:=[];

Properties

`BlobSegmentSize`	public	Write this amount of bytes per BLOB segment.
`ODSMajorVersion`	public	Database On-Disk Structure major version.
`DatabaseName`	published	Name of the database to connect to.
`Dialect`	published	Database dialect.
`CheckTransactionParams`	published	Let StartTransaction check transaction parameters.
`KeepConnection`	published	Keep open connection after first query.
`LoginPrompt`	published	Switch for showing custom login prompt.
`Params`	published	Firebird/Interbase specific parameters.
`Port`	published	Port at which the server listens.
`UseConnectionCharSetIfNone`	published	For string/blob fields with codepage none, use the connection character set when copying data.
`WireCompression`	published	Use wire compression when communicating with the server.

Methods

`DoConnect`	protected
`DoInternalConnect`	protected
`DoInternalDisconnect`	protected
`GetHandle`	protected
`AllocateCursorHandle`	protected
`DeAllocateCursorHandle`	protected
`AllocateTransactionHandle`	protected
`PrepareStatement`	protected
`UnPrepareStatement`	protected
`FreeFldBuffers`	protected
`Execute`	protected
`AddFieldDefs`	protected
`Fetch`	protected
`LoadField`	protected
`GetTransactionHandle`	protected
`Commit`	protected
`RollBack`	protected
`StartDBTransaction`	protected
`CommitRetaining`	protected
`RollBackRetaining`	protected
`UpdateIndexDefs`	protected
`LoadBlobIntoBuffer`	protected
`RowsAffected`	protected
`GetSchemaInfoSQL`	protected
`GetNextValueSQL`	protected
`Create`	public	Creates a TIBConnection object.
`GetConnectionInfo`	public	Return some information about the connection.
`CreateDB`	public	Creates a database on disk.
`DropDB`	public	Deletes a database from disk.