{"id":1935,"date":"2020-02-22T11:54:39","date_gmt":"2020-02-22T11:54:39","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=1935"},"modified":"2020-02-22T11:54:39","modified_gmt":"2020-02-22T11:54:39","slug":"view-list-of-ole-db-providers","status":"publish","type":"post","link":"http:\/\/www.theSQLReport.com\/?p=1935","title":{"rendered":"View List of OLE DB Providers"},"content":{"rendered":"<p>Sadly I have not found a better way to view the available OLE DB Providers on a server.\u00a0 Even though I am using an out of support Windows Server 2012 R2, this is still fastest way to view these database drivers.<\/p>\n<p>On the desktop, right click and highlight the New item in the menu, then click on the &#8220;Text Document&#8221; in the second menu.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/List_OLE_DB_Providers_01.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1939 size-full\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/List_OLE_DB_Providers_01.jpg\" alt=\"\" width=\"451\" height=\"399\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/List_OLE_DB_Providers_01.jpg 451w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/List_OLE_DB_Providers_01-300x265.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/List_OLE_DB_Providers_01-210x186.jpg 210w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/a><\/p>\n<p>Rename the file to anything, as long as the file extension ends with &#8220;.udl&#8221;.<\/p>\n<p>If the file still have the text file icon after its renamed, then the &#8220;Hide extensions for known file types&#8221; may need to be unchecked in the Folder Options.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/List_OLE_DB_Providers_02.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1938 size-full\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/List_OLE_DB_Providers_02.jpg\" alt=\"\" width=\"408\" height=\"245\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/List_OLE_DB_Providers_02.jpg 408w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/List_OLE_DB_Providers_02-300x180.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/List_OLE_DB_Providers_02-210x126.jpg 210w\" sizes=\"(max-width: 408px) 100vw, 408px\" \/><\/a><\/p>\n<p>If the file now has a Microsoft Data Link icon, just double click on it.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/List_OLE_DB_Providers_03.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1937 size-full\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/List_OLE_DB_Providers_03.jpg\" alt=\"\" width=\"419\" height=\"268\" \/><\/a><\/p>\n<p>The Data Link Properties dialog box will appear.\u00a0 Click on the Provider tab to view the list of available OLE DB Providers.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/List_OLE_DB_Providers_04.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1936 size-full\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/List_OLE_DB_Providers_04.jpg\" alt=\"\" width=\"497\" height=\"567\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/List_OLE_DB_Providers_04.jpg 497w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/List_OLE_DB_Providers_04-263x300.jpg 263w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2020\/02\/List_OLE_DB_Providers_04-184x210.jpg 184w\" sizes=\"(max-width: 497px) 100vw, 497px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sadly I have not found a better way to view the available OLE DB Providers on a server.\u00a0 Even though I am using an out of support Windows Server 2012 &hellip; <a class=\"readmore\" href=\"http:\/\/www.theSQLReport.com\/?p=1935\">Continue Reading &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":1937,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-1935","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server"],"_links":{"self":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1935"}],"collection":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1935"}],"version-history":[{"count":3,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1935\/revisions"}],"predecessor-version":[{"id":1942,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1935\/revisions\/1942"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/1937"}],"wp:attachment":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1935"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1935"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1935"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}