How to retrieve the .exe files in Sql Server 2008 R2

Question

0.00/5 (No votes)

See more:

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

Posted 2-Nov-14 4:27am

Member 11199965

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-11-02T04:35:00

Solution 1

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...

Posted 2-Nov-14 4:35am

OriginalGriff

Comments

Member 11199965 3-Nov-14 1:25am

HI,

I can't able to select that particular record. So help me how to check that binary size is big or not?

OriginalGriff 3-Nov-14 3:15am

Why can't you select that record? How are you trying?
Have you tries using DATALENGTH?

http://msdn.microsoft.com/en-us/library/ms173486.aspx

Member 11199965 3-Nov-14 3:58am

Hi,

When I tried to find the datalength for the particular rows, the below error message is displayed. Please help me.

FILESTREAM file named with GUID '%.*ls' that belongs to FILESTREAM data file ID 0x%x does not exist or cannot be opened.

OriginalGriff 3-Nov-14 5:43am

What is your table definition?

Member 11199965 3-Nov-14 6:05am

Please find the below is the table properties. Kindly help me.

Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
attachment_id bigint no 8 19 0 no (n/a) (n/a) NULL
attachment varbinary no -1 yes no yes NULL
attachment_name nvarchar no 2000 yes (n/a) (n/a) SQL_Latin1_General_CP1_CI_AS
attachment_type nvarchar no 200 yes (n/a) (n/a) SQL_Latin1_General_CP1_CI_AS

OriginalGriff 3-Nov-14 6:10am

And how are you trying to use it?

Member 11199965 3-Nov-14 6:16am

In that table contains lakhs of records (.jpg,.jpeg,.exe,etc). but I can't able to see the .exe records only.

For Example, in that table 100th row contains .exe records means, I have tried to select that records in the below format.

select * from attachment(table name) where attachment_id = 100

while I run the above query, the below error.

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.)

OriginalGriff 3-Nov-14 6:28am

Is "attachment" a function in your DB? That's not a syntax I am familiar with, or that I can find via google. And my version of SQL 2008R2 complains.

Member 11199965 3-Nov-14 6:32am

No no.. Attachment is a Table. We are stored the images,files in binary format of to this table.

OriginalGriff 3-Nov-14 6:45am

So what exactly is the query you are using? Because

select * from attachment(table name) where attachment_id = 100

can't be it!

Member 11199965 3-Nov-14 7:21am

Actually we are stored all the pdf,img,imeg,exe,etc attachment in a table .

when we are trying to select that records(pdf,img,imeg) from the table it will displayed.

But when we trying to select that records(.exe) from the table it will not displayed. it throws the error.

This is my problem. I hope you understood clearly. Please help me.