{"id":143,"date":"2017-03-07T11:38:48","date_gmt":"2017-03-07T11:38:48","guid":{"rendered":"http:\/\/hahne-software.de\/?p=143"},"modified":"2017-09-04T14:25:34","modified_gmt":"2017-09-04T14:25:34","slug":"datenbankverbindung-herstellen-per-storageprovider","status":"publish","type":"post","link":"https:\/\/hahne-software.de\/?p=143","title":{"rendered":"Datenbankverbindung herstellen per StorageProvider"},"content":{"rendered":"<p>Die Klasse TStorageProvider ist das Verbindungsglied zur Kommunikation der StorableObjects zur Datenbank. TStorageProvider kann nicht direkt verwendet werden, da diese Klasse nur als Vorlage f\u00fcr konkrete Implementation f\u00fcr verschiedene Datenbankzugriffskomponenten dient. Im Moment werden die dbGo (ADO), UniDAC und SDAC (MS SQL) von DevArt und IB f\u00fcr Interbase\/Firebird Komponenten unterst\u00fctzt.<\/p>\n<p>Beispiel f\u00fcr den Zugriff auf eine MS Access Datenbank per ADO mit Connectionstring:<\/p>\n<pre>sp := TStorageProviderADODB.Create('Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"test.mdb\";Persist Security Info=False');\r\nsp.SetDBType(dbtAccess,0); \/\/ Datenbanktyp, Version der DB\r\nsp.Open;<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Die Klasse TStorageProvider ist das Verbindungsglied zur Kommunikation der StorableObjects zur Datenbank. TStorageProvider kann nicht direkt verwendet werden, da diese Klasse nur als Vorlage f\u00fcr konkrete Implementation f\u00fcr verschiedene Datenbankzugriffskomponenten dient. Im Moment werden die dbGo (ADO), UniDAC und SDAC (MS SQL) von DevArt und IB f\u00fcr Interbase\/Firebird Komponenten unterst\u00fctzt. Beispiel f\u00fcr den Zugriff auf [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,3],"tags":[],"class_list":["post-143","post","type-post","status-publish","format-standard","hentry","category-delphi","category-storableobjects"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/hahne-software.de\/index.php?rest_route=\/wp\/v2\/posts\/143","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hahne-software.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hahne-software.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hahne-software.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hahne-software.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=143"}],"version-history":[{"count":5,"href":"https:\/\/hahne-software.de\/index.php?rest_route=\/wp\/v2\/posts\/143\/revisions"}],"predecessor-version":[{"id":190,"href":"https:\/\/hahne-software.de\/index.php?rest_route=\/wp\/v2\/posts\/143\/revisions\/190"}],"wp:attachment":[{"href":"https:\/\/hahne-software.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hahne-software.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hahne-software.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}