Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Location
    Aguascaliente, Mexico
    Posts
    4

    Unhappy Unanswered: "Invalid BLOB length"

    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

  2. #2
    Join Date
    Feb 2003
    Location
    Germany
    Posts
    53

    Re: "Invalid BLOB length"

    Hi,

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

    markus

  3. #3
    Join Date
    May 2003
    Location
    Aguascaliente, Mexico
    Posts
    4

    Unhappy "Invalid BLOB length"'

    if the check and already follows equal.

    Configuratión/Driver/Native/DB2

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

  4. #4
    Join Date
    Feb 2003
    Location
    Germany
    Posts
    53

    Re: "Invalid BLOB length"'

    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.

  5. #5
    Join Date
    May 2003
    Location
    Aguascaliente, Mexico
    Posts
    4

    Unhappy Re: "Invalid BLOB length"'

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •