Re: BLOB (sqlserver) and timeouts

Yeah - I've added a "Connection Timeout = 300;" in the
SqlConnection.Connectionstring (default s 15 sec.)
But - same experience...

I wonder if the SqlDataReader.GetBytes(...) could be of any help?
When downloading the image from a webpage (it's actually a movie stored in
the table), it takes like 10 minues as the size is 140 MB.
I just want to connect directly into the databse and grap the movie..

/C

"Dries" <dries@xxxxxxxxxxx> wrote in message
news:1136030631.648246@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Have you tried to increase the Timeout property of the command.
>
> Claus Konrad wrote:
>> Hi
>>
>> What's the better way for retrieving a very large BLOB field from a SQL
>> 2000 (image-field)?
>> I'm currently usign a SqlDataReader, but it times out before all data is
>> retrieved from the table field
>>
>> Is there any good approach for obtaining parts of the field (like
>> Reader.GetBytes(...))...??
>>
>> /C
>>

.

Relevant Pages

  • Re: Suse 10.0 CD downloading time
    ... After choosing a mirror, my downloading time went from 25 ... Darrell Stec darstec@xxxxxxxxxx ... Webpage Sorcery ...
    (alt.os.linux.suse)
  • Re: Here is another implementation using IPAddress and IPHostEntry classes
    ... It will depend on your isp. ... retrieving my routers ip thru a webpage will not work because the webpage ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Background process
    ... When the Thread has fineshed downloading it could send a Message to the Mainprocess that it could set the webpage as wallpaper. ... > I would like to run a background process from a windows forms that would download a web page from the internet and set it as backgound wallpaper on desktop. ...
    (microsoft.public.win32.programmer.ui)
  • Planet
    ... Anyone tried this software from ADAS yet? ... and nothing appeared, on downloading the file off the webpage, I find ... Steve Rawlings ...
    (uk.business.agriculture)
  • Re: Is there a 2.0Beta Class Library Reference?
    ... every webpage seems to be about 1MB which makes ... it difficult to read online (on a slow connection). ... without downloading the entire SDK (which is about 300 MB ...
    (microsoft.public.dotnet.framework)