如何在Sql Server 2008 R2中检索.exe文件 [英] How to retrieve the .exe files in Sql Server 2008 R2

问题描述

我在DB中有附件。我将一个文件（.exe）存储在Varbinary Column表中。当我尝试检索该行时，将显示以下消息。请帮我。





消息10054，等级20，状态0，行0

运输级别从服务器接收结果时发生错误。 （提供者：TCP提供者，错误：0 - 远程主机强行关闭现有连接。）





出于.jpg，。jpeg等.exe我能够检索

Hi,


I have a attachment in DB. I stored a file(.exe) in a table Varbinary Column. When I try to retrieve the row, the below message will come. Please help me.


Msg 10054, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)


Out of .exe like .jpg,.jpeg,etc I have able to retrieve

推荐答案

没有一个解决方案。

从这里开始： http://blogs.msdn.com/ b /穗/存档/ 2009/04/16 / A时，送的请求到所述服务器提供商-TCP-提供商传输 - 电平 - 误差已-发生-误差-0-AN-现有连接被强制关闭 - 远程主机.aspx [ ^ ] - 它可能会有所帮助。



另外，检查EXE二进制文件有多大，如果它是非常庞大的，然后SQL很可能只是超时请求等待数据。它也值得检查你的查询，并确保它只返回一个文件，而不是DB中的每个文件......

There is no one single solution to this.
Start here: http://blogs.msdn.com/b/spike/archive/2009/04/16/a-transport-level-error-has-occurred-when-sending-the-request-to-the-server-provider-tcp-provider-error-0-an-existing-connection-was-forcibly-closed-by-the-remote-host.aspx[^] - it may help.

Also, check how big the EXE binary is, if it is seriously huge then it is vaguely possible that SQL is just timing out the request waiting for the data. It's also worth checking your query, and making sure that it is only returning a single file, rather than every file in the DB...

这篇关于如何在Sql Server 2008 R2中检索.exe文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！