{"id":716,"date":"2014-07-17T11:59:22","date_gmt":"2014-07-17T11:59:22","guid":{"rendered":"http:\/\/blog.silverterra.net\/?p=716"},"modified":"2014-07-17T12:00:32","modified_gmt":"2014-07-17T12:00:32","slug":"simple-mdac-test","status":"publish","type":"post","link":"https:\/\/blog.silverterra.net\/?p=716","title":{"rendered":"simple mdac test"},"content":{"rendered":"<blockquote><p>Goal: to show a simple way to test a data provider<\/p><\/blockquote>\n<p>The base problem is to check quickly the data provider we need. In this case this is an old odbc driver for a dbf database. Seemingly the simpliest way is this following:<br \/>\nFirst of all we need an installed excel, because we will use the excel database query feature.<\/p>\n<blockquote><p>see also: <a href=\"http:\/\/support.microsoft.com\/kb\/164729\" target=\"_blank\">XL97: New Database Query (.dqy) File Format<\/a><\/p><\/blockquote>\n<p>Let&#8217;s create a simple text file named: <strong>test.dqy<\/strong> with the following:<\/p>\n<pre data-enlighter-language=\"js\" class=\"EnlighterJSRAW\">\r\nXLODBC\r\n1\r\nDriver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\\gykeres;\r\nSELECT * FROM gyardev\r\n<\/pre>\n<p>In this sample there is an old dbf database reader with the Microsoft dBASE Driver.<br \/>\nDoubleklick on the file and the excel will try to open the datasource as we specified.<br \/>\nIf everything is ok, than we will see the data in the excel sheet, if not we will see the error message and we can react.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Goal: to show a simple way to test a data provider The base problem is to check quickly the data provider we need. In this case this is an old odbc driver for a dbf database. Seemingly the simpliest way is this following: First of all we need an installed excel, because we will use [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"class_list":["post-716","post","type-post","status-publish","format-standard","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=\/wp\/v2\/posts\/716","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=716"}],"version-history":[{"count":3,"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=\/wp\/v2\/posts\/716\/revisions"}],"predecessor-version":[{"id":719,"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=\/wp\/v2\/posts\/716\/revisions\/719"}],"wp:attachment":[{"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=716"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=716"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}