Introduction
This is an External Utilities for other Application to Access Firebird Database
Pros
- Can direct Retrieve/Get, Delete and/or Modified the Information/Data From Connected Database.
Cons
- User might lost concurrent license (i.e. need to buy double)
- Might corrupt the database if not careful
- Might cause unable to upgrade database due to database is "modified"
- Setting need to reset if user change the database file name
- Setting need to reset if estream change firebird version or table/field name
 |
- Using this Application is at your own risk.
- Estream will not responsible on any data corrupt or missing due to usage of this application.
- No further support other then this but we will try our best to help
|
|
Requirement
Program
Setup
- 01. Open Control Panel.
- 02. Double Click Administrative Tools |
- - ODBC Data Sources (32-bit), or
- - ODBC Data Sources (64-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
- 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
|
| Read(default write) |
Check/Tick to make transactions read-only
|
 |
- 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
|
|
Below is example where to get the ServerName, Path & FDB
Example Access From Microsoft Excel
Below example is using Microsoft Excel 2016 to get Firebird Data using ODBC
Steps
- 01. Create New Worksheet
- 02. Click Data Tab
- 03. Clcik Get External Data | From Other Source | From Microsoft Query
- 04. Select FB* (The Data Source Name entered in ODBC)
- 05. Click OK button
- 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
- 09. Select View data or edit query in Microsoft Query option
- 10. Click Finish button
- 11. Click SQL button to edit your Query
- 12. Edit the Query Statement here
- 13. Click OK button when done
- 14. Click File | Return Data to Microsoft Excel
- 15. Click Ok button
See also
