OutOfMemory
Posted: Wed 09 Oct 2013 10:34
*I`m writing in English to make topic readable for bigger audience.
The problem is as simple as an apple - to insert 2GB into sql server`s varbinary(max) field.
Unfortunately, even on 600 MB file it fails with OutOfMemory exception, the same as ADO did for ages.
Could you please double check parameters handling routines.
And, yes, I know, I can split files into pieces and store/upload/select them as pieces - currently not an option.
Latest trial SDAC & x86 app, delphi 2010.
The problem is as simple as an apple - to insert 2GB into sql server`s varbinary(max) field.
Code: Select all
{
CREATE TABLE [dbo].[tmp](
[bin] [varbinary](max) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
insert into tmp (bin) values(:bin)
}
if OpenDialog1.Execute then
begin
MSQuery1.ParamByName('bin').LoadFromFile(OpenDialog1.FileName ,ftBlob);
MSQuery1.Execute;
end;Could you please double check parameters handling routines.
And, yes, I know, I can split files into pieces and store/upload/select them as pieces - currently not an option.
Latest trial SDAC & x86 app, delphi 2010.