How to store attachment and image from HCL Notes to MS Sql database?

Question

I have to store attachments and pictures from HCL Notes to MS Sql database. I encounter two issues. First the Notes array limit is 32767 whereas the attachement can be like 0.5 MB to 3 MB.

It says

Overflow

on this line

Redim attachmentBytes(32767) As Byte

when I try to save the code in the designer.

So I think I have to build like an array of arrays to completely store the object. But here comes the second issue: how will I move this array to the varbinary field (attachment) of my table in MS Sql db?

I'll highly appreciate if somebody points to any other thread with such code coz I think this may be pretty common scenario faced by many developers.

I didn't place the code to extract attachments and move into array element for now coz I think that is not much relevant at this time, but I'll place it if asked to do so.

Thanks.

Answer 1

Java can be used instead of LotusScript in some contexts within Notes, and Java will not have that limit. So the first thing I would consider is whether your LotusScript code can be rewritten (fully, or just in part) as a Java agent.