{"id":16856,"date":"2022-01-13T16:14:43","date_gmt":"2022-01-13T15:14:43","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/"},"modified":"2025-10-24T09:38:45","modified_gmt":"2025-10-24T07:38:45","slug":"installing-the-odbc-driver-manager-with-sqlite-on-linux","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/","title":{"rendered":"Installing the ODBC Driver Manager with SQLite on Linux"},"content":{"rendered":"<p>This article is part of a series that includes Firebird, 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>. Excepting the present part which deals with the ODBC Driver manager&#8217;s installation which is a prerequisite, each part can be used independently from the others.<br \/>\nThe test system is a debian v11 (bullseye).<\/p>\n<h3>Installation of the ODBC driver Manager<\/h3>\n<p>There are 2 main implementations of ODBC for Linux: UnixODBC (http:\/\/www.unixodbc.org\/) and iODBC (http:\/\/www.iodbc.org); we picked the former for no particular reason.<br \/>\nThe driver manager can be installed as root through the standard package management tool in Debian:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1,4]\">\nroot@debian:~# apt-get install libodbc1\nroot@debian:~# apt install unixodbc \n\nroot@debian:~# odbcinst -j\nunixODBC 2.3.6\nDRIVERS............: \/etc\/odbcinst.ini\nSYSTEM DATA SOURCES: \/etc\/odbc.ini\nFILE DATA SOURCES..: \/etc\/ODBCDataSources\nUSER DATA SOURCES..: \/root\/.odbc.ini\nSQLULEN Size.......: 8\nSQLLEN Size........: 8\nSQLSETPOSIROW Size.: 8\n<\/pre>\n<p>The system-wide file \/etc\/odbcinst.ini stores the list of installed ODBC drivers and is maintained by root. It is the default one, but its location can be changed and set in the environment variable $ODBCINST.<br \/>\nLet\u2019s create a working folder in user debian\u2019s home directory, our test account:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [4]\">\n$ id\nuid=1000(debian) gid=1000(debian) groups=1000(debian)\n$ mkdir ~\/odbc4gawk\n$ export workdir=~\/odbc4gawk\n$ mkdir $workdir\n$ cd $workdir\n<\/pre>\n<p>As most of the ODBC drivers have their shared libraries installed in \/usr\/lib\/x86_64-linux-gnu\/odbc, this path must be added the $LD_LIBRARY_PATH environment variable of any user that must use ODBC, preferably in the ~\/.bashrc file (if bash is the select shell):<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\nexport LD_LIBRARY_PATH=\/usr\/lib\/x86_64-linux-gnu\/odbc:$LD_LIBRARY_PATH\n<\/pre>\n<p>We are now ready to install the ODBC drivers for each data source of interest.<\/p>\n<h3>Installation of the SQLite ODBC driver<\/h3>\n<p>SQLite along with its administrative tool isql are installed by the native package manager as root:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n# apt install sqlite3\n# apt install libsqliteodbc\n<\/pre>\n<p>Each time an ODBC driver is installed, it updates the file \/etc\/odbcinst.ini with driver-dependent information, which can later be checked using the above command odbcinst, e.g.:<br \/>\nList the installed ODBC drivers:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n$ odbcinst -q -d\n[SQLite3]\n<\/pre>\n<p>Query a particular driver:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n$ odbcinst -q -d -n SQLite\nSQLite3]\nDescription=SQLite3 ODBC Driver\nDriver=libsqlite3odbc.so\nSetup=libsqlite3odbc.so\nUsageCount=1\n<\/pre>\n<p>As user debian, edit the file ~\/.odbc.ini and add the SQLite data source\u2019s details we will use:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [4]\">\n$ cd $workdir \n$ mkdir sqlite\n$ cd sqlite\n$ vi ~\/.odbc.ini\n[mysqlitedb]\nDescription=My SQLite sample database\nDriver=SQLite3\nDatabase=\/home\/debian\/odbc4gawk\/sqlite\/sampledb\n<\/pre>\n<p>Let\u2019s check it:<br \/>\nList all the DSN currently defined in ~\/.odbc.ini<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n$ odbcinst -q -s\n[mysqlitedb]\n<\/pre>\n<p>List our new DSN:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n$ odbcinst -q -s -n mysqlitedb\n[mysqlitedb]\nDescription=My SQLite sample database\nDriver=SQLite3\nDatabase=\/home\/debian\/odbc4gawk\/sqlite\/sampledb\n<\/pre>\n<p>which is the information we just entered above.<\/p>\n<p>The ~\/.odbc.ini file allows to hide a drivers\u2019 private settings so that they don\u2019t need to be specified later. When connecting to a data source, the name that is specified here between square brackets, the DSN, is enough. It is also possible to directly specify in-line all the parameters in this section when connecting programmatically but the code will need to be edited (and maybe recompiled) in case one them has to be changed, so using a DSN is preferable.<br \/>\nThe default file location is the current user\u2019s home directory but it can be changed and its full path name set in the environment variable $ODBCINI.<\/p>\n<p>Let\u2019s test the connection via ODBC using the command isql included with the ODBC driver manager:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n$ isql mysqlitedb -v\n+---------------------------------------+\n| Connected!                            |\n|                                       |\n| sql-statement                         |\n| help [tablename]                      |\n| quit                                  |\n|                                       |\n+---------------------------------------+\n<\/pre>\n<p>The ODBC driver for SQLite does work.<\/p>\n<p>To populate a database, start sqllite3:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n$ \/usr\/bin\/sqlite3\nSQLite version 3.34.1 2021-01-20 14:10:07\nEnter \".help\" for usage hints.\nConnected to a transient in-memory database.\n<\/pre>\n<p>Use &#8220;.open FILENAME&#8221; to reopen a persistent database.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\nsqlite&gt; .open sampledb\n<\/pre>\n<p>The file sampledb has been created in the directory specified in ~\/.odbc.ini.<br \/>\nGo to the following links, copy the SQL statements and paste them in sqllite3: <a href=\"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2020\/04\/sqlite.txt\">table creation<\/a> and <a href=\"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2020\/04\/sqlite-data.txt\">insert data<\/a>.<\/p>\n<p>Still in sqlite3, check that the database has been populated by running the test SQL query listed above:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\nsqlite&gt; SELECT\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:\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\n<\/pre>\n<p>Now, quit sqlite3 and re-run the same query from isql, the ODBC-based utility:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n$ isql -v mysqlitedb\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')\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 0\n6 rows fetched\n<\/pre>\n<p>Note: the output has been shrunk a bit to reduce horizontal scrolling.<\/p>\n<p>Everything looks good so far. Let\u2019s now install the pyodbc ODBC module for python as root;<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [3,4]\">\n# apt install pip\n# needed to compile pyodbc:\n# apt install unixodbc-dev\n# pip install pyodbc\n<\/pre>\n<p>As debian, execute the following python script with the following connection string:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [2]\">\nimport pyodbc \ncnxn = pyodbc.connect(DSN='mysqlitedb;UID=SA;PWD=admin2021!')\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\nFROM\n        countries c\nLEFT JOIN locations l ON l.country_id = c.country_id\nWHERE\n        c.country_id IN ('US', 'UK', 'CN')\"\"\")\nrow = cursor.fetchone() \nwhile row:\n    print (row) \n    row = cursor.fetchone()\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')Output:\n<\/pre>\n<p>Everything works as expected.<br \/>\nWe have completed the steps to access an SQLite database via ODBC from isql and from the python module pyodbc. It was quite straightforward with that RDBMS. Once the gawk interface is completed, it should return the same output.<br \/>\nTurn now to the links below for the other data sources:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-firebird\">Firebird<\/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-odbc-drivers-for-excel\">Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article is part of a series that includes Firebird, 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. Excepting the present part which deals with the ODBC Driver manager&#8217;s installation which 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-16856","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.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Installing the ODBC Driver Manager with SQLite on Linux - 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-driver-manager-with-sqlite-on-linux\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Installing the ODBC Driver Manager with SQLite on Linux\" \/>\n<meta property=\"og:description\" content=\"This article is part of a series that includes Firebird, 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. Excepting the present part which deals with the ODBC Driver manager&#8217;s installation which is [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-13T15:14:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-24T07:38:45+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=\"6 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-driver-manager-with-sqlite-on-linux\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/\"},\"author\":{\"name\":\"Middleware Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"headline\":\"Installing the ODBC Driver Manager with SQLite on Linux\",\"datePublished\":\"2022-01-13T15:14:43+00:00\",\"dateModified\":\"2025-10-24T07:38:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/\"},\"wordCount\":665,\"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-driver-manager-with-sqlite-on-linux\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/\",\"name\":\"Installing the ODBC Driver Manager with SQLite on Linux - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2022-01-13T15:14:43+00:00\",\"dateModified\":\"2025-10-24T07:38:45+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Installing the ODBC Driver Manager with SQLite on Linux\"}]},{\"@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 Driver Manager with SQLite on Linux - 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-driver-manager-with-sqlite-on-linux\/","og_locale":"en_US","og_type":"article","og_title":"Installing the ODBC Driver Manager with SQLite on Linux","og_description":"This article is part of a series that includes Firebird, 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. Excepting the present part which deals with the ODBC Driver manager&#8217;s installation which is [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/","og_site_name":"dbi Blog","article_published_time":"2022-01-13T15:14:43+00:00","article_modified_time":"2025-10-24T07:38:45+00:00","author":"Middleware Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Middleware Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/"},"author":{"name":"Middleware Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"headline":"Installing the ODBC Driver Manager with SQLite on Linux","datePublished":"2022-01-13T15:14:43+00:00","dateModified":"2025-10-24T07:38:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/"},"wordCount":665,"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-driver-manager-with-sqlite-on-linux\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/","url":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/","name":"Installing the ODBC Driver Manager with SQLite on Linux - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-01-13T15:14:43+00:00","dateModified":"2025-10-24T07:38:45+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-driver-manager-with-sqlite-on-linux\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Installing the ODBC Driver Manager with SQLite on Linux"}]},{"@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\/16856","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=16856"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16856\/revisions"}],"predecessor-version":[{"id":41203,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16856\/revisions\/41203"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16856"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16856"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16856"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16856"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}