{"id":16860,"date":"2022-01-13T16:48:07","date_gmt":"2022-01-13T15:48:07","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\/"},"modified":"2025-10-24T09:38:41","modified_gmt":"2025-10-24T07:38:41","slug":"installing-the-odbc-drivers-for-oracle-rdbms","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\/","title":{"rendered":"Installing the ODBC drivers for Oracle RDBMS"},"content":{"rendered":"<p>This article is part of a series that includes SQLite, Postgresql, Firebird, MongoDB, Microsoft SQL Server, HSQLDB, Excel, and MariaDB. 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-driver-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 we already have a running Oracle remote instance, we don&#8217;t need to set one up and only the ODBC drivers need to be installed.<br \/>\nAs user debian, get and install the ODBC drivers for Oracle (an account is needed), cf <a href=\"https:\/\/www.oracle.com\/database\/technologies\/instant-client\/linux-x86-64-downloads.html\">here<\/a>.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n$ id\nuid=1000(debian) gid=1000(debian) groups=1000(debian)\n$ cd ~\/Downloads\n$ wget https:\/\/download.oracle.com\/otn_software\/linux\/instantclient\/213000\/instantclient-basiclite-linux.x64-21.3.0.0.0.zip\n$ wget https:\/\/download.oracle.com\/otn_software\/linux\/instantclient\/213000\/instantclient-sqlplus-linux.x64-21.3.0.0.0.zip\n$ wget https:\/\/download.oracle.com\/otn_software\/linux\/instantclient\/213000\/instantclient-odbc-linux.x64-21.3.0.0.0.zip\n$ mkdir ~\/odbc4gawk\n$ export workdir=~\/odbc4gawk\n$ mkdir $workdir\n$ unzip instantclient-basiclite-linux.x64-21.3.0.0.0.zip -d ${workdir}\/.\n$ unzip instantclient-sqlplus-linux.x64-21.3.0.0.0.zip -d ${workdir}\/.\n$ unzip instantclient-odbc-linux.x64-21.3.0.0.0.zip -d ${workdir}\/.\n<\/pre>\n<p>The instant client software is required; we also download and install Oracle&#8217;s native command-line administration tool sqlplus to populate the test schema.<br \/>\nFollow the installation instructions <a href=\"https:\/\/www.oracle.com\/fr\/database\/technologies\/releasenote-odbc-ic.html\">here<\/a>.<br \/>\nAdd the Instant Client path to the shared library path:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n$ vi ~\/.bashrc\nexport LD_LIBRARY_PATH=\/home\/debian\/odbc4gawk\/instantclient_21_3:$LD_LIBRARY_PATH\n<\/pre>\n<p>Note: If WordPress does not render them correctly, there is an underscore between the name, 21 and 3 in instantclient_21_3 above.<br \/>\nAs there is a bug in the Oracle script odbc_update_ini.sh, a work-around is provided here.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\ncd $workdir\/instantclient_21_3\n$ mkdir etc\n$ cp \/etc\/odbcinst.ini etc\/.\n$ cp ~\/.odbc.ini etc\/odbc.ini\n<\/pre>\n<p>Run the configuration script now:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n$ .\/odbc_update_ini.sh .\n<\/pre>\n<p>Oracle has updated the local copy of the odbcinst.ini file. Let&#8217;s copy it to \/etc to make the changes system-wide:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n$ sudo cp etc\/odbcinst.ini \/etc\/.\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]\">\n$ odbcinst -q -d\n...\n[Oracle 21 ODBC driver]\n<\/pre>\n<p>Correct.<br \/>\nSee <a href=\"https:\/\/www.oracle.com\/pls\/topic\/lookup?ctx=dblatest&amp;id=GUID-7931EDFB-7A70-4BBE-903E-8A2BB09DBE9D\">here<\/a> for further configuration of the ODBC driver.<br \/>\nLet&#8217;s test the connection to the remote db via the instant client:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [2]\">\n$ cd ${workdir}\/instantclient_21_3\n$ .\/sqlplus scott\/tiger@'(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = db)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))'\n\nSQL*Plus: Release 21.0.0.0.0 - Production on Mon Oct 18 19:34:07 2021\nVersion 21.3.0.0.0\n\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\n\nLast Successful login time: Sat Oct 16 2021 01:17:00 +02:00\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\n\nSQL&gt; \n<\/pre>\n<p>The remote database is available and reachable natively.<br \/>\nStill in the sqlplus session, let&#8217;s populate the schema scott with the sample data. As the sample&#8217;s date values assume a different format, let&#8217;s switch to it in the Oracle session and avoid formatting errors:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\nSQL&gt; alter session set nls_date_format = 'yyyy-mm-dd';\n<\/pre>\n<p>Let&#8217;s download the tables creation script using from <a href=\"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2020\/04\/oracle.txt\">here<\/a> and the data populating script from <a href=\"https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2020\/04\/oracle-data.txt\">here<\/a>:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\nwget https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2020\/04\/oracle.txt --output-document=oracle.sql\nwget https:\/\/www.sqltutorial.org\/wp-content\/uploads\/2020\/04\/oracle-data.txt --output-document=oracle-data.sql\n<\/pre>\n<p>Create the tables and load the data now:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n@oracle\n@oracle-data\n\n-- test the query:\nset pagesize 10000\nset linesize 200\nset tab off\ncol country_name format a25\ncol STREET_ADDRESS format a30\ncol city format a20\nSQL&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')';\n\nCOUNTRY_NAME              CO CO STREET_ADDRESS                 CITY\n------------------------- -- -- ------------------------------ --------------------\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\nUnited Kingdom            UK UK 8204 Arthur St                 London\nUnited Kingdom            UK UK Magdalen Centre, The Oxford Sc Oxford\n                                ience Park\n\nChina                     CN\n\n6 rows selected.\nSQL&gt; quit\n<\/pre>\n<p>The test data are ready.<br \/>\nLet&#8217;s edit debian&#8217;s ODBC DSN definitions and add the settings below:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n$ vi ~\/.odbc.ini\n...\n[OracleODBC-21]\n...\nDriver=Oracle 21 ODBC driver\nDSN=OracleODBC-21\n...\nServerName=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = db)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))\n...\nUserID=scott\nPassword=tiger\n<\/pre>\n<p>Check the DSN:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [1]\">\n$ odbcinst -q -s -n \"OracleODBC-21\" \n[OracleODBC-21]\nAggregateSQLType=FLOAT\nApplication Attributes=T\nAttributes=W\nBatchAutocommitMode=IfAllSuccessful\n...\nServerName=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = db)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))\n...\nUserID=scott\nPassword=tiger\n<\/pre>\n<p>Test it using the ODBC Driver Manager test tool, isql:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: []\">\n$ isql -v OracleODBC-21\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| 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| United Kingdom                          | UK        | UK        | 8204 Arthur St                          | London        |\n| United Kingdom                          | UK        | UK        | Magdalen Centre, The Oxford Science Park| Oxford        |\n| China                                   | CN        |           |                                         |               |\n+-----------------------------------------+-----------+-----------+-----------------------------------------+---------------+\nSQLRowCount returns -1\n6 rows fetched\n<\/pre>\n<p>The ODBC connection is OK. Test the DSN with the python ODBC module pyodbc:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1; highlight: [3]\">\n$ python3\nimport pyodbc \ncnxn = pyodbc.connect('DSN=OracleODBC-21')\ncursor = cnxn.cursor()\t\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('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('United Kingdom', 'UK', 'UK', '8204 Arthur St', 'London')\n('United Kingdom', 'UK', 'UK', 'Magdalen Centre, The Oxford Science Park', 'Oxford')\n('China', 'CN', None, None, None)\n&gt;&gt;&gt; \n<\/pre>\n<p>Oracle is now fully accessible via ODBC 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-driver-manager-with-sqlite-on-linux\">SQLite<\/a><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-mongodb\">MongoDB<\/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-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, Firebird, MongoDB, Microsoft SQL Server, HSQLDB, Excel, and MariaDB. 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":[197,229],"tags":[],"type_dbi":[],"class_list":["post-16860","post","type-post","status-publish","format-standard","hentry","category-application-integration-middleware","category-database-administration-monitoring"],"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 drivers for Oracle RDBMS - 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-oracle-rdbms\/\" \/>\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 Oracle RDBMS\" \/>\n<meta property=\"og:description\" content=\"This article is part of a series that includes SQLite, Postgresql, Firebird, MongoDB, Microsoft SQL Server, HSQLDB, Excel, and MariaDB. 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-oracle-rdbms\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-13T15:48:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-24T07:38:41+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=\"5 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-oracle-rdbms\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\/\"},\"author\":{\"name\":\"Middleware Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"headline\":\"Installing the ODBC drivers for Oracle RDBMS\",\"datePublished\":\"2022-01-13T15:48:07+00:00\",\"dateModified\":\"2025-10-24T07:38:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\/\"},\"wordCount\":393,\"commentCount\":0,\"articleSection\":[\"Application integration &amp; Middleware\",\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\/\",\"name\":\"Installing the ODBC drivers for Oracle RDBMS - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2022-01-13T15:48:07+00:00\",\"dateModified\":\"2025-10-24T07:38:41+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-oracle-rdbms\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\/#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 Oracle RDBMS\"}]},{\"@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 Oracle RDBMS - 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-oracle-rdbms\/","og_locale":"en_US","og_type":"article","og_title":"Installing the ODBC drivers for Oracle RDBMS","og_description":"This article is part of a series that includes SQLite, Postgresql, Firebird, MongoDB, Microsoft SQL Server, HSQLDB, Excel, and MariaDB. 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-oracle-rdbms\/","og_site_name":"dbi Blog","article_published_time":"2022-01-13T15:48:07+00:00","article_modified_time":"2025-10-24T07:38:41+00:00","author":"Middleware Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Middleware Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\/"},"author":{"name":"Middleware Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"headline":"Installing the ODBC drivers for Oracle RDBMS","datePublished":"2022-01-13T15:48:07+00:00","dateModified":"2025-10-24T07:38:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\/"},"wordCount":393,"commentCount":0,"articleSection":["Application integration &amp; Middleware","Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\/","url":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\/","name":"Installing the ODBC drivers for Oracle RDBMS - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-01-13T15:48:07+00:00","dateModified":"2025-10-24T07:38:41+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-oracle-rdbms\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/installing-the-odbc-drivers-for-oracle-rdbms\/#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 Oracle RDBMS"}]},{"@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\/16860","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=16860"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16860\/revisions"}],"predecessor-version":[{"id":41199,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16860\/revisions\/41199"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16860"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16860"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16860"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}