Using VC2008 to store bytea, I got AppendChunk error 800a0c93

From: sunpeng <bluevaley(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Using VC2008 to store bytea, I got AppendChunk error 800a0c93
Date: 2014-07-04 00:58:47
Message-ID: CAOYKhLqC5O8MbvjSLkGHw4zU=3qAjnXUq8cx_dUdJrfSXkmPhw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

My server is pg 9.1.13 in win8 64, my client is win xp 32 bit
installed psqlodbc_09_01_0200.zip(ide is VS2008, vc++).
When I store pic binary data to bytea (field is CapturePic) using:
try
{
m_pRecordset->AddNew();
iTimes++;

VARIANT bitdata[3];

SAFEARRAY *psafe[3] = {NULL, NULL, NULL};
SAFEARRAYBOUND band[3];

if (pFreImg != NULL && FreImgSize > 0)
{
bitdata[0].vt = VT_ARRAY | VT_UI1;
band[0].cElements = FreImgSize;
band[0].lLbound = 0;
psafe[0] = SafeArrayCreate(VT_UI1, 1, &band[0]);

for (long iSize = 0; iSize < FreImgSize; iSize++)
{
SafeArrayPutElement(psafe[0], &iSize, &pFreImg[iSize]);
}

bitdata[0].parray = psafe[0];
if (bitdata[0].parray != NULL)
{
m_pRecordset->GetFields()->GetItem("CapturePic")->AppendChunk(&bitdata[0]);
}
...
m_pRecordset->Update();
...
}catch()

I got com_error (at line ...>AppendChunk() ),and see in AppendChunk():
HRESULT _hr = raw_AppendChunk(data);
I got: hresult 800a0c93

see http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-800a0c93-errors.html

how to resolve it?

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Inoue, Hiroshi 2014-07-04 03:27:08 Re: [PATCHSET] Docs, old build files changes
Previous Message Adrian Klaver 2014-07-03 23:12:54 Re: Connction string lacks some options