Firebird ODBC: Difference between revisions

From eStream Software
Line 36: Line 36:
:03. Click on '''System DSN''' tab
:03. Click on '''System DSN''' tab
:04. Click Add button.
:04. Click Add button.
:05. Select '''Firebird/InterBase(r) Driver''' and click finish to Firebird ODBC Setup.
[[File:FB_ODBC-02.jpg|center]]
:06. Under Firebird ODBC Setup, define the following info only and the rest by default :
: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 :
[[File:FB_ODBC.jpg|center]]
[[File:FB_ODBC.jpg|center]]
{| class="wikitable" style="margin: 1em auto 1em auto;"
{| class="wikitable" style="margin: 1em auto 1em auto;"

Revision as of 03:33, 28 February 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

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
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