Firebird ODBC: Difference between revisions

Revision as of 03:48, 13 February 2017

Is an External Utilities for other Application to Access Firebird Database

Using this Application is at your own risk.

Estream will not responsible on any data corrupt or missing due to usage of this application.

01. Open Control Panel.

02. Double Click Administrative Tools | ODBC Data Sources (32-bit)

03. Click on User DSN tab

04. Click Add button.

05. Select Firebird/InterBase(r) Driver and click finish to Firebird ODBC Setup.

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

@@ Line 21: / Line 21: @@
 ==Setup==
+:01. Open '''Control Panel.'''
+:02. Double '''Click Administrative Tools | ODBC Data Sources (32-bit)'''
+:03. Click on '''User DSN''' tab
+:04. Click Add button.
+:05. Select '''Firebird/InterBase(r) Driver'''  and click finish to Firebird ODBC Setup.
+:06. Under Firebird ODBC Setup, define the following info only and the rest by default :
+[[File:FB_ODBC.jpg|center]]
+{| class="wikitable" style="margin: 1em auto 1em auto;"
+|-
+! 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'''
+|}