(→Setup) |
(→Setup) |
||
| 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''' | [[File:FB_ODBC-02.jpg|center]] | ||
: | :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
- Can direct Retrieve/Get Information From Connected Database.
Cons
- User might lost concurrent license (i.e. need to buy double)
- Might corrupt the database if not careful
- Setting need to reset if user change the database file name
- Setting need to reset if estream change firebird version or table/field name
|
Requirement
- Firebird Server
Program
Setup
- 01. Open Control Panel.
- 02. Double Click Administrative Tools | ODBC Data Sources (32-bit)
- 03. Click on System DSN tab
- 04. Click Add button.
- 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 :
| 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 |