Firebird ODBC: Difference between revisions

From eStream Software
Line 96: Line 96:


<div style="float: right;">  [[#top|[top]]]</div>
<div style="float: right;">  [[#top|[top]]]</div>
==See also==
* Others [[Customisation]]

Revision as of 04:20, 22 June 2017

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 32 bits
  • SQL Product

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. Create New Worksheet
FB ODBC-03.jpg
02. Click Data Tab
03. Clcik Get External Data | From Other Source | From Microsoft Query
FB ODBC-04.jpg
04. Select FB* (The Data Source Name entered in ODBC)
05. Click OK button
FB ODBC-05.jpg
06. Select the table at the Available tables and columns field
07. Click the > button to select the Columns
08. Click Next button till you see below dialog
FB ODBC-06.jpg
09. Select View data or edit query in Microsoft Query option
10. Click Finish button
FB ODBC-07.jpg
11. Click SQL button to edit your Query
12. Edit the Query Statement here
13. Click OK button when done
FB ODBC-08.jpg
14. Click File | Return Data to Microsoft Excel
FB ODBC-09.jpg
15. Click Ok button
FB ODBC-10.jpg

See also