473,770 Members | 6,091 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2559
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.C onnectionstring (default s 15 sec.)
But - same experience...

I wonder if the SqlDataReader.G etBytes(...) 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.k ulnet.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******** ******@TK2MSFTN GP14.phx.gbl...
Yeah - I've added a "Connection Timeout = 300;" in the
SqlConnection.C onnectionstring (default s 15 sec.)
But - same experience...

I wonder if the SqlDataReader.G etBytes(...) 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.k ulnet.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******** ******@TK2MSFTN GP09.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******** ******@TK2MSFTN GP14.phx.gbl...
Yeah - I've added a "Connection Timeout = 300;" in the
SqlConnection.C onnectionstring (default s 15 sec.)
But - same experience...

I wonder if the SqlDataReader.G etBytes(...) 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.k ulnet.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
6122
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); $blob=mysql_fetch_assoc($result); Now when I do print_r (array_values($blob));
3
7311
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? Do I have to select data from the main table and the aux table or is the aux table done automatically? What's the best way to handle this?
3
3813
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. How can I do this?
2
1660
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 redirected to login page and after successful login the session is not started. I'd like to have one timeout and when it occurs the user must login and then the new session is started. TIA. Regards, mircu
1
1572
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 again. DB returns value "Second". Next morning _SOME_ - not all - of the updates seems missing. DB returns the value "First" The client software has run for years i several thousand installations, with MSDE/SQLserver on w2k and 2003 servers. This...
2
6534
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 retrieved byte/binary data as i got no idea on how to save them in our pc. For this situation, what i need to do is give the byte/binary data an extension (retrieved from another field in the table) in order to revert back to the original data i had in the...
9
8002
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 binary data into an Oracle BLOB column via ADO.NET. since my files are larger than 33k, it seemed had to use this technique: http://support.microsoft.com/default.aspx?scid=kb;en-us;322796
10
6183
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 NetworkStream.Read(). Sometimes it sits and waits -- on the Write() or the Read() -- for 15 minutes before I get fed up and close the app..... I am not connecting to a TcpListener. I am connecting to a Socket with ProtocolType.Tcp, which is...
4
4262
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 code to read a blob from DB I am not having any luck, I am running this java programs using JDEVELOPER. Can anyone please give me some help? The code is as follows: ... private static byte getBytesFromBlob(Blob blob) throws Exception { ...
0
10232
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10008
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9873
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8891
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7420
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6682
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5454
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3974
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3578
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.