The driver is compatible with 3rd-party data analyses tools, such as Microsoft Excel, and integrates with various IDEs and systems like Visual Studio, etc. However in some cases, if the value in the database exceeds this precision, the application will report an error. It may return data if at least one of the procedure arguments has been defined as an output parameter into which values can be placed. I agree to privacy policy and terms of use. This should include server IP address, the path on the server and the file name with extension. For details of the other attributes that can be set in odbc.

Uploader: Ketaxe
Date Added: 7 October 2016
File Size: 18.58 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 34164
Price: Free* [*Free Regsitration Required]

ODBC Driver for Firebird

Thus allowing any desktop and web applications to connect to Firebird from various environments and platforms, that support ODBC. This InterBase server supports multiple instances.

Specifies that owner gvb schema information should be returned from metadata calls. Causes the database connection to use a different default isolation method for transactions.

There are a couple of ways to create a new database: More further information about security in Firebird, refer to http: This is the most important piece of information and is often mistyped by new users.

Easysoft ODBC-InterBase Driver User Guide – Configuration

Support Visit our Support page to get instant support from experienced professionals, fast and detailed responses, user engagement and interaction, frequent builds gxb bug fixes, and much more.


If future, select Firebird if you see it in the drop down list box. Any help will be highly appreciated. This ensures that updates made by Select procedures are committed.

Note that this attribute must contain a valid user name for the InterBase server database. Allows a default InterBase character set to be specified for the database connection. Subscribe gdbb monthly digest to get special offers.

When a message appears saying that the installation was successful, click Finish. Select the Data Source you created above and click OK. This option allows the behavior to be altered, such that the ODBC driver reports a precision that is the maximum possible precision that could be stored in the field, overriding the actual stored precision. For more details consult the Geb documentation detailing the difference between dialects.

Attribute fields are configured either: Descriptive text which may be retrieved by certain applications to describe the data source.

However, while InterBase allows such a definition, it will actually allow larger numbers to be stored in the field, effectively ignoring the precision value.

This can cause problems with applications that use odbx around column and table names, because even though the Easysoft ODBC-InterBase Driver is queried as to the character to use for quoted identifiers, at least one application Microsoft Access fails if the application is instructed not to use any character for this purpose.


This attribute may be entered in several formats, depending on where the database is located and the gdn method required: Ask you database administrator to set up a Firebird login Solution: Format Connection Method Examples.

This option prevents the driver from using the conversion provided by the Operating System, but instead to use a simple conversion that will allow non Odbd data to be correctly converted to UCS This is the login ID.

All security related information is stored in a special database called “security2. The entry will look something like the following. The driver is compatible with 3rd-party data analyses tools, such as Microsoft Excel, and integrates with various IDEs and systems like Visual Studio, etc.

The InterBase server is installed on a different machine However, some Microsoft applications do not odcb this.

Firebird ODBC driver 32/bit – Devart

InterBase Select procedures are called from a Select statement and can contain InsertUpdate or Delete statements or call other procedures that contain these statements. Please refer to Excel documentation for more information. Only Select statements are permitted and no UpdateInsert or Delete statements are allowed.