Subject | insert large files > 1GB in BLOBs |
---|---|
Author | patelsop_05 |
Post date | 2005-02-02T15:25:10Z |
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
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