{"id":917,"date":"2012-02-28T14:26:58","date_gmt":"2012-02-28T17:26:58","guid":{"rendered":"http:\/\/www.franklinjr.com\/blog\/?p=917"},"modified":"2012-02-28T14:26:58","modified_gmt":"2012-02-28T17:26:58","slug":"como-criar-dsn-no-coldfusion-para-ms-access-2007","status":"publish","type":"post","link":"https:\/\/www.franklinjr.com\/blog\/index.php\/2012\/02\/28\/como-criar-dsn-no-coldfusion-para-ms-access-2007\/","title":{"rendered":"Como criar DSN no ColdFusion para MS access 2007"},"content":{"rendered":"<p>Como criar uma DSN no ColdFusion para MS access 2007, com extens\u00e3o *.accdb?<\/p>\n<p>Ent\u00e3o, primeiramente, tu tem que instalar o driver pro servidor reconhecer a extens\u00e3o *.accdb, esse driver tu encontra no site da Microsoft, especificamente no link <a href=\"http:\/\/www.microsoft.com\/download\/en\/details.aspx?displaylang=en&amp;id=23734\" target=\"_blank\">http:\/\/www.microsoft.com\/download\/en\/details.aspx?displaylang=en&amp;id=23734<\/a><\/p>\n<p>Depois de instalar, vai no painel de controle &gt; ferramentas administrativas &gt; fontes de dados (OBDC), na janela que abrir clica na aba fonte de dados do sistema.<\/p>\n<p>Nessa parte clique em adicionar, na nova janela que abrir, selecione &#8220;Microsoft Access Driver(*.mdb, *.accdb)&#8221; 12.00.4518.1014, tem que ser exatamente isso, depois clique em cluir, d\u00ea um nome para o Data Source, clique em selecionar para selecionar o banco access com a extens\u00e3o .accdb, depois clica em ok nas janelas abertas.<\/p>\n<p>Pronto, agora vamos para o administrador do ColdFusion, l\u00e1 tu cria uma DSN com o driver &#8220;ODBC Socket&#8221;, d\u00e1 um nome para a DSN e seleciona a DSN que tu crio no painel de controle, no sistema do ColdFusion, ent\u00e3o \u00e9 s\u00f3 clicar em Submit para cri\u00e1-la.<\/p>\n<p>Fonte: <a href=\"http:\/\/blogs.adobe.com\/vikaschandran\/2010\/12\/03\/creating-ms-access-2007-database-accdb-extension-datasource-with-coldfusion-9\/\" target=\"_blank\">http:\/\/blogs.adobe.com\/vikaschandran\/2010\/12\/03\/creating-ms-access-2007-database-accdb-extension-datasource-with-coldfusion-9\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Como criar uma DSN no ColdFusion para MS access 2007, com extens\u00e3o *.accdb? Ent\u00e3o, primeiramente, tu tem que instalar o driver pro servidor reconhecer a extens\u00e3o *.accdb, esse driver tu encontra no site da Microsoft, especificamente no link http:\/\/www.microsoft.com\/download\/en\/details.aspx?displaylang=en&amp;id=23734 Depois de instalar, vai no painel de controle &gt; ferramentas administrativas &gt; fontes de dados (OBDC), [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[443],"tags":[470,444,469],"class_list":["post-917","post","type-post","status-publish","format-standard","hentry","category-coldfusion","tag-access","tag-coldfusion-2","tag-dsn"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\r\n<title>Como criar DSN no ColdFusion para MS access 2007 - Franklin Jr.<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.franklinjr.com\/blog\/index.php\/2012\/02\/28\/como-criar-dsn-no-coldfusion-para-ms-access-2007\/\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.franklinjr.com\\\/blog\\\/index.php\\\/2012\\\/02\\\/28\\\/como-criar-dsn-no-coldfusion-para-ms-access-2007\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\\\/\\\/www.franklinjr.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como criar DSN no ColdFusion para MS access 2007\"}]}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como criar DSN no ColdFusion para MS access 2007 - Franklin Jr.","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.franklinjr.com\/blog\/index.php\/2012\/02\/28\/como-criar-dsn-no-coldfusion-para-ms-access-2007\/","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/www.franklinjr.com\/blog\/index.php\/2012\/02\/28\/como-criar-dsn-no-coldfusion-para-ms-access-2007\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/www.franklinjr.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Como criar DSN no ColdFusion para MS access 2007"}]}]}},"_links":{"self":[{"href":"https:\/\/www.franklinjr.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/917","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.franklinjr.com\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.franklinjr.com\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.franklinjr.com\/blog\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.franklinjr.com\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=917"}],"version-history":[{"count":1,"href":"https:\/\/www.franklinjr.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/917\/revisions"}],"predecessor-version":[{"id":918,"href":"https:\/\/www.franklinjr.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/917\/revisions\/918"}],"wp:attachment":[{"href":"https:\/\/www.franklinjr.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.franklinjr.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=917"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.franklinjr.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}