Received: from u1.abs.net (root@u1.abs.net [207.114.0.131])
	by hub.org (8.9.2/8.9.1) with ESMTP id JAA35659
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 24 Mar 1999 09:44:29 -0500 (EST)
	(envelope-from byronn@insightdist.com)
Received: from insightdist.com (nobody@localhost)
	by u1.abs.net (8.9.0/8.9.0) with UUCP id JAA27019
	for pgsql-interfaces@postgreSQL.org;
	Wed, 24 Mar 1999 09:41:03 -0500 (EST)
X-Authentication-Warning: u1.abs.net: nobody set sender to
	insightdist.com!byronn using -f
Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03)
	id AA38512; Wed, 24 Mar 1999 09:28:17 -0500
Received: from byronn by ceodev (AIX 4.1/UCB 5.64/4.03)
	id AA34002; Wed, 24 Mar 1999 09:28:16 -0500
Message-Id: <36F8F83D.FD11A728@insightdist.com>
Date: Wed, 24 Mar 1999 09:35:41 -0500
From: Byron Nikolaidis <byronn@insightdist.com>
X-Mailer: Mozilla 4.05 [en] (Win95; I)
Mime-Version: 1.0
To: PostgreSQL Server <postgres@www.Mythos.Org>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Invalid BLOB Length
References: <199903240713.CAA11996@Mythos.Org>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



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