Received: from u1.abs.net (root@u1.abs.net [207.114.0.131])
	by hub.org (8.9.1/8.9.1) with ESMTP id MAA21301
	for <pgsql-interfaces@postgresql.org>;
	Mon, 4 Jan 1999 12:24:41 -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 MAA12991
	for pgsql-interfaces@postgresql.org;
	Mon, 4 Jan 1999 12:03:51 -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 AA34345; Mon, 4 Jan 1999 11:45:22 -0500
Received: from byronn by ceodev (AIX 4.1/UCB 5.64/4.03)
	id AA79560; Mon, 4 Jan 1999 11:40:23 -0500
Message-Id: <3690F0B6.39DFC3BE@insightdist.com>
Date: Mon, 04 Jan 1999 11:47:50 -0500
From: Byron Nikolaidis <byronn@insightdist.com>
X-Mailer: Mozilla 4.05 [en] (Win95; I)
Mime-Version: 1.0
To: Dave Page <dpage@vale-housing.co.uk>
Cc: "'pgsql-interfaces@postgresql.org'" <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] ODBC DRIVER v06-40-0002
References: <1FE7F85A898FD21189AF006097BCD3D6016152@woody.vale-housing.co.uk>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



Dave Page wrote:

> Hi Byron,
>
> Here's the ODBC trace log you required. It was created using your update to
> the 6.4.0002 driver.
>
>

Looking at the log, its not totally obvious what the heck is failing because there is not
a hard failure that I can see.  However, I do realize that the odbc driver falls short in
a few areas, and one is handling buffers and truncation properly.   I have been working in
this area, with fixes to SQLGetData and then the other day with SQLGetInfo.  These now
function correctly.  But, there are numerous other functions which are possibilities, one
of which (SQLNativeSql) is used in your application.

So for the record, the following functions have been fixed:

SQLFetch
SQLExtendedFetch
SQLGetData
SQLGetInfo

The following functions still DO NOT handle input/output buffer lengths and/or truncation
properly:

SQLNativeSql
SQLColAttributes
SQLDescribeCol
SQLDriverConnect
SQLError
SQLGetCursorName


I will fix these functions and post another update shortly.

Byron