打开存储在SQL Server中图像列.doc文件 [英] Open a .doc file stored in SQL Server image column

问题描述

我有很多的 .DOC 的存储在SQL Server 2008中图片列文件。我不知道怎么说数据类型仍然在2008年存在，但我清楚地可以看到它。该软件的数据库是旧的，并且数据库服务器必须升级到2008年。反正 - 不知何故 - 软件仍然功能非常好

I have many .doc files stored in a SQL Server 2008 IMAGE column. I don't know how that datatype still exists in 2008, but I clearly can see it. The software database is old, and database server had to be upgraded to 2008. Anyway - somehow - the software still functions very well.

最近几个月我公司决定去网络解决方案，但保持所有数据完整。我已经开发了整个系统是什么，以及一切都非常好 - 文件，而不是......每当我试图从SQL到下载字节图片专栏中，我得到该文件，但它破坏（至少我得到在MS Word有很多愚蠢的字符的）。但是，当我插入新文件（其存储在图片 COL），然后下载它，一切都很顺利。

Last months my company decided to go for web solution, but with keeping all the data intact. I've developed whole system for that, and everything goes very good - INSTEAD OF FILES... Anytime I try to "download" bytes from the SQL IMAGE column, I get the file, but it's corrupted (at least I'm getting a lot of stupid chars in MS Word). But when I insert the new file (storing it in IMAGE col), and then download it, everything is going well.

任何人在这个世界上是否有一个想法，什么都可以错呢？

Does anybody in this world have an idea what can be wrong with it?

下面是链接到的数据库损坏的文件之一：
https://hotfile.com/dl/226441204/438414c/testFile.doc.html

Here is the link to one of corrupted files in DB: https://hotfile.com/dl/226441204/438414c/testFile.doc.html

推荐答案

在调查的几天，我终于来到了解决方案。由于数据库是由第三方做，我必须知道为了让他们的工作逻辑的FileSave。显然，归类和其他的东西太容易解决的问题。然后我走到JetBrains公司DotPeek，.NET反编译器是真棒。它有我需要的一切确定确切的节省流量。我发现，文件被保存密码保护流。这是很容易找到密码，就像现在我把所有的code打开。 Dotfuscating稍微变硬我的研究，但现在一切都还是蛮好的......最后！感谢大家谁试图帮助我，我的道路，解决方案....

After days of investigation, I finally came to solution. As the database was made by the 3rd party, I had to know their filesave logic in order to make it work. Apparently, collations and other thing were too easy to solve the issue. Then I came up to JetBrains DotPeek, .NET decompiler that is awesome. It had everything I need for determining the exact saving flow. I've found that files were saved with password protected stream. It was easy to find the password, as now I had all the code open. Dotfuscating slightly hardened my research, but everything is just fine now... Finally!!! Thanks to everyone who tried to help me on my road to solution....

这篇关于打开存储在SQL Server中图像列.doc文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！