将nText导出为文件 [英] Export nText as Files

问题描述

您好！


我有一个SQL Server数据库，其中gif图像存储在nText字段中作为
二进制文件。我被要求将这些图像导出为实际的gif文件

（约250个）。我找到了一个使用ADO

的存储过程，它会正确地写入图像的一小部分，然后

休息是一团糟。我被告知要查看ADO和VB组，看看

，如果有人知道这个的解决方案。


有没有人有任何资源或例子你可以指点我吗？我已经

之前从未使用过ADO而且我已经使用过小VB了。


谢谢，


-

Jerry

Hello!

I have a SQL Server database with gif images stored in a nText field as
binary. I''ve been asked to export these images to actual gif files
(about 250 of them). I found a stored procedure that was using some ADO
and it would write a small part of the image correctly and then the
rest was a mess. I was told to check out the ADO and VB groups to see
if anyone knows of a solution for this.

Does anyone have any resources or examples you could point me to? I''ve
never used ADO before and I''ve used little VB.

Thanks,

--
Jerry

推荐答案

我永远不会将gif存储在数据库中。将图像存储在一个文件夹中

并记录数据库中的位置。

I would never store a gif in a database. Store the image in a folder
and record the location in the database.

我不会存储图像一个数据库。图像已经存储在数据库中了，我是幸运的，继承了这个问题。


-

Jerry

I wouldn''t store an image in a database either. The images are already
stored in the database and I''m the lucky one who inherited the issue.

--
Jerry

2006年4月28日08:59:03 -0700，Jerry < JE ******* @ gmail.com>写道：

$ b $b¤您好！
$ b $b¤
$ b $b¤我有一个SQL Server数据库，其中gif图像存储在nText字段中
$ b $b¤二进制。我被要求将这些图像导出为实际的gif文件
$ b $b¤（约250个）。我发现一个存储过程使用了一些ADO
$ b $b¤它会正确地写出一小部分图像，然后
$ b $b¤休息是一团糟。有人告诉我看看ADO和VB小组看看
$ b $b¤如果有人知道解决方案的话。
$ b $b¤
$ b $b¤是吗？有人可以指点我的任何资源或例子吗？我以前从未使用过ADO，而且我已经使用过小VB了。
$ b $b¤


看看是否以下帮助。我假设它们没有存储为OLE对象。


如何使用GetChunk和AppendChunk读取和写入BLOB
http://support.microsoft.com/default.aspx/kb/194975

Paul

~~~~

Microsoft MVP（Visual Basic）

On 28 Apr 2006 08:59:03 -0700, "Jerry" <je*******@gmail.com> wrote:

¤ Hello!
¤
¤ I have a SQL Server database with gif images stored in a nText field as
¤ binary. I''ve been asked to export these images to actual gif files
¤ (about 250 of them). I found a stored procedure that was using some ADO
¤ and it would write a small part of the image correctly and then the
¤ rest was a mess. I was told to check out the ADO and VB groups to see
¤ if anyone knows of a solution for this.
¤
¤ Does anyone have any resources or examples you could point me to? I''ve
¤ never used ADO before and I''ve used little VB.
¤

See if the following helps. I''m assuming they are not stored as OLE Objects.

How To Read and Write BLOBs Using GetChunk and AppendChunk
http://support.microsoft.com/default.aspx/kb/194975
Paul
~~~~
Microsoft MVP (Visual Basic)

这篇关于将nText导出为文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！