{"id":1159,"date":"2023-08-18T15:41:04","date_gmt":"2023-08-18T19:41:04","guid":{"rendered":"https:\/\/tecgesco.com\/blog\/?p=1159"},"modified":"2023-08-18T15:41:05","modified_gmt":"2023-08-18T19:41:05","slug":"odbc-64bits-em-um-banco-firebird-32bits","status":"publish","type":"post","link":"https:\/\/tecgesco.com\/blog\/odbc-64bits-em-um-banco-firebird-32bits\/","title":{"rendered":"ODBC 64bits em um banco Firebird 32bits"},"content":{"rendered":"\n<p>Neste artigo iremos aprender como conectar em um banco de dados Firebird 32bits usando um conector ODBC na vers\u00e3o 64bits. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>1\u00ba &#8211; Firebird : ODBC e DLL 64 bits<\/strong> <\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"543\" src=\"https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-1024x543.png\" alt=\"\" class=\"wp-image-1160\" srcset=\"https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-1024x543.png 1024w, https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-300x159.png 300w, https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-768x407.png 768w, https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image.png 1148w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><a href=\"https:\/\/firebirdsql.org\/en\/odbc-driver\/\">https:\/\/firebirdsql.org\/en\/odbc-driver\/<\/a><br><br>Acesse o site oficial do Firebird e fa\u00e7a o download da vers\u00e3o mais recente do <strong>ODBC 64<\/strong> e tamb\u00e9m da <strong>DLL<\/strong>.<br>Ap\u00f3s baixar o ODBC, instale-o normalmente.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2\u00ba &#8211; Firebird : fbclient.dll 64 bits <\/h3>\n\n\n\n<p>Agora precisamos da <strong>fbclient.dll<\/strong> 64bits e na mesma vers\u00e3o do banco de dados. O banco que estamos usando de teste est\u00e1 na vers\u00e3o 2.5, portanto irei acessar a seguinte p\u00e1gina.<br><a href=\"https:\/\/firebirdsql.org\/en\/firebird-2-5\/\">https:\/\/firebirdsql.org\/en\/firebird-2-5\/<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"852\" height=\"356\" src=\"https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/Snag_2fc7e75e.png\" alt=\"\" class=\"wp-image-1163\" srcset=\"https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/Snag_2fc7e75e.png 852w, https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/Snag_2fc7e75e-300x125.png 300w, https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/Snag_2fc7e75e-768x321.png 768w\" sizes=\"auto, (max-width: 852px) 100vw, 852px\" \/><\/figure>\n\n\n\n<p>Baixe a vers\u00e3o .zip pois apenas iremos coletar a fbclient.dll<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"276\" src=\"https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-3.png\" alt=\"\" class=\"wp-image-1164\" srcset=\"https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-3.png 640w, https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-3-300x129.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p>Copia e salve esse arquivo em algum lugar que depois usaremos ele na conex\u00e3o ODBC.<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"410\" height=\"198\" src=\"https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-4.png\" alt=\"\" class=\"wp-image-1165\" srcset=\"https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-4.png 410w, https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-4-300x145.png 300w\" sizes=\"auto, (max-width: 410px) 100vw, 410px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>3\u00ba &#8211; Criando DNS ODBC 64bits<\/strong><\/h3>\n\n\n\n<p>Acesse o administrador de fonte de dados ODBC 64 bits e crie um novo DNS de Sistema.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"594\" height=\"555\" src=\"https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-5.png\" alt=\"\" class=\"wp-image-1166\" srcset=\"https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-5.png 594w, https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-5-300x280.png 300w\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><\/figure>\n\n\n\n<p>Informe o caminho correto do banco de dados assim como as credenciais de acesso(usu\u00e1rio e senha).<\/p>\n\n\n\n<p>Observe que no <strong>Client<\/strong> colocamos o caminho da fbclient.dll que obtemos no passo 2.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"467\" height=\"442\" src=\"https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-6.png\" alt=\"\" class=\"wp-image-1167\" srcset=\"https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-6.png 467w, https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-6-300x284.png 300w\" sizes=\"auto, (max-width: 467px) 100vw, 467px\" \/><\/figure>\n\n\n\n<p>Teste a conex\u00e3o.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"467\" height=\"442\" src=\"https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-7.png\" alt=\"\" class=\"wp-image-1168\" srcset=\"https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-7.png 467w, https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2023\/08\/image-7-300x284.png 300w\" sizes=\"auto, (max-width: 467px) 100vw, 467px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Neste artigo iremos aprender como conectar em um banco de dados Firebird 32bits usando um conector ODBC na vers\u00e3o 64bits. <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5],"tags":[288,287,99,290,286,289],"class_list":["post-1159","post","type-post","status-publish","format-standard","hentry","category-tecnico","tag-32bits","tag-64bits","tag-firebird","tag-gateway","tag-odbc","tag-powerbi"],"_links":{"self":[{"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/posts\/1159","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/comments?post=1159"}],"version-history":[{"count":1,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/posts\/1159\/revisions"}],"predecessor-version":[{"id":1169,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/posts\/1159\/revisions\/1169"}],"wp:attachment":[{"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/media?parent=1159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/categories?post=1159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/tags?post=1159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}