Book Home

Contents
Preface


OpenLink ODBC Driver for Firebird (Express Edition) for Mac OS X
OpenLink ODBC Driver for Firebird (Express Edition) for Windows
Installation Configuration

4.2. OpenLink ODBC Driver for Firebird (Express Edition) for Windows

4.2.1. Installation

The OpenLink ODBCDriver for Firebird (Express Edition) is a distributed as a Windows MSI installer. Simply double click on the installer 'ntl6efrb.msi' to commence the installation:

Figure: 4.2.1.1.

Installer Welcome Dialog for the OpenLink ODBCDriver for Firebird (Express Edition):

Figure: 4.2.1.1.

Please read the software license agreement and accept before continuing your installation:

Figure: 4.2.1.1.

Before installation you will be prompted for a license file. If a license file already exists on the machine then select the 'use existing file' option. A trial (try) or full (buy) license can be obtain by selecting the 'try and buy' option which loads our online try and buy web page:

Figure: 4.2.1.1.

To obtain the trial license you must be a registered user on the OpenLinkWeb site and login with the username (e-mail address) and password for that user. Click on the 'Shop' link to visit our online shop cart to purchases a full license if required:

Click on the 'download license' button to obtain the license file immediately and save to your desktop. Alternatively an auto e-mail will be sent to the registered users e-mail address with a link to their OpenLinkData Space ( ODS) where all trial and full license files will be stored in the Briefcase for download at a later date.

Figure: 4.2.1.1.

Select the license file to be used for the installation:

Figure: 4.2.1.1.

Choose to perform a custom, typical or complete installation of the driver:

Figure: 4.2.1.1.

Select the features to be installed:

Figure: 4.2.1.1.

Click the install button to begin the installation of components:

Figure: 4.2.1.1.

Installation in progress:

Figure: 4.2.1.1.

The Software installation is complete and ready for use:

Figure: 4.2.1.1.


4.2.2. Configuration

To configure an ODBCDSN, run the ODBCAdministrator located in the Administrative Tools section of the Control Panel:

Figure: 4.2.2.1.

Click on the drivers Tab to confirm the OpenLinkSQLServer ODBCDriver [Express Edition][6.0] has been successfully installed

Figure: 4.2.2.1.

From either the User or System DSN tabs click on the Add button and select the OpenLinkSQLServer ODBCDriver [Express Edition][6.0] from the list presented to create an ODBCDSN :

Figure: 4.2.2.1.

In the Data Source tab, select a suitable DSN name and optional description for the Data Source to be created:

Figure: 4.2.2.1.

The Connection Tab request the minimum parameters required to make a connection to the target database:

Figure: 4.2.2.1.

The advanced button displays additional optional parameters that can be configured:

Figure: 4.2.2.1.

Table: 4.2.2.1.
BlobBufferLength Set BLOB buffer length. This value influences the performance when working with BLOB fields.
BlobBufferSize Size of the BLOB buffer in bytes.
BuffersNumber Number of cache buffers that should be allocated for this connection, should be specified for ClassicServer instances, SuperServer has a server-wide configuration parameter.
DefaultIsolation Set the default transaction isolation level as string. Following strings are allowed: 'TRANSACTION_READ_COMMITTED', 'TRANSACTION_REPEATABLE_READ', 'TRANSACTION_SERIALIZABLE'
Encoding Set encoding for connections produced by this data source.
LoginTimeout Set login timeout for this datasource in seconds.
RoleName SQL role to use.
SocketBufferSize Socket buffer size in bytes.
SqlDialect SQL dialect of the client.
TimestampUsesLocalTimezone 'true' if the JayBird 1.0 handling of the calendar in corresponding setters. This is also compatible with MySQL calendar treatment.
UseStandardUdf 'true' if driver should assume that standard UDF are installed.
UseStreamBlobs 'true' if stream blobs should be created, otherwise 'false'
UseTranslation Path to the character translation table.
CharSet Character set for the connection. Similar to encoding property, but accepts Java names instead of Firebird ones.

As indicated above the paramters of the options and preferences tabs are not required for a basic connection.

Figure: 4.2.2.1.

Figure: 4.2.2.1.

Figure: 4.2.2.1.

Click on the Test Data Sourcebutton to verify successful connection can be made to the database.

Figure: 4.2.2.1.