{"id":1866,"date":"2019-03-25T17:37:01","date_gmt":"2019-03-25T20:37:01","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/"},"modified":"2020-01-21T11:35:41","modified_gmt":"2020-01-21T14:35:41","slug":"kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/","title":{"rendered":"KB-29022: GetADORecordSet() method not working with a remote E3 Viewer."},"content":{"rendered":"<div style=\"text-align: justify;\"><span style=\"font-weight: bold;\">Question:<\/span><\/p>\n<p>Why does <span style=\"font-style: italic;\">GetADORecordSet()<\/span> method, which correctly works with a local <span style=\"font-weight: bold;\">E3 Viewer<\/span>, shows a script error when executed with a remote <span style=\"font-weight: bold;\">E3 Viewer<\/span>?<\/p>\n<p><span style=\"font-weight: bold;\">Solution:<\/span><\/p>\n<p>This happens because Database&#8217;s <span style=\"font-style: italic;\">EnableLocalCreation <\/span>option is enabled (TRUE). This option allows the queries configured on the Database accessing it without passing through the server, making the execution faster.<\/p>\n<p>To solve this problem, just set it to FALSE.<\/p><\/div>\n<div><\/div>\n<div><span style=\"font-family: Verdana; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial; color: #ff0000;\"><b>NOTE:<\/b>\u00a0<\/span><span style=\"color: #666666; font-family: Verdana; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">From version 4.6 on, the EnableLocalCreation property has been removed from the DBServer object. Since then, the Viewers have no longer been able to access the database directly, and all access now take place via server.<\/span><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Question: Why does GetADORecordSet() method, which correctly works with a local E3 Viewer, shows a script error when executed with a remote E3 Viewer? Solution: This happens because Database&#8217;s EnableLocalCreation&hellip;<\/p>\n","protected":false},"author":25,"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":[763],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>KB-29022: GetADORecordSet() method not working with a remote E3 Viewer. - 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\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"KB-29022: GetADORecordSet() method not working with a remote E3 Viewer.\" \/>\n<meta property=\"og:description\" content=\"Question: Why does GetADORecordSet() method, which correctly works with a local E3 Viewer, shows a script error when executed with a remote E3 Viewer? Solution: This happens because Database&#8217;s EnableLocalCreation&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/\" \/>\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:37:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-21T14:35:41+00:00\" \/>\n<meta name=\"author\" content=\"Jer\u00f4nimo Mulinari Neto\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jer\u00f4nimo Mulinari Neto\" \/>\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\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/\"},\"author\":{\"name\":\"Jer\u00f4nimo Mulinari Neto\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/d84d93b89444e774594683d022bf2bef\"},\"headline\":\"KB-29022: GetADORecordSet() method not working with a remote E3 Viewer.\",\"datePublished\":\"2019-03-25T20:37:01+00:00\",\"dateModified\":\"2020-01-21T14:35:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/\"},\"wordCount\":111,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"Scripts\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/\",\"name\":\"[:pt]KB-29022: GetADORecordSet() method not working with a remote E3 Viewer.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:37:01+00:00\",\"dateModified\":\"2020-01-21T14:35:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"KB-29022: GetADORecordSet() method not working with a remote E3 Viewer.\"}]},{\"@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\/d84d93b89444e774594683d022bf2bef\",\"name\":\"Jer\u00f4nimo Mulinari Neto\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ef4a47d01af296803baa8b2db33df9fe?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ef4a47d01af296803baa8b2db33df9fe?s=96&d=mm&r=g\",\"caption\":\"Jer\u00f4nimo Mulinari Neto\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/jeronimo\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"KB-29022: GetADORecordSet() method not working with a remote E3 Viewer. - 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\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]KB-29022: GetADORecordSet() method not working with a remote E3 Viewer.[:] - Elipse Knowledgebase","og_description":"Question: Why does GetADORecordSet() method, which correctly works with a local E3 Viewer, shows a script error when executed with a remote E3 Viewer? Solution: This happens because Database&#8217;s EnableLocalCreation&hellip;","og_url":"https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:37:01+00:00","article_modified_time":"2020-01-21T14:35:41+00:00","author":"Jer\u00f4nimo Mulinari Neto","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jer\u00f4nimo Mulinari Neto","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/"},"author":{"name":"Jer\u00f4nimo Mulinari Neto","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/d84d93b89444e774594683d022bf2bef"},"headline":"KB-29022: GetADORecordSet() method not working with a remote E3 Viewer.","datePublished":"2019-03-25T20:37:01+00:00","dateModified":"2020-01-21T14:35:41+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/"},"wordCount":111,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["Scripts"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/","url":"https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/","name":"[:pt]KB-29022: GetADORecordSet() method not working with a remote E3 Viewer.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:37:01+00:00","dateModified":"2020-01-21T14:35:41+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/kb29022-getadorecordset-method-not-working-with-a-remote-e3-viewer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"KB-29022: GetADORecordSet() method not working with a remote E3 Viewer."}]},{"@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\/d84d93b89444e774594683d022bf2bef","name":"Jer\u00f4nimo Mulinari Neto","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ef4a47d01af296803baa8b2db33df9fe?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ef4a47d01af296803baa8b2db33df9fe?s=96&d=mm&r=g","caption":"Jer\u00f4nimo Mulinari Neto"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/jeronimo\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/1866"}],"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\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=1866"}],"version-history":[{"count":1,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/1866\/revisions"}],"predecessor-version":[{"id":9809,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/1866\/revisions\/9809"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=1866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=1866"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=1866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}