How to store attachment and image from HCL notes to MS SQL database?

Question

0.00/5 (No votes)

See more:

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 attachment can be like 0.5 MB to 3 MB.

It says

Overflow

on this line

Redim attachmentBytes(32768) 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.

What I have tried:

I have tried stream and byte array but in vain. In fact, I'm looking for a function of GetEmbeddedObject which can provide the attachment object in like a binary stream or byte array or anything.

Posted 3-May-23 20:13pm

baburman

Updated 6-May-23 21:15pm

Add a Solution

Comments

CHill60 4-May-23 5:09am

I never store binaries in the database - I use a file system to store them and just store that (relative) location in the database table. It's a common technique.

mtoha 8-May-23 6:44am

I am agree with above comment. never store file in the database. I store my file to hdd/ssd disk space or file store firebase or something like that. You can also using FTP if needed.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 10601191 · Answer 1 · 2023-05-06T21:15:00

Solution 1

hi, probably need one of the blob datatypes for the image. you mention 'attachments' but don't give details ... if its text then use the TEXT datatype.

check out :
https://dev.mysql.com/doc/refman/8.0/en/data-types.html

Posted 6-May-23 21:15pm

Member 10601191

Comments

baburman 31-May-23 0:46am

By attachment i mean images and pdf documents.