{"id":2143,"date":"2025-03-25T17:03:14","date_gmt":"2025-03-25T09:03:14","guid":{"rendered":"https:\/\/www.yohz.com\/blogs\/?p=2143"},"modified":"2025-03-25T17:03:14","modified_gmt":"2025-03-25T09:03:14","slug":"extracting-ole-thumbnails-using-sql-image-viewer","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2025\/03\/25\/extracting-ole-thumbnails-using-sql-image-viewer\/","title":{"rendered":"Extracting OLE thumbnails using SQL Image Viewer"},"content":{"rendered":"<p>When viewing OLE-Object data in a database using <a href=\"https:\/\/www.yohz.com\/siv8_details.htm\">SQL Image Viewer<\/a>, a thumbnail of the embedded OLE object is displayed if one is available.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2146\" src=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2025\/03\/olethumbnail02.png\" alt=\"\" width=\"820\" height=\"143\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2025\/03\/olethumbnail02.png 820w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2025\/03\/olethumbnail02-300x52.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2025\/03\/olethumbnail02-768x134.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2025\/03\/olethumbnail02-624x109.png 624w\" sizes=\"(max-width: 820px) 100vw, 820px\" \/><\/p>\n<p>From <a href=\"https:\/\/www.yohz.com\/siv8_details.htm\">SQL Image Viewer<\/a> 12.5, you can now extract these thumbnails in addition to the OLE object that&#8217;s stored.\u00a0 To do this, select the <strong>Extract OLE thumbnails<\/strong> option during the export process.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2145\" src=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2025\/03\/olethumbnail01-1.png\" alt=\"\" width=\"555\" height=\"146\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2025\/03\/olethumbnail01-1.png 555w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2025\/03\/olethumbnail01-1-300x79.png 300w\" sizes=\"(max-width: 555px) 100vw, 555px\" \/><\/p>\n<p>There are a couple of situations where this is useful.<\/p>\n<ol>\n<li>A linked OLE-Object image file may no longer be available, but a thumbnail was stored.\u00a0 You can now at least extract the thumbnail.<\/li>\n<li>You only need the image and not the entire file.\u00a0 In the above example, the embedded OLE objects are Origin project files.\u00a0 If we only need the image from the project, exporting the thumbnails gives us the image, without needing to first export the project file, open it, then save the image to disk.<\/li>\n<\/ol>\n<p>Download the latest version of SQL Image Viewer using this <a href=\"https:\/\/www.yohz.com\/downloads\/sqlblobviewer\/SQLImageViewerSetup.zip\">link<\/a>.<\/p>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.yohz.com\/blogs\/2025\/03\/25\/extracting-ole-thumbnails-using-sql-image-viewer\/\" action=\"like\" colorscheme=\"light\" layout=\"button\"  size=\"small\"><\/fb:like><\/div><div class=\"fb-share-button  \" data-href=\"https:\/\/www.yohz.com\/blogs\/2025\/03\/25\/extracting-ole-thumbnails-using-sql-image-viewer\/\" data-type=\"button\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>When viewing OLE-Object data in a database using SQL Image Viewer, a thumbnail of the embedded OLE object is displayed if one is available. From SQL Image Viewer 12.5, you can now extract these thumbnails in addition to the OLE object that&#8217;s stored.\u00a0 To do this, select the Extract OLE thumbnails option during the export [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[11],"tags":[223,12],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/2143"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=2143"}],"version-history":[{"count":1,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/2143\/revisions"}],"predecessor-version":[{"id":2147,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/2143\/revisions\/2147"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=2143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=2143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=2143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}