{"id":16859,"date":"2022-01-13T16:31:09","date_gmt":"2022-01-13T15:31:09","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\/"},"modified":"2025-10-24T09:38:43","modified_gmt":"2025-10-24T07:38:43","slug":"installing-the-odbc-drivers-for-firebird","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\/","title":{"rendered":"Installing the ODBC drivers for Firebird"},"content":{"rendered":"<p>This article is part of a series that includes SQLite, Postgresql, Microsoft SQLServer, Oracle RDBMS, HSQLDB, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here <em>to be completed<\/em>. Refer to <a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-manager-with-sqlite-on-linux\">SQLite<\/a> for installing the required ODBC Driver Manager.<br \/>\nThe test system is a debian v11 (bullseye).<br \/>\nAs root, install the Firebird RDBMS and its ODBC drivers from the official repositories:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n# apt install firebird3.0-server\n<\/pre>\n<p>A systemd service was set up and launched:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n# systemctl status firebird3.0.service\n\u25cf firebird3.0.service - Firebird Database Server ( SuperServer )\n     Loaded: loaded (\/lib\/systemd\/system\/firebird3.0.service; enabled; vendor preset: enabled)\n     Active: active (running) since Mon 2021-10-18 15:00:25 CEST; 50min ago\n    Process: 546 ExecStart=\/usr\/sbin\/fbguard -daemon -forever (code=exited, status=0\/SUCCESS)\n   Main PID: 576 (fbguard)\n      Tasks: 4 (limit: 4659)\n     Memory: 10.1M\n        CPU: 75ms\n     CGroup: \/system.slice\/firebird3.0.service\n             \u251c\u2500576 \/usr\/sbin\/fbguard -daemon -forever\n             \u2514\u2500577 \/usr\/sbin\/firebird\n\nOct 18 15:00:23 debian systemd[1]: Starting Firebird Database Server ( SuperServer )...\nOct 18 15:00:25 debian systemd[1]: Started Firebird Database Server ( SuperServer ).\n<\/pre>\n<p>The service runs as the newly created firebird account:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n# ps -ef | grep firebird\nfirebird   28053       1  0 15:15 ?        00:00:00 \/usr\/sbin\/fbguard -daemon -forever\nfirebird   28054   28053  0 15:15 ?        00:00:00 \/usr\/sbin\/firebird\n<\/pre>\n<p>Create the symlink below:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n# ln -s \/usr\/lib\/x86_64-linux-gnu\/libfbclient.so.3.0.7 \/usr\/lib\/x86_64-linux-gnu\/libgds.so\n<\/pre>\n<p>Get and install the binaries ODBC drivers for Firebird:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n# wget https:\/\/sourceforge.net\/projects\/firebird\/files\/firebird-ODBC-driver\/2.0.5-Release\/OdbcFb-LIB-2.0.5.156.amd64.gz\/download\n# gunzip OdbcFb-LIB-2.0.5.156.amd64.gz\n# tar xvf OdbcFb-LIB-2.0.5.156.amd64\n# cp libOdbcFb.so \/usr\/lib\/x86_64-linux-gnu\/odbc\/.\n<\/pre>\n<p>Edit the odbcinst.ini file:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n# vi \/etc\/odbcinst.ini\n...\n[Firebird]\nDescription=InterBase\/Firebird ODBC\nDriver=\/usr\/lib\/x86_64-linux-gnu\/odbc\/libOdbcFb.so\nSetup=\/usr\/lib\/x86_64-linux-gnu\/odbc\/libOdbcFb.so\nThreading=1\nFileUsage=1\nCPTimeout=\nCPReuse=\n<\/pre>\n<p>Check the ODBC driver file \/etc\/odbcinst.ini:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,5]\">\n# odbcinst -q -d\n...\n[Firebird]\n\n# odbcinst -q -d -n Firebird\n[Firebird]\nDescription=InterBase\/Firebird ODBC\nDriver=\/usr\/lib\/x86_64-linux-gnu\/odbc\/libOdbcFb.so\nSetup=\/usr\/lib\/x86_64-linux-gnu\/odbc\/libOdbcFb.so\nThreading=1\nFileUsage=1\nCPTimeout=\nCPReuse=\n<\/pre>\n<p>As debian, create the sampledb database using the native administrative tool isql-fb:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n$ cd $workdir\n$ mkdir firebird\n$ cd firebird\n$ isql-fb -user SYSDBA -password 'SYSDBA'\n<\/pre>\n<p>Use CONNECT or CREATE DATABASE to specify a database<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\nSQL&gt; create database \"\/home\/debian\/odbc4gawk\/firebird\/sampledb.fb\" page_size 8192 user SYSDBA password 'SYSDBA';\nSQL&gt; commit;\nSQL&gt; quit;\n<\/pre>\n<p>As there are no sample scripts specifically for Firebird, use <a href=\"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2020\/04\/postgresql.txt\">the postgresql&#8217;s ones<\/a> to create the tables but first replace the &#8220;SERIAL&#8221; keyword in the &#8220;CREATE TABLE&#8221; statements with the equivalent firebird&#8217;s syntax &#8220;INT GENERATED BY DEFAULT AS IDENTITY&#8221;. Use your favorite text editor or even sed for this. Save the above file as create_tables_postgresl.sql. With the vi editor, this could be done as shown below:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n$ vi create_tables_postgresl.sql\n:1,$s\/ SERIAL \/ INT GENERATED BY DEFAULT AS IDENTITY \/g\n:w create_tables_firebird.sql\n:q\n<\/pre>\n<p>Launch again isql-fb with a connection to the newly created database and copy\/paste the statements from create_tables_firebird.sql as they are just a few of them:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n$ isql-fb \/home\/debian\/odbc4gawk\/firebird\/sampledb.fb -u sysdba -p sysdba\nDatabase: \/home\/debian\/odbc4gawk\/firebird\/sampledb.fb, User: SYSDBA\nSQL&gt; show tables;\n<\/pre>\n<p>There are no tables in this database<br \/>\nPaste the create table statements here.<br \/>\nAlso, copy\/paste the statements from <a href=\"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2020\/04\/postgresql-data.txt\">here<\/a> and append a final commit; to confirm the INSERT. Finally, check the data:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\nSELECT\n        c.country_name,\n        c.country_id,\n        l.country_id,\n        l.street_address,\n        l.city\nFROM\n        countries c\nLEFT JOIN locations l ON l.country_id = c.country_id\nWHERE\n        c.country_id IN ('US', 'UK', 'CN');\nOutput:\nCOUNTRY_NAME                             COUNTRY_ID COUNTRY_ID STREET_ADDRESS                           CITY                           \n======================================== ========== ========== ======================================== =====================\nChina                                    CN                                                                          \nUnited Kingdom                           UK         UK         8204 Arthur St                           London                         \nUnited Kingdom                           UK         UK         Magdalen Centre, The Oxford Science Park Oxford                         \nUnited States of America                 US         US         2014 Jabberwocky Rd                      Southlake                      \nUnited States of America                 US         US         2011 Interiors Blvd                      South San Francisco            \nUnited States of America                 US         US         2004 Charade Rd                          Seattle                        \nSQL&gt; \n<\/pre>\n<p>Configure an ODBC DSN by editing the user\u2019s DSN file:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n$ vi ~\/.odbc.ini\n...\n[myfbdb]\nDescription=Firebird\nDriver=Firebird\nDbname=\/home\/debian\/odbc4gawk\/firebird\/sampledb.fb\nUser=SYSDBA\nPassword=SYSDBA\nRole=\nCharacterSet=UTF8\nReadOnly=No\nNoWait=No\n<\/pre>\n<p>Check it:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,6]\">\n$ odbcinst -q -s -n \n...\n[myfbdb]\n...\n\n$ odbcinst -q -s -n myfbdb\n[myfbdb]\nDescription=Firebird\nDriver=Firebird\nDbname=\/home\/debian\/odbc4gawk\/firebird\/sampledb.fb\nUser=SYSDBA\nPassword=SYSDBA\nRole=\nCharacterSet=UTF8\nReadOnly=No\nNoWait=No\n<\/pre>\n<p>Try a connection to the firebird db via ODBC:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,10]\">\n$ isql -v myfbdb sysdba sysdba\n+---------------------------------------+\n| Connected!                            |\n|                                       |\n| sql-statement                         |\n| help [tablename]                      |\n| quit                                  |\n|                                       |\n+---------------------------------------+\nSQL&gt; SELECT c.country_name, c.country_id, l.country_id, l.street_address, l.city FROM countries c LEFT JOIN locations l ON l.country_id = c.country_id WHERE c.country_id IN ('US', 'UK', 'CN');\nOutput:\n+-----------------------------------------+-----------+-----------+-----------------------------------------+---------------+\n| country_name                            | country_id| country_id| street_address                          | city          |\n+-----------------------------------------+-----------+-----------+-----------------------------------------+---------------+\n| China                                   | CN        |           |                                         |               |\n| United Kingdom                          | UK        | UK        | 8204 Arthur St                          | London        |\n| United Kingdom                          | UK        | UK        | Magdalen Centre, The Oxford Science Park| Oxford        |\n| United States of America                | US        | US        | 2014 Jabberwocky Rd                     | Southlake     |\n| United States of America                | US        | US        | 2011 Interiors Blvd                     | South San Francisco           |\n| United States of America                | US        | US        | 2004 Charade Rd                         | Seattle       |\n+-----------------------------------------+-----------+-----------+-----------------------------------------+---------------+\nSQLRowCount returns 6\n6 rows fetched\n<\/pre>\n<p>Test the DSN with pyodbc:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,6]\">\n$ python3\nPython 3.9.2 (default, Feb 28 2021, 17:03:44) \n[GCC 10.2.1 20210110] on linux\nType \"help\", \"copyright\", \"credits\" or \"license\" for more information.\n&gt;&gt;&gt; import pyodbc \n&gt;&gt;&gt; con = pyodbc.connect('DSN=myfbdb;UID=SYSDBA;PWD=SYSDBA;DBNAME=sampledb;')\nSegmentation fault\n<\/pre>\n<p>Although isql has no problem with them, it looks like the official Firebird ODBC drivers don&#8217;t work well with pyodbc. The same behavior was noticed later with the gawk the extension (see article here &#8230;). For this reason, we tried the commercial drivers from Devart available <a href=\"https:\/\/www.devart.com\/odbc\/firebird\/download.html\">here<\/a>. After having installed them by following the clear and simple instructions and having created the DSN myfbdb_devart using those drivers, pyodbc could work fine.<br \/>\nAfter installation of those drivers, check the DSN definition:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n$ odbcinst -q -s -n myfbdb_devart\n[myfbdb_devart]\nDescription=Firebird\nDriver=Devart ODBC Driver for Firebird\nDatabase=\/media\/sf_customers\/dbi\/odbc4gawk\/sampledb.fb\nPort=3050\nUser=SYSDBA\nPassword=SYSDBA\nRole=\nCharacterSet=UTF8\nReadOnly=No\nNoWait=No\n<\/pre>\n<p>And the drivers:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,]\">\n$ odbcinst -q -d -n \"Devart ODBC Driver for Firebird\"\n[Devart ODBC Driver for Firebird]\nDriver=\/usr\/local\/lib\/libdevartodbcfirebird.so\n<\/pre>\n<p>Retry the pyodbc module:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,6]\">\n$ python3\nPython 3.9.2 (default, Feb 28 2021, 17:03:44) \n[GCC 10.2.1 20210110] on linux\nType \"help\", \"copyright\", \"credits\" or \"license\" for more information.\nimport pyodbc \ncnxn = pyodbc.connect('DSN=myfbdb_devart;UID=SYSDBA;PWD=SYSDBA;DBNAME=sampledb;')\ncursor = cnxn.cursor()      \ncursor.execute(\"\"\"SELECT\n...         c.country_name,\n...         c.country_id,\n...         l.country_id,\n...         l.street_address,\n...         l.city\n... FROM\n...         countries c\n... LEFT JOIN locations l ON l.country_id = c.country_id\n... WHERE\n...         c.country_id IN ('US', 'UK', 'CN')\"\"\")\n\nrow = cursor.fetchone() \n while row:\n...     print (row) \n...     row = cursor.fetchone()\n... \nOutput:\n('China', 'CN', None, None, None)\n('United Kingdom', 'UK', 'UK', '8204 Arthur St', 'London')\n('United Kingdom', 'UK', 'UK', 'Magdalen Centre, The Oxford Science Park', 'Oxford')\n('United States of America', 'US', 'US', '2014 Jabberwocky Rd', 'Southlake')\n('United States of America', 'US', 'US', '2011 Interiors Blvd', 'South San Francisco')\n('United States of America', 'US', 'US', '2004 Charade Rd', 'Seattle')\n<\/pre>\n<p>The Devart\u2019s drivers work fine. However, let\u2019s try to recompile the official ODBC drivers for Firebird from their source code available <a href=\"https:\/\/sourceforge.net\/projects\/firebird\/files\/firebird-ODBC-driver\/2.0.5-Release\/OdbcJdbc-src-2.0.5.156.tar.gz\/download\">here<\/a>. To compile them, follow the following steps:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n$ apt install unixodbc-dev\n$ apt install firebird-dev\n<\/pre>\n<p>Once downloaded and untarred, move the directory OdbcJdbc\/Builds\/Gcc.lin and compile the drivers:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n$ export FBINCDIR=\/usr\/include\/firebird\n$ export FBLIBDIR=\/usr\/lib\/x86_64-linux-gnu\n$ make -e -d -f makefile.linux\n<\/pre>\n<p>The compiled libraries are put in OdbcJdbc\/Builds\/Gcc.lin\/Release_x86_64. As root, install the shared library libOdbcFb.so in its usual sub-directory and make it readable for everyone:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n# cp OdbcJdbc\/Builds\/Gcc.lin\/Release_x86_64\/libOdbcFb.so \/usr\/lib\/x86_64-linux-gnu\/odbc\/.\n<\/pre>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n# chmod a+r \/usr\/lib\/x86_64-linux-gnu\/odbc\/libOdbcFb.so\n<\/pre>\n<p>With those recompiled drivers, isql still works and pyodbc still fails but only while executing the SELECT statement. As shown later, the gawk extension has no problem anymore: it works with the drivers from Devart as well as the recompiled drivers; thus, we still have the option of free drivers.<br \/>\nDespite pyodbc, Firebird is now fully accessible from any ODBC application under the debian account.<br \/>\nInstructions for the other data sources can be accessed through the following links:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-manager-with-sqlite-on-linux\">SQLite<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-hsqldb\">HSQLDB<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mariadb\">MariaDB<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-postgresql\">PostgreSQL<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\">Oracle<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-microsoft-sqlserver-for-linux\">Microsoft SQLServer for Linux<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-mongodb\">MongoDB<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-cdata-odbc-drivers-for-excel\/\">Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article is part of a series that includes SQLite, Postgresql, Microsoft SQLServer, Oracle RDBMS, HSQLDB, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is [&hellip;]<\/p>\n","protected":false},"author":40,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,368],"tags":[],"type_dbi":[],"class_list":["post-16859","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-development-performance"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Installing the ODBC drivers for Firebird - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Installing the ODBC drivers for Firebird\" \/>\n<meta property=\"og:description\" content=\"This article is part of a series that includes SQLite, Postgresql, Microsoft SQLServer, Oracle RDBMS, HSQLDB, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-13T15:31:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-24T07:38:43+00:00\" \/>\n<meta name=\"author\" content=\"Middleware Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Middleware Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/installing-the-odbc-drivers-for-firebird\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/installing-the-odbc-drivers-for-firebird\\\/\"},\"author\":{\"name\":\"Middleware Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8d8563acfc6e604cce6507f45bac0ea1\"},\"headline\":\"Installing the ODBC drivers for Firebird\",\"datePublished\":\"2022-01-13T15:31:09+00:00\",\"dateModified\":\"2025-10-24T07:38:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/installing-the-odbc-drivers-for-firebird\\\/\"},\"wordCount\":556,\"commentCount\":0,\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Development &amp; Performance\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/installing-the-odbc-drivers-for-firebird\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/installing-the-odbc-drivers-for-firebird\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/installing-the-odbc-drivers-for-firebird\\\/\",\"name\":\"Installing the ODBC drivers for Firebird - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2022-01-13T15:31:09+00:00\",\"dateModified\":\"2025-10-24T07:38:43+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8d8563acfc6e604cce6507f45bac0ea1\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/installing-the-odbc-drivers-for-firebird\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/installing-the-odbc-drivers-for-firebird\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/installing-the-odbc-drivers-for-firebird\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Installing the ODBC drivers for Firebird\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8d8563acfc6e604cce6507f45bac0ea1\",\"name\":\"Middleware Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"caption\":\"Middleware Team\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/middleware-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Installing the ODBC drivers for Firebird - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\/","og_locale":"en_US","og_type":"article","og_title":"Installing the ODBC drivers for Firebird","og_description":"This article is part of a series that includes SQLite, Postgresql, Microsoft SQLServer, Oracle RDBMS, HSQLDB, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\/","og_site_name":"dbi Blog","article_published_time":"2022-01-13T15:31:09+00:00","article_modified_time":"2025-10-24T07:38:43+00:00","author":"Middleware Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Middleware Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\/"},"author":{"name":"Middleware Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"headline":"Installing the ODBC drivers for Firebird","datePublished":"2022-01-13T15:31:09+00:00","dateModified":"2025-10-24T07:38:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\/"},"wordCount":556,"commentCount":0,"articleSection":["Database Administration &amp; Monitoring","Development &amp; Performance"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\/","url":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\/","name":"Installing the ODBC drivers for Firebird - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-01-13T15:31:09+00:00","dateModified":"2025-10-24T07:38:43+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Installing the ODBC drivers for Firebird"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1","name":"Middleware Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","caption":"Middleware Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/middleware-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16859","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=16859"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16859\/revisions"}],"predecessor-version":[{"id":41201,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16859\/revisions\/41201"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16859"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}