Easysoft ODBC-InterBase Driver User Guide - Technical Reference
Technical Reference for the Easysoft ODBC-InterBase Driver
This section contains extra information relating to the deployment of the Easysoft ODBC-InterBase Driver.
The Easysoft ODBC-InterBase Driver is an ODBC 3.5 driver and uses the driver manager to provide the deprecated and old ODBC 2 functions:
- The driver conforms to all the Core Level requirements
- The driver conforms to 104, 105 and 109 of Level 1 requirements
- The driver conforms to 202, 203, 205, 209 and 211 of Level 2 requirements
- The driver implements all ODBC 3 functions with the exception of:
Cursor support in the Easysoft ODBC-InterBase Driver is restricted to FORWARD_ONLY, as this is the only cursor type supported by InterBase. As a result, the Easysoft ODBC-InterBase Driver will work with ADO snapshots, but not with dynasets.
Multiple transactions on a single connection
Multiple transactions on a single connection are not supported by ODBC 3 and therefore cannot be supported by the Easysoft ODBC-InterBase Driver.
InterBase data types
The Easysoft ODBC-InterBase Driver supports the DATE, TIME, TIMESTAMP and INT64 IB 6 data types.
Runtime SQL Dialect support
The required SQL Dialect can be set for a connection, but cannot be set at runtime, as it is not a statement level property.
Easysoft are considering adding this property in a future release.
The Easysoft ODBC-InterBase Driver will support the isc_rollback_retaining function if it is present in a GDS32.DLL library.
The Easysoft ODBC-InterBase Driver can be configured to work with Sun Chili!Soft ASP.Specific installation information is provided on the Easysoft web site
The Easysoft ODBC-InterBase Driver does not require a driver manager on the client machine, although there are some advantages in using one, such as:
- being able to pick the ODBC driver from the DSN and have it loaded for you dynamically
- the ability to work with multiple ODBC drivers
There are currently two open source driver managers available for Unix, unixODBC and iODBC. If you want to use a driver manager then Easysoft recommend the unixODBC driver manager.
There are a number of reasons for this:
1. The unixODBC project started by Peter Harvey is now maintained by Nick Gorham who is an Easysoft developer. This means there is much greater experience with unixODBC within Easysoft and we will be able to provide better support for the InterBase Driver running under unixODBC. It also means that if you find a problem in unixODBC it is much easier for us to facilitate a fix.
2. Easysoft test all their ODBC drivers with unixODBC and although they may work with iODBC it is more difficult for us to support it as we are less familiar with it.
3. The unixODBC package contains much more than a driver manager. The aim of the unixODBC project is to provide all the ODBC functionality available on Windows for UNIX operating systems. The unixODBC package may be built with the QT libraries to allow GUI configuration of DSNs and drivers. It also contains the GUI DataManager program which may be used to explore your ODBC data. the InterBase Driver contains the code and shared object which is used by unixODBC's GUI ODBCConfig utility to add/delete and configure InterBase DSNs.
4. From 4.0.0, the InterBase Driver installation for UNIX can automatically install itself using the unixODBC installer program to run under unixODBC.
For the latest information about unixODBC, please refer to the unixODBC document in <InstallDir>/easysoft/ib/doc in case any of the information here has been superseded.