{"id":1403,"date":"2011-11-02T00:41:23","date_gmt":"2011-11-02T07:41:23","guid":{"rendered":"http:\/\/www.andreanolanusse.com\/pt\/?p=1403"},"modified":"2014-03-03T21:02:55","modified_gmt":"2014-03-04T05:02:55","slug":"conectando-ao-postgresql-com-dbexpress-odbc-driver","status":"publish","type":"post","link":"http:\/\/www.andreanolanusse.com\/pt\/conectando-ao-postgresql-com-dbexpress-odbc-driver\/","title":{"rendered":"Conectando ao PostgreSQL com dbExpress ODBC driver"},"content":{"rendered":"<p>O Delphi XE2 e C++Builder XE2 finalmente trouxeram o driver ODBC para dbExpress, com este driver voc\u00ea pode conectar a qualquer banco de dados que disponibilize um driver ODBC usando o dbExpress em aplica\u00e7\u00f5es FireMonkey e VCL. At\u00e9 o Delphi XE3 o driver ODBC somente \u00e9 compat\u00edvel com a plataforma Windows.<\/p>\n<p>Para exemplificar melhor como funciona criei uma aplica\u00e7\u00e3o FireMonkey que mostra como podemos utilizar o dbExpress ODBC driver para conectar ao banco de dados PostgreSQL.<\/p>\n<p>Antes de iniciar o desenvolvimento voc\u00ea precisa configurar o seu ambiente conforme os passos abaixo:<\/p>\n<ul>\n<li>Instalar o driver ODBC do PostgreSQL na m\u00e1quina que ir\u00e1 executar a aplica\u00e7\u00e3o, o driver pode ser baixado <a href=\"http:\/\/ftp.postgresql.org\/pub\/odbc\/versions\/msi\/\" target=\"_blank\">aqui<\/a>.<br \/>\n<em>Vale lembrar que aplica\u00e7\u00f5es compiladas como 32-bit requerem a vers\u00e3o 32-bit do driver ODBC da base de dados a ser utilizada, para aplica\u00e7\u00f5es 64-bit ser\u00e1 necess\u00e1rio o driver ODBC 64-bit.<\/em><\/li>\n<li>Depois de instalar o driver, atrav\u00e9s do ODBC Data Source Administrator (odbcad32.exe)\u00a0crie e configure um alias ODBC, pode ser do tipo User DSN ou System DSN:<\/li>\n<\/ul>\n<p><strong>Instru\u00e7\u00f5es para aqueles que usam Windows 64-bit<\/strong><\/p>\n<ul>\n<li>Para aplica\u00e7\u00f5es 32-bit use o\u00a0c:\\Windows\\SysWOW64\\odbcad32.exe<\/li>\n<li>Para aplica\u00e7\u00f5es 64-bit use o\u00a0c:\\Windows\\system32\\odbcad32.exe<\/li>\n<\/ul>\n<p><strong>Instru\u00e7\u00f5es para aqueles que usam Windows 32-bit<\/strong><\/p>\n<ul>\n<li>Use o\u00a0c:\\Windows\\system32\\odbcad32.exe<\/li>\n<\/ul>\n<div><a href=\"http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/11\/ODBC-PostgreSQL.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1405\" title=\"Configura\u00e7\u00e3o do Data Source ODBC para PostgreSQL\" alt=\"\" src=\"http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/11\/ODBC-PostgreSQL.png\" width=\"291\" height=\"399\" srcset=\"http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/11\/ODBC-PostgreSQL.png 485w, http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/11\/ODBC-PostgreSQL-127x175.png 127w\" sizes=\"(max-width: 291px) 100vw, 291px\" \/><\/a><\/div>\n<p>A seguir crie um alias dbExpress ODBC no Data Explorer, lembrando que Database Name \u00e9 o nome do Data Source criado no ODBC Administrator, neste exemplo o chamei de PostgreSQL35W. Configura\u00e7\u00f5es adicionais do driver para acessar a base de dados, como usu\u00e1rio e senha j\u00e1 foram configuradas no Data Source, voc\u00ea pode sobrescrever o usu\u00e1rio e senha na conex\u00e3o dbExpress.<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/11\/DataExplorer-PostgreSQL.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1404\" title=\"Data Explorer conectado ao PostgreSQL\" alt=\"\" src=\"http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/11\/DataExplorer-PostgreSQL.png\" width=\"230\" height=\"379\" srcset=\"http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/11\/DataExplorer-PostgreSQL.png 329w, http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/11\/DataExplorer-PostgreSQL-106x175.png 106w\" sizes=\"(max-width: 230px) 100vw, 230px\" \/><\/a><\/p>\n<p>Suponho que voc\u00ea j\u00e1 sabe como utilizar os componentes de acesso a dados do dbExpress (SQLConnection, DataSetProvider e ClientDataSet), basta conect\u00e1-los da mesma forma que voc\u00ea sempre fez com aplica\u00e7\u00f5es que utilizam os componentes dbExpress. A configura\u00e7\u00e3o do SQLConnection ser\u00e1 configurada conforme abaixo:<\/p>\n<pre>  object SQLConnection1: TSQLConnection\r\n    ConnectionName = 'PostgreSQLOdbc'\r\n    DriverName = 'ODBC'\r\n    LoginPrompt = False\r\n    Params.Strings = (\r\n      'drivername=ODBC'\r\n      'Database=PostgreSQL35W')\r\n  end<\/pre>\n<p style=\"text-align: center;\"><a href=\"http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/11\/IDE-ODBC-PostgreSQL.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1407\" title=\"IDE conectando componentes dbExpress\" alt=\"\" src=\"http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/11\/IDE-ODBC-PostgreSQL.png\" width=\"732\" height=\"428\" srcset=\"http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/11\/IDE-ODBC-PostgreSQL.png 1045w, http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/11\/IDE-ODBC-PostgreSQL-298x175.png 298w, http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/11\/IDE-ODBC-PostgreSQL-1030x603.png 1030w\" sizes=\"(max-width: 732px) 100vw, 732px\" \/><\/a><\/p>\n<p>Al\u00e9m de poder utilizar os componentes dbExpress em aplica\u00e7\u00f5es VCL e FireMonkey, voc\u00ea pode utilizar o dbExpress framework para conectar a bancos de dados que n\u00e3o tenham um driver nativo. A figura abaixo mostra a aplica\u00e7\u00e3o FireMonkey conectada a PostgreSQL atrav\u00e9s do dbExpress ODBC driver.<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/11\/FMI_dbExpress_ODBC.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1406\" title=\"Aplica\u00e7\u00e3o FireMonkey conectada a PostgreSQL com dbExpress ODBC driver\" alt=\"\" src=\"http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/11\/FMI_dbExpress_ODBC.png\" width=\"621\" height=\"410\" srcset=\"http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/11\/FMI_dbExpress_ODBC.png 887w, http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/11\/FMI_dbExpress_ODBC-264x175.png 264w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/><\/a><\/p>\n<p>Este exemplo pode ser encontrado no diret\u00f3rio de exemplos do Delphi ou no reposit\u00f3rio de demos do RAD Studio no Source Forge atrav\u00e9s deste \u00a0<a href=\"https:\/\/radstudiodemos.svn.sourceforge.net\/svnroot\/radstudiodemos\/branches\/RadStudio_XE2\/Delphi\/Database\/dbExpress\/ODBCPostgreSQL\" target=\"_blank\">link<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>O Delphi XE2 e C++Builder XE2 finalmente trouxeram o driver ODBC para dbExpress, com este driver voc\u00ea pode conectar a qualquer banco de dados que disponibilize um driver ODBC usando o dbExpress em aplica\u00e7\u00f5es FireMonkey e VCL. At\u00e9 o Delphi XE3 o driver ODBC somente \u00e9 compat\u00edvel com a plataforma Windows. Para exemplificar melhor como [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1456,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_s2mail":"yes","footnotes":""},"categories":[16,102,186],"tags":[173,33,181,115],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v16.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Conectando ao PostgreSQL com dbExpress ODBC driver | Andreano Lanusse | Tecnologia e Desenvolvimento de Software<\/title>\n<meta name=\"description\" content=\"O Delphi XE2 e C++Builder XE2 finalmente trouxeram o driver ODBC para dbExpress, com este driver voc\u00ea pode conectar a qualquer banco de dados que\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.andreanolanusse.com\/pt\/conectando-ao-postgresql-com-dbexpress-odbc-driver\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Conectando ao PostgreSQL com dbExpress ODBC driver | Andreano Lanusse | Tecnologia e Desenvolvimento de Software\" \/>\n<meta property=\"og:description\" content=\"O Delphi XE2 e C++Builder XE2 finalmente trouxeram o driver ODBC para dbExpress, com este driver voc\u00ea pode conectar a qualquer banco de dados que\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.andreanolanusse.com\/pt\/conectando-ao-postgresql-com-dbexpress-odbc-driver\/\" \/>\n<meta property=\"og:site_name\" content=\"Andreano Lanusse | Tecnologia e Desenvolvimento de Software\" \/>\n<meta property=\"article:published_time\" content=\"2011-11-02T07:41:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-03-04T05:02:55+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/07\/Icon_Delphi_CBuilder.png\" \/>\n\t<meta property=\"og:image:width\" content=\"340\" \/>\n\t<meta property=\"og:image:height\" content=\"170\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@andreanolanusse\" \/>\n<meta name=\"twitter:site\" content=\"@andreanolanusse\" \/>\n<meta name=\"twitter:label1\" content=\"Est. tempo de leitura\">\n\t<meta name=\"twitter:data1\" content=\"2 minutos\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/#website\",\"url\":\"http:\/\/www.andreanolanusse.com\/pt\/\",\"name\":\"Andreano Lanusse | Tecnologia e Desenvolvimento de Software\",\"description\":\"Andreano Lanusse blog - artigos, tutoriais e v&iacute;deos sobre tecnologia, desenvolvimento de software (Delphi XE4, C#, PHP, .NET) e t&eacute;cnicas de programa&ccedil;&atilde;o\",\"publisher\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/#\/schema\/person\/620bd05e81598c3aba4781796cbe8903\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"http:\/\/www.andreanolanusse.com\/pt\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"ImageObject\",\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/conectando-ao-postgresql-com-dbexpress-odbc-driver\/#primaryimage\",\"inLanguage\":\"pt-BR\",\"url\":\"http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/07\/Icon_Delphi_CBuilder.png\",\"contentUrl\":\"http:\/\/www.andreanolanusse.com\/pt\/wp-content\/uploads\/2011\/07\/Icon_Delphi_CBuilder.png\",\"width\":340,\"height\":170},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/conectando-ao-postgresql-com-dbexpress-odbc-driver\/#webpage\",\"url\":\"http:\/\/www.andreanolanusse.com\/pt\/conectando-ao-postgresql-com-dbexpress-odbc-driver\/\",\"name\":\"Conectando ao PostgreSQL com dbExpress ODBC driver | Andreano Lanusse | Tecnologia e Desenvolvimento de Software\",\"isPartOf\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/conectando-ao-postgresql-com-dbexpress-odbc-driver\/#primaryimage\"},\"datePublished\":\"2011-11-02T07:41:23+00:00\",\"dateModified\":\"2014-03-04T05:02:55+00:00\",\"description\":\"O Delphi XE2 e C++Builder XE2 finalmente trouxeram o driver ODBC para dbExpress, com este driver voc\\u00ea pode conectar a qualquer banco de dados que\",\"breadcrumb\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/conectando-ao-postgresql-com-dbexpress-odbc-driver\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.andreanolanusse.com\/pt\/conectando-ao-postgresql-com-dbexpress-odbc-driver\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/conectando-ao-postgresql-com-dbexpress-odbc-driver\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/\",\"url\":\"http:\/\/www.andreanolanusse.com\/pt\/\",\"name\":\"In\\u00edcio\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/conectando-ao-postgresql-com-dbexpress-odbc-driver\/#webpage\"}}]},{\"@type\":\"Article\",\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/conectando-ao-postgresql-com-dbexpress-odbc-driver\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/conectando-ao-postgresql-com-dbexpress-odbc-driver\/#webpage\"},\"author\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/#\/schema\/person\/620bd05e81598c3aba4781796cbe8903\"},\"headline\":\"Conectando ao PostgreSQL com dbExpress ODBC driver\",\"datePublished\":\"2011-11-02T07:41:23+00:00\",\"dateModified\":\"2014-03-04T05:02:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/conectando-ao-postgresql-com-dbexpress-odbc-driver\/#webpage\"},\"commentCount\":23,\"publisher\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/#\/schema\/person\/620bd05e81598c3aba4781796cbe8903\"},\"image\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/conectando-ao-postgresql-com-dbexpress-odbc-driver\/#primaryimage\"},\"keywords\":[\"C++Builder\",\"dbExpress\",\"Delphi\",\"FireMonkey\"],\"articleSection\":[\"C++Builder\",\"Delphi\",\"FireMonkey\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/www.andreanolanusse.com\/pt\/conectando-ao-postgresql-com-dbexpress-odbc-driver\/#respond\"]}]},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/#\/schema\/person\/620bd05e81598c3aba4781796cbe8903\",\"name\":\"Andreano Lanusse\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/#personlogo\",\"inLanguage\":\"pt-BR\",\"url\":\"http:\/\/0.gravatar.com\/avatar\/6a9c6f73c7c480fb826c7303288abfd3?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/0.gravatar.com\/avatar\/6a9c6f73c7c480fb826c7303288abfd3?s=96&d=mm&r=g\",\"caption\":\"Andreano Lanusse\"},\"logo\":{\"@id\":\"http:\/\/www.andreanolanusse.com\/pt\/#personlogo\"},\"sameAs\":[\"https:\/\/twitter.com\/andreanolanusse\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/posts\/1403"}],"collection":[{"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/comments?post=1403"}],"version-history":[{"count":0,"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/posts\/1403\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/media\/1456"}],"wp:attachment":[{"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/media?parent=1403"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/categories?post=1403"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.andreanolanusse.com\/pt\/wp-json\/wp\/v2\/tags?post=1403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}