{"id":55,"date":"2009-02-11T19:24:59","date_gmt":"2009-02-11T23:24:59","guid":{"rendered":"http:\/\/dbtricks.com\/?p=55"},"modified":"2009-02-11T19:24:59","modified_gmt":"2009-02-11T23:24:59","slug":"how-to-configure-the-odbc-on-oracle-xe-client","status":"publish","type":"post","link":"https:\/\/dbtricks.com\/?p=55","title":{"rendered":"How to Configure the ODBC on Oracle XE Client"},"content":{"rendered":"<p>Even Oracle veterans may encounter some challenges when it comes to setting an odbc\u00a0 using the Oracle XE Client. \u00a0\u00a0 As every DBA will tell you, you will need to configure the tnsnames.ora\u00a0 (using\u00a0 net configuration Assistant or by going\u00a0 to oracle home\\network\\admin and edit it manually). After that, theTNS Service name in the ODBC will be populated with the entries from the tnsnames.ora file. You will only be required to choose the appropriate entry and you should be good to go.<br \/>\nThis was the case in all the latest Oracle releases However If you will download the Oracle XE client you will quickly discover\u00a0 that <strong>there is no tnsnames.ora under the Oracle client XE directory structure<\/strong>. In addition, the network\\admin directory is not there as well.<br \/>\nOracle documentation explains (In their usual user friendly way) how to connect to the Data Base using a connection string (<strong>username\/password@[\/\/]host[:port][\/service_name<\/strong>] where service name is usually XE and port is 1521) but it is not that obvious how to configure the odbc to use this.<br \/>\nThe solution is simple enough (once you find it). All that needs to be done is to type\u00a0 the connection string\u00a0 on the ODBC\u2019s \u201c TNS Service Name\u201d field.\u00a0 Just add the line <strong>127.0.0.1\/XE<\/strong> (no need to use the drop down) and test the connection.<br \/>\nIf the Data Base is on a different machine, you can replace 127.0.0.1 with the address of the remote server.<br \/>\n<a href=\"http:\/\/dbtricks.com\/wp-content\/uploads\/2009\/02\/xe-client-odbc2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-58\" title=\"xe-client-odbc2\" src=\"http:\/\/dbtricks.com\/wp-content\/uploads\/2009\/02\/xe-client-odbc2-300x192.jpg\" alt=\"\" width=\"300\" height=\"192\" srcset=\"https:\/\/dbtricks.com\/wp-content\/uploads\/2009\/02\/xe-client-odbc2-300x192.jpg 300w, https:\/\/dbtricks.com\/wp-content\/uploads\/2009\/02\/xe-client-odbc2.jpg 563w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Even Oracle veterans may encounter some challenges when it comes to setting an odbc\u00a0 using the Oracle XE Client. \u00a0\u00a0 As every DBA will tell you, you will need to configure the tnsnames.ora\u00a0 (using\u00a0 net configuration Assistant or by going\u00a0 to oracle home\\network\\admin and edit it manually). After that, theTNS Service name in the ODBC [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[37,36,107,20,15,35],"class_list":["post-55","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-connection","tag-odbc","tag-oracle","tag-oracle-client","tag-oracle-xe","tag-oracle-xe-client"],"_links":{"self":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/55","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=55"}],"version-history":[{"count":1,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/55\/revisions"}],"predecessor-version":[{"id":59,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/55\/revisions\/59"}],"wp:attachment":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=55"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=55"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=55"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}