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(...))...??
BLOB (sqlserver) and timeouts ... What's the better way for retrieving a very large BLOB field from a SQL 2000 ... I'm currently usign a SqlDataReader, but it times out before all data is ... (microsoft.public.dotnet.languages.csharp)
Re: How do the records retrieve from data base when using sql statements? ... file size changes significantly the query optimizer may decide to get the ... unless you have select/omit criteria in a logical that you want SQL to ... And I'd recommend using the SQL against the physical file,... on the physical file only, ensures retrieving rows according ... (comp.sys.ibm.as400.misc)
Re: Problem with XMLType attribibutes? please confirm ... >> Frank van Bortel wrote: ... > it, didn't contain data retrieving.... Then your Oracle isn't UTF8 aware I guess. ...SQL> insert into my_table values(1, ... (comp.databases.oracle.server)
Re: How do the records retrieve from data base when using sql statements? ... file size changes significantly the query optimizer may decide to get the ... unless you have select/omit criteria in a logical that you want SQL to ... on the physical file only, ensures retrieving rows according ... (comp.sys.ibm.as400.misc)
Re: advice needed - what approach for sql access ... One option is to cache the DataSet in the Session or ViewState.... how much data you're retrieving, but that obviously affects what is the ... > with data from an SQL database, unfortunately I've been advised that this ... then update the SQL tables with an update query afterwards.... ... (microsoft.public.dotnet.faqs)
