{"id":38,"date":"2012-10-23T09:05:56","date_gmt":"2012-10-23T07:05:56","guid":{"rendered":"http:\/\/neuronetix.de\/?p=38"},"modified":"2019-02-25T20:04:46","modified_gmt":"2019-02-25T18:04:46","slug":"oledb-provider-properties-verandern-in-microsoft-sql-server-express","status":"publish","type":"post","link":"https:\/\/neuronetix.de\/?p=38","title":{"rendered":"OLEDB Provider Properties ver\u00e4ndern in Microsoft SQL Server Express"},"content":{"rendered":"<p>SQL Server Express Edition bietet nicht die M\u00f6glichkeit OLEDB Provider Properties per SQL Server Management Studio einzustellen. Das entsprechende Userinterface in SQL Server Management Studio ist schlicht nicht vorhanden.<\/p>\n<p>Dennoch lassen sich OLEDB Provider Einstellungen \u00fcber die Stored Procedure sp_MSset_oledb_prop einstellen.\u00a0Hier im Beispiel wird &#8218;Allow In Process&#8216; f\u00fcr den Oracle OLEDB Provider ORAOLEDB.Oracle auf &#8218;True&#8216; gesetzt.<\/p>\n<pre>EXEC master.dbo.sp_MSset_oledb_prop N'ORAOLEDB.Oracle', N'AllowInProcess', 1<\/pre>\n<p>Das T-SQL Statement kann entweder im SQL Server Management Studio von SQL Server Express Edition with Advanced Services oder auf der Kommandozeile mittels osql ausgef\u00fchrt werden.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server Express Edition bietet nicht die M\u00f6glichkeit OLEDB Provider Properties per SQL Server Management Studio einzustellen. Das entsprechende Userinterface in SQL Server Management Studio ist schlicht nicht vorhanden. Dennoch lassen sich OLEDB Provider Einstellungen \u00fcber die Stored Procedure sp_MSset_oledb_prop einstellen.\u00a0Hier im Beispiel wird &#8218;Allow In Process&#8216; f\u00fcr den Oracle OLEDB Provider ORAOLEDB.Oracle auf &#8218;True&#8216; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[8],"tags":[35,33,36,37,34],"_links":{"self":[{"href":"https:\/\/neuronetix.de\/index.php?rest_route=\/wp\/v2\/posts\/38"}],"collection":[{"href":"https:\/\/neuronetix.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/neuronetix.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/neuronetix.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/neuronetix.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=38"}],"version-history":[{"count":6,"href":"https:\/\/neuronetix.de\/index.php?rest_route=\/wp\/v2\/posts\/38\/revisions"}],"predecessor-version":[{"id":399,"href":"https:\/\/neuronetix.de\/index.php?rest_route=\/wp\/v2\/posts\/38\/revisions\/399"}],"wp:attachment":[{"href":"https:\/\/neuronetix.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=38"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/neuronetix.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=38"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/neuronetix.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=38"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}