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

[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

"Dries" <dr***@bestopia.be> wrote in message
news:11***************@seven.kulnet.kuleuven.ac.be ...

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

[Lebesgue]

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

Try this:
http://msdn.microsoft.com/library/de...omdatabase.asp

"Claus Konrad" <some> wrote in message
news:OF**************@TK2MSFTNGP14.phx.gbl...

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" <dr***@bestopia.be> wrote in message
news:11***************@seven.kulnet.kuleuven.ac.be ...

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

[Claus Konrad]

Thanks!

Just the info I was looking for...

/C
"Lebesgue" <no****@spam.jp> wrote in message
news:e3**************@TK2MSFTNGP09.phx.gbl...

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

Try this:
http://msdn.microsoft.com/library/de...omdatabase.asp

"Claus Konrad" <some> wrote in message
news:OF**************@TK2MSFTNGP14.phx.gbl...

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" <dr***@bestopia.be> wrote in message
news:11***************@seven.kulnet.kuleuven.ac.be ...

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