Unable to insert BLOB value into a MSSCE "image" field. Error: 8007000E - Not enough storage is available to complete this operation
- From: "Ender" <linuxmustdie@xxxxxxxxxxx>
- Date: Sun, 13 Jul 2008 01:48:46 +0600
Hi, all.
When I'm trying to add BLOB data into a MS SQL Server Compact edition table I get following error
First chance exception at $767442EB. Exception class EOleException with
message 'Not enough storage is available to complete this operation'.
Error code: 8007000E
The table declaration follows:
create table Pages(
ID integer identity (0, 1) constraint PK_Pages primary key,
Document_ID integer constraint FK_Pag_Document_ID references Documents(ID)
on delete cascade on update cascade,
PageOrder integer not null,
Data image,
constraint UC_Pag_PageOrder unique (Document_ID, PageOrder));
The statement is:
insert into Pages (Document_ID, PageOrder, Data) values (:xDocument_ID,
:xPageOrder, :xData)
The code which assign parameters is (Delphi):
ADOQuery.Parameters.ParamByName('xDocument_ID'):=...;
ADOQuery.Parameters.ParamByName('xPageOrder'):=...;
ADOQuery.Parameters.ParamByName('xData').LoadFromFile('diamond.jpg',
ftBLOB);
LoadFromFile assigns array of bytes loaded from a file to ADO
Parameter.Value and the value 205 (adVarLongBinary) to the Type property.
I have a lot of resources and the image is small ~ 200K. Exactly same code
perfectly works for MS SQL Server Express.
It works if I exclude Data and xData from insert query.
OS: Windows Vista.
Additionally when query is executing Delphi debugger catch stream of
messages sent by OutputDebugString API function. The messages always same
and contain following string:
Debug Output: Invalid parameter passed to C runtime function.
Can someone say what does this error mean and how to insert BLOB value into
a MSSCE table?
.
- Prev by Date: Re: Connecting to two servers
- Next by Date: Re: Connecting to two servers
- Previous by thread: Connecting to two servers
- Next by thread: How to retrieve StoredProc raiserror code?
- Index(es):
Relevant Pages
|
