Thread: Invalid BLOB Length

I am using Borland C++ Builder 3.0 with PostgreSQL 6.4.2 and the
latest ODBC driver from ftp.postgresql.org.

I created a table users that looks like this:

CREATE TYPE lo (
    internallength = 4,
    externallenght = 10,
    input = int4in,
    output = int4out,
    send = int4out,
    receive = int4in,
    default = '',
    passedbyvalue);

CREATE TABLE users (
    userid int4,
    username varchar(255),
    userimage lo);

When I try and insert an image, the app returns "Invalid BLOB Length".

What am I doing Wrong?

Thanks

        Travis

PostgreSQL Server wrote:

> I am using Borland C++ Builder 3.0 with PostgreSQL 6.4.2 and the
> latest ODBC driver from ftp.postgresql.org.
>
> I created a table users that looks like this:
>
> CREATE TYPE lo (
>         internallength = 4,
>         externallenght = 10,
>         input = int4in,
>         output = int4out,
>         send = int4out,
>         receive = int4in,
>         default = '',
>         passedbyvalue);
>
> CREATE TABLE users (
>         userid int4,
>         username varchar(255),
>         userimage lo);
>
> When I try and insert an image, the app returns "Invalid BLOB Length".
>
> What am I doing Wrong?
>
> Thanks
>
>                 Travis


Are there any errors in the driver's commlog ("psqlodbc.log") file?  You
can also check the odbc trace log.  If you can't figure anything out, you
can try sending me the logs and I could take a look.

Byron