BLOB (sqlserver) and timeouts

[Claus Konrad]

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

 

[Dries]

Have you tried to increase the Timeout property of the command.

 

[Claus Konrad]

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

 

[Lebesgue]

You need to specify sequential access if retrieving large binary data.

Try this:
http://msdn.microsoft.com/library/d...html/cpconobtainingblobvaluesfromdatabase.asp

 

[Claus Konrad]

Thanks!

Just the info I was looking for...

/C

You need to specify sequential access if retrieving large binary data.

Try this:
http://msdn.microsoft.com/library/d...html/cpconobtainingblobvaluesfromdatabase.asp