>>>Say,
>>>
>>>oStream = loAttachment.GetDecodedContentStream()
>>>
>>>cText = oStream.ReadText()
>>
>>Unfortunately object does not support the ReadText() method returning error:
>>OLE IDispatch exception code 0 from ADODB.Stream: Operation is not allowed in this context...
>>
>>All I know is that loAttachment.GetDecodedContentStream() returns an object (VARTYPE()=O), other than that I don't have much information on how to read these attachments, I don't even know if GetDecodedContentStream() is the correct method of retreiving the attachment but it is all I can find.
>
>Which methods does it support? Can you find out using Intellisense?
>
>Can you try
>
>

>loStream = loAttachment.GetDecodedContentStream()
>lwStream = loStream.Read()
>INSERT INTO Attachments (iTimeId, wAttachmnt) VALUES (lnTimeId, lwStream)

Unfortunately I have no debugging ability because this is running as a COM object so can't get to see what methods are available. Just tried the above and it partially works, it put what looks like a string of hex into wAttachmnt.