{"id":132,"date":"2010-11-11T13:25:50","date_gmt":"2010-11-11T13:25:50","guid":{"rendered":"http:\/\/blog.joefield.co.uk\/?p=132"},"modified":"2010-11-26T00:51:01","modified_gmt":"2010-11-26T00:51:01","slug":"oracle-linked-server-from-sqlexpress","status":"publish","type":"post","link":"https:\/\/blog.joefield.co.uk\/?p=132","title":{"rendered":"Oracle Linked Server from SQL Express 2005"},"content":{"rendered":"<p>Using SQL Server Management Studio to set up an Oracle Linked Server.<\/p>\n<p>When setting up a linked server to Oracle from a SQL Express 2005 instance using the OraOLEDB.Oracle OLE DB Provider you need to be able to change the &#8220;AllowInProcess&#8221; property to true from the provider properties.  Or it doesn&#8217;t work.<\/p>\n<p>Problem&#8230; when connecting to a SQL Express 2005 instance there is no properties dialog available for the provider.<\/p>\n<p>Solution:<\/p>\n<p>EXEC sp_MSset_oledb_prop N&#8217;OraOLEDB.Oracle&#8217;, N&#8217;AllowInProcess&#8217;, 1<\/p>\n<p>in the master database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Using SQL Server Management Studio to set up an Oracle Linked Server. When setting up a linked server to Oracle from a SQL Express 2005 instance using the OraOLEDB.Oracle OLE DB Provider you need to be able to change the &#8220;AllowInProcess&#8221; property to true from the provider properties. Or it doesn&#8217;t work. Problem&#8230; when connecting [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.joefield.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/132"}],"collection":[{"href":"https:\/\/blog.joefield.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.joefield.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.joefield.co.uk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.joefield.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=132"}],"version-history":[{"count":9,"href":"https:\/\/blog.joefield.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/132\/revisions"}],"predecessor-version":[{"id":141,"href":"https:\/\/blog.joefield.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/132\/revisions\/141"}],"wp:attachment":[{"href":"https:\/\/blog.joefield.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.joefield.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.joefield.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}