PBMaxBlobSize

Description

Specifies the maximum blob size that DataWindow Designer can read into memory.

When to specify PBMaxBlobSize You must specify a value for the PBMaxBlobSize parameter before connecting to the database.

Applies to

ADO.NET
OLE DB

Syntax

PBMaxBlobSize = value

Default

PBMaxBlobSize=1024000 (ADO.NET and OLE DB), PBMaxBlobSize=32767 (other interfaces)

Usage

DataWindow Designer does not restrict the maximum blob size. Instead, the maximum blob size is determined by the machine on which the application is running. If the blob size exceeds the available memory on the machine on which the application is running, DataWindow Designer reads the blob in chunks if the data provider supports the ISequentialStream interface. If the blob size exceeds the default value and the data provider does not support the ISequentialStream interface, DataWindow Designer truncates it and reports an out-of-memory error. Use the PBMaxBlobSize parameter to specify larger maximum blob sizes.

Examples

Example 1

To set the PBMaxBlobSize value to 200000:

Database profile Type the following in the Maximum In-Memory Blob Size box on the Transaction tab in the Database Profile Setup dialog box:
```
200000
```

Application Type the following in code:

SQLCA.DbParameter="PBMaxBlobSize=200000"