Обсуждение: Using VC2008 to store bytea, I got AppendChunk error 800a0c93

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?

Are you turning on *bytea as LO* option?

regards,
Hiroshi Inoue

(2014/07/04 9:58), sunpeng wrote:
> 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?


--
I am using the free version of SPAMfighter.
SPAMfighter has removed 11332 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

Do you have a slow PC? Try a Free scan
http://www.spamfighter.com/SLOW-PCfighter?cid=sigen

(2014/07/04 15:35), sunpeng wrote:
> Yea, I've set *bytea as LO* option in Page 2, but error still exists.
> I use ADO instead of DataSource of ODBC.

What's the connection string you are using in your ADO app?

regards,
Hiroshi Inoue
>
> peng
>
>
> On Fri, Jul 4, 2014 at 11:49 AM, Inoue, Hiroshi <inoue@tpf.co.jp
> <mailto:inoue@tpf.co.jp>> wrote:
>
>     Are you turning on *bytea as LO* option?
>
>     regards,
>     Hiroshi Inoue
>
>
>     (2014/07/04 9:58), sunpeng wrote:
>
>         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
>         <http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-800a0c93-errors.html>
>
>         how to resolve it?
>
>
>
>     --
>     I am using the free version of SPAMfighter.
>     SPAMfighter has removed 11332 of my spam emails to date.
>     Get the free SPAMfighter here: http://www.spamfighter.com/len
>
>     Do you have a slow PC? Try a Free scan
>     http://www.spamfighter.com/__SLOW-PCfighter?cid=sigen
>     <http://www.spamfighter.com/SLOW-PCfighter?cid=sigen>
>
>

hr = m_pConnection.CreateInstance("ADODB.Connection");
sql.Format(_T("Driver=%s;Server=%s;Database=%s"),strDriver,strIP,strDBName);

strDriver is "PostgreSQL ANSI" or "PostgreSQL Unicode"

On 7/5/14, Inoue, Hiroshi <inoue@tpf.co.jp> wrote:
>
> (2014/07/04 15:35), sunpeng wrote:
>> Yea, I've set *bytea as LO* option in Page 2, but error still exists.
>> I use ADO instead of DataSource of ODBC.
>
> What's the connection string you are using in your ADO app?
>
> regards,
> Hiroshi Inoue
>>
>> peng
>>
>>
>> On Fri, Jul 4, 2014 at 11:49 AM, Inoue, Hiroshi <inoue@tpf.co.jp
>> <mailto:inoue@tpf.co.jp>> wrote:
>>
>>     Are you turning on *bytea as LO* option?
>>
>>     regards,
>>     Hiroshi Inoue
>>
>>
>>     (2014/07/04 9:58), sunpeng wrote:
>>
>>         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
>>
>> <http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-800a0c93-errors.html>
>>
>>         how to resolve it?
>>
>>
>>
>>     --
>>     I am using the free version of SPAMfighter.
>>     SPAMfighter has removed 11332 of my spam emails to date.
>>     Get the free SPAMfighter here: http://www.spamfighter.com/len
>>
>>     Do you have a slow PC? Try a Free scan
>>     http://www.spamfighter.com/__SLOW-PCfighter?cid=sigen
>>     <http://www.spamfighter.com/SLOW-PCfighter?cid=sigen>
>>
>>
>

(2014/07/07 12:44), sunpeng wrote:
> hr = m_pConnection.CreateInstance("ADODB.Connection");
> sql.Format(_T("Driver=%s;Server=%s;Database=%s"),strDriver,strIP,strDBName);

Please add ";C7=1" which turns on *bytea as lo* option to your
connection string or
directly specify the data source name as the connectiion string
    _T("DSN=%s")
.

> strDriver is "PostgreSQL ANSI" or "PostgreSQL Unicode"

<snip>

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

Does SafeArrayPutElelment() work as you expect?
The input of the function is psafe[0] and the output is &pFreImg[iSize].

regards,
Hiroshi Inoue

--
I am using the free version of SPAMfighter.
SPAMfighter has removed 11419 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

Do you have a slow PC? Try a Free scan
http://www.spamfighter.com/SLOW-PCfighter?cid=sigen