{"id":1047,"date":"2019-03-25T17:33:24","date_gmt":"2019-03-25T20:33:24","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/"},"modified":"2020-01-23T10:33:17","modified_gmt":"2020-01-23T13:33:17","slug":"kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/","title":{"rendered":"KB-28705: Error when executing a connection to Oracle database via scripts when Oracle Client is not installed."},"content":{"rendered":"<div align=\"justify\"><span style=\"font-weight: bold;\">Question:<\/span><\/p>\n<p>When I open the Viewer or WebViewer and click on a button that executes a script to query an Oracle database, a connection error to the database is generated. Why does it happen?<\/p>\n<p><span style=\"font-weight: bold;\">Solution:<\/span><\/p>\n<p>It happens when you create a connection to the database via scripts. This will require a client to make the connection between Oracle Client and Server. It is recommended that you perform this connection with E3, so the Oracle Client will be installed in E3 Server, which in turn will pass the data to the Viewer.<\/p>\n<p>To do so, you must first install the Oracle client in the computer where the domain is running. Then, create a DataBase object in the Server and a query for the table, and write a script to access this database via RecordSet in the query. Thus, you will not need an Oracle Client installed in the machine where the script will run.<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Question: When I open the Viewer or WebViewer and click on a button that executes a script to query an Oracle database, a connection error to the database is generated.&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[735],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>KB-28705: Error when executing a connection to Oracle database via scripts when Oracle Client is not installed. - Elipse Knowledgebase<\/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:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"KB-28705: Error when executing a connection to Oracle database via scripts when Oracle Client is not installed.\" \/>\n<meta property=\"og:description\" content=\"Question: When I open the Viewer or WebViewer and click on a button that executes a script to query an Oracle database, a connection error to the database is generated.&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:33:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-23T13:33:17+00:00\" \/>\n<meta name=\"author\" content=\"Elipse Software\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Elipse Software\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/\"},\"author\":{\"name\":\"Elipse Software\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\"},\"headline\":\"KB-28705: Error when executing a connection to Oracle database via scripts when Oracle Client is not installed.\",\"datePublished\":\"2019-03-25T20:33:24+00:00\",\"dateModified\":\"2020-01-23T13:33:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/\"},\"wordCount\":172,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"DataBases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/\",\"name\":\"[:pt]KB-28705: Error when executing a connection to Oracle database via scripts when Oracle Client is not installed.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:33:24+00:00\",\"dateModified\":\"2020-01-23T13:33:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"KB-28705: Error when executing a connection to Oracle database via scripts when Oracle Client is not installed.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\",\"name\":\"Elipse Software\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"caption\":\"Elipse Software\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"KB-28705: Error when executing a connection to Oracle database via scripts when Oracle Client is not installed. - Elipse Knowledgebase","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:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]KB-28705: Error when executing a connection to Oracle database via scripts when Oracle Client is not installed.[:] - Elipse Knowledgebase","og_description":"Question: When I open the Viewer or WebViewer and click on a button that executes a script to query an Oracle database, a connection error to the database is generated.&hellip;","og_url":"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:33:24+00:00","article_modified_time":"2020-01-23T13:33:17+00:00","author":"Elipse Software","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elipse Software","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/"},"author":{"name":"Elipse Software","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87"},"headline":"KB-28705: Error when executing a connection to Oracle database via scripts when Oracle Client is not installed.","datePublished":"2019-03-25T20:33:24+00:00","dateModified":"2020-01-23T13:33:17+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/"},"wordCount":172,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["DataBases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/","url":"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/","name":"[:pt]KB-28705: Error when executing a connection to Oracle database via scripts when Oracle Client is not installed.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:33:24+00:00","dateModified":"2020-01-23T13:33:17+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/kb28705-error-when-executing-a-connection-to-oracle-database-via-scripts-when-oracle-client-is-not-installed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"KB-28705: Error when executing a connection to Oracle database via scripts when Oracle Client is not installed."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87","name":"Elipse Software","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","caption":"Elipse Software"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/1047"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=1047"}],"version-history":[{"count":1,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/1047\/revisions"}],"predecessor-version":[{"id":9980,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/1047\/revisions\/9980"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=1047"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=1047"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=1047"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}