Re: [INTERFACES] ODBC DRIVER v06-40-0002 - Mailing list pgsql-interfaces

From Byron Nikolaidis
Subject Re: [INTERFACES] ODBC DRIVER v06-40-0002
Date
Msg-id 3690F0B6.39DFC3BE@insightdist.com
Whole thread Raw
In response to RE: [INTERFACES] ODBC DRIVER v06-40-0002  (Dave Page <dpage@vale-housing.co.uk>)
List pgsql-interfaces

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



pgsql-interfaces by date:

Previous
From: Byron Nikolaidis
Date:
Subject: Re: [INTERFACES] ODBC CREATE TABLE failures
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [INTERFACES] How to implement referential facilities in Postg reSQL