Amandina
asked on
PDF files into SQL 2008 Varbinary(Max)
Hi,
I am posting pdf files into a table in my sql server. The field in the table is of type Varbinary(MAX).
It works fine with small size pdf-files but when I try to put larger files into the field I get the error:
eoleException with message the text, ntext, or image pointer value conflicts with the column name specified.
the code is:
var
InS, OutS: TStream;
begin
InS := TFileStream.Create(filbox. filename, fmOpenRead);
OutS := tbl_dok.CreateBlobStream(t bl_dokdoku ment, bmWrite);
OutS.CopyFrom(InS, InS.Size);
OutS.Free;
InS.Free;
tbl_dok.Post;
end;
Tbl_dok is an ADOTable.
Hope someone can help.....
I am posting pdf files into a table in my sql server. The field in the table is of type Varbinary(MAX).
It works fine with small size pdf-files but when I try to put larger files into the field I get the error:
eoleException with message the text, ntext, or image pointer value conflicts with the column name specified.
the code is:
var
InS, OutS: TStream;
begin
InS := TFileStream.Create(filbox.
OutS := tbl_dok.CreateBlobStream(t
OutS.CopyFrom(InS, InS.Size);
OutS.Free;
InS.Free;
tbl_dok.Post;
end;
Tbl_dok is an ADOTable.
Hope someone can help.....
ASKER
The size is only 1.557 KB
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As you can read from https://msdn.microsoft.com/en-us/library/ms188362.aspx