Firebird ODBC

From eStream Software
Revision as of 03:44, 28 February 2017 by Twfaung (talk | contribs) (→‎Setup)

Introduction

Is an External Utilities for other Application to Access Firebird Database

Pros

  1. Can direct Retrieve/Get Information From Connected Database.

Cons

  1. User might lost concurrent license (i.e. need to buy double)
  2. Might corrupt the database if not careful
  3. Setting need to reset if user change the database file name
  4. Setting need to reset if estream change firebird version or table/field name

Template.Warning-01.jpg
Using this Application is at your own risk.
Estream will not responsible on any data corrupt or missing due to usage of this application.

Requirement

  • Firebird Server

Program

Setup

01. Open Control Panel.
02. Double Click Administrative Tools | ODBC Data Sources (32-bit)
FB ODBC-01.jpg
03. Click on System DSN tab
04. Click Add button.
FB ODBC-02.jpg
05. Select Firebird/InterBase(r) Driver
06. Click Finish button.
07. Under Firebird ODBC Setup, define the following info only and the rest by default :
FB ODBC.jpg
Field Name Description
Data Source Name (DSN) Can be any Name (eg. FB)
Description Can be any Description (eg. FB)
Database The Firebird FDB file path
Client
  • The Firebird fbclient.dll path
  • Can get it under SQLAccounting\firebird 3.0 or Firebird\Firebird 3_0 Folder
Database Account Firebird user name (Default is SYSDBA)
Password Firebird password (Default is masterkey)
Character Set Set to UTF8 (For FB3.0 & above)
Dialect Set to 3

Example Access From Microsoft Excel

Below example is using Microsoft Excel 2016 to get Firebird Data using ODBC

Steps

01.