Subject insert large files > 1GB in BLOBs
Author patelsop_05
Hello!

I am making a doc management application and everything works very
nicely except this little thing.

I am using ADO.NET as data provider with VB.NET and embedded server
db. When I try to copy large files into blobs I get a out of memory
exception. I have tried following approaches.

Inserting BLOB data using byte array, filestream, binaryreader.

I am thinkning of storing data in chunks like we used to do in VB
using appendchunk and getchunk. However, VB.NET does not support
these methods.

Is there a way to append data to exsisting BLOBs? or any
other "textptr" type function as avalaible with SQL Server to get a
pointer of BLOB?

Thanks

Sopan