Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Large Data Types in OLE DB (SQL Server Compact)

Large Data Types in OLE DB (SQL Server Compact)

The OLE DB Provider for Microsoft SQL Server Compact 4.0 supports the ISequentialStream and ILockBytes interfaces for accessing large data values in individual pieces.

ISequentialStream lets clients read parts of a long-value column in a sequential, forward-only manner. ILockBytes can access data in a random manner. By using these structured storage interfaces to access arbitrarily large data values (image and ntext data types), you can avoid potential errors caused by the system trying to read the value into memory in one complete piece.

For more information about using ILockBytes, see ILockBytes (SQL Server Compact).

© 2015 Microsoft