471,347 Members | 1,759 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,347 software developers and data experts.

BLOB (sqlserver) and timeouts

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
Dec 31 '05 #1
4 2403
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

Dec 31 '05 #2
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


Dec 31 '05 #3
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

Jan 1 '06 #4
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


Jan 3 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Carolyn Longfoot | last post: by
3 posts views Thread by Carmine | last post: by
3 posts views Thread by Selen | last post: by
2 posts views Thread by mircu | last post: by
1 post views Thread by Poul Petersen | last post: by
9 posts views Thread by matt | last post: by
reply views Thread by Ronak mishra | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.