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

(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