When I am trying to save images to DB2 using IBM DB2 .

I am gettting "Invalid BLOB length". I am getting this error when I am trying to save image > 32KB.

I am using dbexpca400.dll With DBExpress (Delphi 6)

dbexpca400.dll Creator :

IBM Client Access/400 driver for dbExpress
Copyright © 2001-2003 Peter Sawatzki (Peter@Sawatzki.de)
Mail: Buchenhof 3, 58091 Hagen, GERMANY
WWW: http://www.sawatzki.de

Hi,

did you checked the bde-blob-settings with bde admin ( blob size and blobs to cache) ?

markus

if the check and already follows equal.

Configuratión/Driver/Native/DB2

I am using dbexpca400.dll With DBExpress (Delphi 6)

hi,

i think you have to look at the database-tab.
click the alias you need and check the settings on the "definition" page on the right. we always change the settings for "blob size" and "blobs to cache" both to -1. after this, we have no more problems with blobs.
we use d7 and mdac accessing ms sql servers.
the changes at the ...\driver\ tab will only used for new alias definitions you make, i think.

Hi and thanks for the aid :

The message of exact error is:

<with DBExpress>

CwbDB_RetrieveLOBDATA Returned erro code 6038

Server 2 error class 2 code –806

Message id PWS0006
Value for parameter is not Valid.
Cuase: The function cannot be run because the value for a parameter is not valid. The parameter is not valid for one the following reasons: the value provided is not valid value, then length of the parameter value is either too short or too long, the value provided is not allowed because of the value supplied for another parameter Recovery: Specify a valid value and length for the parameter and run the function again.

<with ODBC>
"Invalid BLOB length"'

that you think and that you recommend to me.



configuration of dbxdrivers for DBExpress:
************************************************** **********
[Installed Drivers]
DB2=1
CA400=1
Interbase=1
MySQL=1
Oracle=1
Informix=1
MSSQL=1

[DB2]
GetDriverFunc=getSQLDriverDB2
LibraryName=dbexpdb2.dll
VendorLib=db2cli.dll
Database=DBNAME
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
DB2 TransIsolation=ReadCommited


[CA400]
GetDriverFunc=getSQLDriverCA400
LibraryName=dbexpca400.dll
VendorLib=cwbdb.dll
Database=MYAS400
User_Name=
Password=
ServerCharSet=
ErrorResourceFile=
LocaleCode=0000
BlobSize=-1
RowsetSize=-1
RoleName=
CA400 TransIsolation=DirtyRead
CommitRetain=True
AutoCommit=True
Custom String=/trace=0
Connection Timeout=-1
Trim Char=False

[CA400 TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2

[Interbase]
GetDriverFunc=getSQLDriverINTERBASE
LibraryName=dbexpint.dll
VendorLib=gds32.dll
Database=database.gdb
RoleName=RoleName
User_Name=sysdba
Password=masterkey
ServerCharSet=
SQLDialect=1
BlobSize=-1
CommitRetain=False
WaitOnLocks=True
ErrorResourceFile=
LocaleCode=0000
Interbase TransIsolation=ReadCommited
Trim Char=False

[MySQL]
GetDriverFunc=getSQLDriverMYSQL
LibraryName=dbexpmysql.dll
VendorLib=libmysql.dll
HostName=ServerName
Database=DBNAME
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000

[Oracle]
GetDriverFunc=getSQLDriverORACLE
LibraryName=dbexpora.dll
VendorLib=oci.dll
DataBase=Database Name
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
Oracle TransIsolation=ReadCommited
RowsetSize=20
OS Authentication=False
Multiple Transaction=False
Trim Char=False

[Informix]
GetDriverFunc=getSQLDriverINFORMIX
LibraryName=dbexpinf.dll
VendorLib=isqlb09a.dll
HostName=ServerName
DataBase=Database Name
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
Informix TransIsolation=ReadCommited
Trim Char=False

[MSSQL]
GetDriverFunc=getSQLDriverMSSQL
LibraryName=dbexpmss.dll
VendorLib=oledb
HostName=ServerName
DataBase=Database Name
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
MSSQL TransIsolation=ReadCommited
OS Authentication=False


[AutoCommit]
False=0
True=1

[BlockingMode]
False=0
True=1

[WaitOnLocks]
False=1
True=0

[CommitRetain]
False=0
True=1

[OS Authentication]
False=0
True=1

[Multiple Transaction]
False=0
True=1

[Trim Char]
False=0
True=1

[DB2 TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2

[Interbase TransIsolation]
ReadCommited=1
RepeatableRead=2

[Oracle TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2

[Informix TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2

[MSSQL TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2

[SQLDialect]
1=0
2=1
3=2

************************************************** *******

thanks