473,224 Members | 1,944 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 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 2525
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Carolyn Longfoot | last post by:
Help! This is driving me crazy... I'm trying to read a BLOB from a db and display it in a browser, like so: $query="SELECT blob from table where blob_id=9"; $result=mysql_query($query);...
3
by: Carmine | last post by:
I have to add a date column to a db2/zos table with a blob column. Can I rename the blob table to old, create a new table with the date column, then insert/select the data from the old table? ...
3
by: Selen | last post by:
I would like to be able to extract a BLOB from the database (SqlServer) and pass it to a browser without writing it to a file. (The BLOB's are word doc's, MS project doc's, and Excel spreadsheets....
2
by: mircu | last post by:
Hi, I need a quick solution to make my application behave correctly when one of these timeouts occurs. I have some logic in session_start but when the authentication cookie timeouts the user is...
1
by: Poul Petersen | last post by:
SQLserver on Small Business Server for Win 2003. Client application updates records in DB. i.e. the content of a field is updated from "First" to "Second" Client application closed and opend...
2
by: Vinciz | last post by:
hi guys... im new in java and i would love to learn some of these... basically i got a sample code to retrieve the blob from the mysql. however, i dont really know what to do with these...
9
by: matt | last post by:
hello, im doing my first ASP.NET app that inserts & retrieves files from Oracle (no need for a discussion on *that*!). i learned first-hand of the somewhat awkward technique for inserting...
10
by: Zytan | last post by:
I have a TcpClient. I set the read/write timeouts at 1 minute (in milliseconds). I get a NetworkStream from it and confirm the timeouts still exist. I do a NetworkStream.Write() and then a...
4
by: skunapareddy | last post by:
I am needing to read a blob from database and pass it to another java program. I researched internet and found a program that reads a file on the client pc and gives bytes, but when I modified the...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...

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.