How to use CLongBinary to store image of size > 64 KB with Interbase Database 6.0 driver

[navneet professional]

Hi, I stored/retrieved images upto size 64 KB (65535 byte) using CByteArray.But it is not able to save whole image of size 2 MB, partially it saves upto 64 KB of total size 2 MB. How to use CLongBinary to store image of size > 64 KB (upto 2 MB) with Interbase Database 6.0 driver? Please provide me example specific to this database driver. Database table structure is: Create table "TEST" ( "Name" varchar(10), "BlobData" BLOB ); I tried to check BLOB limit of database table as well.I run following queries on database: Case 1: Create table "TEST" ( "Name" varchar(10), "BlobData" BLOB(65535) ); Result: Successfully created. Case 2: Create table "TEST" ( "Name" varchar(10), "BlobData" BLOB(65536) ); Result: Dynamic SQL Error Error code -842 shown as: unsigned short integer expected. So please help me to resove this problem. Thanks & Regards Navneet