Re: [Firebird-net-provider] Error inserting lage blobs

[Sam M. <sam...@cl...>]

Sorry, I thought I posted this...

This is the insert code:

StreamReader ValuesStream = new StreamReader(FileName);
string ValueList = string.Empty;
while (ValuesStream.Peek() >= 0)
{
  ValueList = ValuesStream.ReadLine();
  Cmd.CommandText = "INSERT INTO " + TableReference + " " + ColumnList + "
VALUES (" + ValueList + ");";
  Cmd.ExecuteNonQuery();
}
ValuesStream.Close();


And it generates this error:

A first chance exception of type 'System.Net.Sockets.SocketException'
occurred in system.dll

Additional information: An existing connection was forcibly closed by the
remote host

If I reduce the size of the data I am inserting into the XML filed then it
works fine.

Thanks!

Sam



"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:407...@te......
> Hello:
>
> > I have a column defined as a BLOB SUB_TYPE TEXT
> > When I do an INSERT with a length of 736,174 bytes then an error is
raised
>
> What error ?? How re you doing the insert ??
>
>
>
> --
> Best regards
>
> Carlos Guzmán álvarez
> Vigo-Spain
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>