Firebird ODBC

From eStream Software
Revision as of 05:05, 28 December 2019 by Twfaung (talk | contribs) (→‎Setup)

Introduction

Is an External Utilities for other Application to Access Firebird Database

Pros

  1. Can direct Retrieve/Get, Delete and/or Modified the Information/Data 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. Might cause unable to upgrade database due to database is "modified"
  4. Setting need to reset if user change the database file name
  5. 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 3.0 & above
- 32 bits
- 64 bits

Program

Setup

01. Open Control Panel.
02. Double Click Administrative Tools |
- ODBC Data Sources (32-bit), or
- ODBC Data Sources (64-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
  • Can get it under SQLAccounting\DB or estream\DB Folder
Client
  • The Firebird fbclient.dll path
  • Can get it under SQLAccounting\firebird 3.0 or Firebird\Firebird 3_0 Folder
  • For 64 Bit can Leave it empty
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

Template.Tips-01.jpg
  • Make sure when click Test Connection is shown Connection successful! then only continue others Steps
  • To access the FDB with network environment you can enter the ServerName or ServerIPAddress:Database Path at Database field
Example
ServerPC:C:\Program Files\estream\SQLAccounting\DB\ACC-0001.FDB or
192.168.0.18:C:\Program Files\estream\SQLAccounting\DB\ACC-0001.FDB

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

Video

May download from Here

See also