pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC DRIVER v06-40-0002
12+ messages / 3 participants
[nested] [flat]
* ODBC DRIVER v06-40-0002
@ 1998-12-29 01:20 Byron Nikolaidis <byronn@insightdist.com>
1998-12-29 02:30 ` Re: ODBC DRIVER v06-40-0002 Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1998-12-29 02:54 ` Re: ODBC DRIVER v06-40-0002 Thomas G. Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 2 replies; 12+ messages in thread
From: Byron Nikolaidis @ 1998-12-29 01:20 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: Sergio Kessler <ser@perio.unlp.edu.ar>; pgsql-announce@postgreSQL.org <pgsql-announce@postgreSQL.org>; Thomas G. Lockhart <lockhart@alumni.caltech.edu>; John Anderson <panic@global.co.za>
Hello all,
Here is a MAJOR update to the odbc driver. Lots of missing
functionality has been added (see below). There is more to go, but
hopefully this fills in what was lacking, especially in the area of
retrieving data with SQLExtendedFetch and SQLGetData. I performed
extensive testing (I actually used "odbc test" for the first time).
But, even with all that testing, there might be some bugs, so please let
me know if you find any.
The source code will be in the archive soon, hopefully by tomorrow.
What's currently on our website is just the core odbc code for now. I
believe I have re-merged Thomas' changes for the Unix version correctly,
so everything should compile ok when it gets there.
Byron
Attachments:
v06-40-0002.txt (text/plain, 2.9K) download
version.txt date: 12/28/98 version: 06.40.0002
----------------------------------------------------------------------
This file describes changes and or fixes since the last update.
NEW FEATURES:
1. Truncation is now properly implemented when using SQLGetData and
SQLFetch/ExFetch on character and binary data. SQLGetData can be
called multiple times and it will return the correct amount of
data left. When all of a column's data has been retrieved, it
will return SQL_NO_DATA_FOUND, until the row is repositioned, which
is what the spec. dictates.
2. SQLSetPos (for position/refresh only) is now supported, for both
Declare/Fetch and regular cursor styles.
3. Full support for column-wise (SQL_BIND_BY_COLUMN) and row-wise
binding through the statement option SQL_BIND_TYPE.
4. Rowsets greater than 1 are now supported (both Declare/Fetch and
regular cursor styles) through SQLExtendedFetch.
5. SQLGetData fully supports rowsets greater than 1 in conjunction with
SQLExtendedFetch, in both Declare/Fetch and regular cursors.
6. All SQLExtendedFetch directions are now supported for regular
(Non-Declare/Fetch) cursor style, including SQL_FETCH_RELATIVE.
For declare/fetch, SQL_FETCH_NEXT is now supported, with all
directions coming soon!
7. All statement options are at least recognized.
8. All connection options are at least recognized.
9. Statement options can be set through a connection using
SQLSetConnectOption(). These affect all statements on that connection
and become the default for any future statements created on that
connection.
10. In-Line Large objects are supported. Previously, large objects could
only be created through data-at-execution parameters. This would have
prevented applications not using data-at-exec parameters for
LongVarBinarybinary data from creating any large object (possibly Borland).
11. Type Mapping now spans all ODBC-SQL types.
12. Binary/VarBinary now properly implemented through bytea. As soon as
Dave adds the patch for creating bytea with a precision, it will
hopefully be right on with the spec.
13. Added an experimental driver option (for win32 only) to cause
SQLCancel to actually call SQLFreeStmt(SQL_CLOSE) in the odbc Driver
Manager. This was necessary because some applications call SQLCancel
and expect it to act like a SQLFreeStmt(CLOSE), which it should, but
under Windows, the 3.0 driver manager does not recognize it and this
results in "Invalid Cursor State" errors on some applications.
BUG_FIXES:
1. SQLRowCount returns -1 for unknown, instead of 0.
2. Handles 'Z' in send_function.
3. SQLGetTypeInfo only returns standard SQL types now (no more char2, char4
stuff). Each SQL type is now mapped to something.
4. bpchar's name is now "char", which was mandated by #3.
5. Put back in Thomas' changes for mylog() and qlog() with variable
arguments and other things that got lost.
* Re: ODBC DRIVER v06-40-0002
1998-12-29 01:20 ODBC DRIVER v06-40-0002 Byron Nikolaidis <byronn@insightdist.com>
@ 1998-12-29 02:30 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1 sibling, 0 replies; 12+ messages in thread
From: Thomas G. Lockhart @ 1998-12-29 02:30 UTC (permalink / raw)
To: Byron Nikolaidis <byronn@insightdist.com>; +Cc: pgsql-interfaces; Sergio Kessler <ser@perio.unlp.edu.ar>; pgsql-announce@postgreSQL.org <pgsql-announce@postgreSQL.org>; John Anderson <panic@global.co.za>
> The source code will be in the archive soon, hopefully by tomorrow.
> What's currently on our website is just the core odbc code for now. I
> believe I have re-merged Thomas' changes for the Unix version
> correctly, so everything should compile ok when it gets there.
Thanks Byron! The new features look neat. Will test the Unix build asap.
- Tom
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: ODBC DRIVER v06-40-0002
1998-12-29 01:20 ODBC DRIVER v06-40-0002 Byron Nikolaidis <byronn@insightdist.com>
@ 1998-12-29 02:54 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1998-12-29 14:57 ` Re: [INTERFACES] Re: ODBC DRIVER v06-40-0002 Byron Nikolaidis <byronn@insightdist.com>
1 sibling, 1 reply; 12+ messages in thread
From: Thomas G. Lockhart @ 1998-12-29 02:54 UTC (permalink / raw)
To: Byron Nikolaidis <byronn@insightdist.com>; +Cc: pgsql-interfaces; Sergio Kessler <ser@perio.unlp.edu.ar>; pgsql-announce@postgreSQL.org <pgsql-announce@postgreSQL.org>; John Anderson <panic@global.co.za>
I'm not certain if the code tree is supposed to compile without
tomorrow's updates, but just in case it should, here's the result of
compiling on my linux/libc5 box:
execute.c: In function `SQLCancel':
execute.c:375: `HMODULE' undeclared (first use in this function)
execute.c:375: (Each undeclared identifier is reported only once
execute.c:375: for each function it appears in.)
execute.c:375: parse error before `hmodule'
execute.c:376: `FARPROC' undeclared (first use in this function)
execute.c: In function `SQLNativeSql':
There are a few routines without prototypes:
options.c:44: warning: no previous prototype for `set_statement_option'
qresult.c:81: warning: no previous prototype for `QR_Constructor'
results.c:745: warning: no previous prototype for `SC_fetch'
There are a few mentions of "unused variables" which I think is a result
of disabling qlog/mylog in my compilation; I can give you some patches
for those later if you would like (I'm pretty sure that the previous
version I had released for v6.4 had the same feature).
- Tom
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: [INTERFACES] Re: ODBC DRIVER v06-40-0002
1998-12-29 01:20 ODBC DRIVER v06-40-0002 Byron Nikolaidis <byronn@insightdist.com>
1998-12-29 02:54 ` Re: ODBC DRIVER v06-40-0002 Thomas G. Lockhart <lockhart@alumni.caltech.edu>
@ 1998-12-29 14:57 ` Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 0 replies; 12+ messages in thread
From: Byron Nikolaidis @ 1998-12-29 14:57 UTC (permalink / raw)
To: Thomas G. Lockhart <lockhart@alumni.caltech.edu>; +Cc: pgsql-interfaces; Sergio Kessler <ser@perio.unlp.edu.ar>; pgsql-announce@postgreSQL.org <pgsql-announce@postgreSQL.org>; John Anderson <panic@global.co.za>
Thomas G. Lockhart wrote:
> I'm not certain if the code tree is supposed to compile without
> tomorrow's updates, but just in case it should, here's the result of
> compiling on my linux/libc5 box:
>
> execute.c: In function `SQLCancel':
> execute.c:375: `HMODULE' undeclared (first use in this function)
> execute.c:375: (Each undeclared identifier is reported only once
> execute.c:375: for each function it appears in.)
> execute.c:375: parse error before `hmodule'
> execute.c:376: `FARPROC' undeclared (first use in this function)
> execute.c: In function `SQLNativeSql':
>
Oops...Fixed.
> There are a few routines without prototypes:
>
> options.c:44: warning: no previous prototype for `set_statement_option'
> qresult.c:81: warning: no previous prototype for `QR_Constructor'
> results.c:745: warning: no previous prototype for `SC_fetch'
Fixed.
> There are a few mentions of "unused variables" which I think is a result
> of disabling qlog/mylog in my compilation; I can give you some patches
> for those later if you would like (I'm pretty sure that the previous
> version I had released for v6.4 had the same feature).
>
>
I uncommented the MYLOG define for now. If you do have some patches, that
would be great.
Byron
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: [ANNOUNCE] ODBC DRIVER v06-40-0002
@ 1998-12-29 15:28 Byron Nikolaidis <byronn@insightdist.com>
1998-12-29 15:58 ` Re: [ANNOUNCE] ODBC DRIVER v06-40-0002 Thomas G. Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 1 reply; 12+ messages in thread
From: Byron Nikolaidis @ 1998-12-29 15:28 UTC (permalink / raw)
To: Dwight Johnson <dwj@linuxtoday.com>; +Cc: pgsql-interfaces; Thomas G. Lockhart <lockhart@alumni.caltech.edu>; pgsql-announce@postgreSQL.org <pgsql-announce@postgreSQL.org>
Dwight Johnson wrote:
> On Mon, 28 Dec 1998, Byron Nikolaidis wrote:
>
> > Hello all,
> >
> > Here is a MAJOR update to the odbc driver. Lots of missing
>
> Hi Byron,
>
> Since the release is so major, I thought I might mention it on Linux
> Today. Most of our readers are still on Windows platforms at work and
> something that greatly increases the interoperability of PostgreSQL
> might be of interest.
>
> But you didn't mention in your announcement where the driver is
> available or if there is a reference web site for the work.
>
> I am holding the story pending more information.
>
Sorry... the Windows binary and core-source release is available at
http://www.insightdist.com/psqlodbc. The full archived source and all
Unix support files are available through the Postgres site somehow
(http://www.postgresql.org). To tell you the truth, once you get to the
Postgres site, I'm not sure where you go to download the odbc source?
Perhaps someone who knows more about that could chime in here???
Byron
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: [ANNOUNCE] ODBC DRIVER v06-40-0002
1998-12-29 15:28 Re: [ANNOUNCE] ODBC DRIVER v06-40-0002 Byron Nikolaidis <byronn@insightdist.com>
@ 1998-12-29 15:58 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1998-12-29 16:05 ` Re: [ANNOUNCE] ODBC DRIVER v06-40-0002 Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 1 reply; 12+ messages in thread
From: Thomas G. Lockhart @ 1998-12-29 15:58 UTC (permalink / raw)
To: Byron Nikolaidis <byronn@insightdist.com>; +Cc: Dwight Johnson <dwj@linuxtoday.com>; pgsql-interfaces; pgsql-announce@postgreSQL.org <pgsql-announce@postgreSQL.org>; webmaster@postgreSQL.org, "Cary O'Brien" <cobrien@access.digex.net>
> Sorry... the Windows binary and core-source release is available at
> http://www.insightdist.com/psqlodbc. The full archived source and all
> Unix support files are available through the Postgres site somehow
> (http://www.postgresql.org).
The Unix-buildable sources for the previous version are available as a
part of the current Postgres release (v6.4).
The new version of psqlODBC is available in the current Postgres
development tree, and will be posted as a "standalone" package on the
ftp site after a short testing period. It can be built standalone or can
be unpacked over an existing Postgres v6.4 source tree for updating.
I will post a message to y'all when that happens; perhaps Byron can put
a link to it on his web site and Hal can put a pointer to it on the
Postgres web site?
- Tom
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: [ANNOUNCE] ODBC DRIVER v06-40-0002
1998-12-29 15:28 Re: [ANNOUNCE] ODBC DRIVER v06-40-0002 Byron Nikolaidis <byronn@insightdist.com>
1998-12-29 15:58 ` Re: [ANNOUNCE] ODBC DRIVER v06-40-0002 Thomas G. Lockhart <lockhart@alumni.caltech.edu>
@ 1998-12-29 16:05 ` Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 0 replies; 12+ messages in thread
From: Byron Nikolaidis @ 1998-12-29 16:05 UTC (permalink / raw)
To: Thomas G. Lockhart <lockhart@alumni.caltech.edu>; +Cc: Dwight Johnson <dwj@linuxtoday.com>; pgsql-interfaces; pgsql-announce@postgreSQL.org <pgsql-announce@postgresql.org>; webmaster@postgresql.org, "Cary O'Brien" <cobrien@access.digex.net>
Thomas G. Lockhart wrote:
> The Unix-buildable sources for the previous version are available as a
> part of the current Postgres release (v6.4).
>
> The new version of psqlODBC is available in the current Postgres
> development tree, and will be posted as a "standalone" package on the
> ftp site after a short testing period. It can be built standalone or can
> be unpacked over an existing Postgres v6.4 source tree for updating.
>
> I will post a message to y'all when that happens; perhaps Byron can put
> a link to it on his web site and Hal can put a pointer to it on the
> Postgres web site?
>
You bet...just give me a url.
Byron
^ permalink raw reply [nested|flat] 12+ messages in thread
* RE: [INTERFACES] ODBC DRIVER v06-40-0002
@ 1998-12-30 09:03 Dave Page <dpage@vale-housing.co.uk>
1998-12-30 14:00 ` Re: [INTERFACES] ODBC DRIVER v06-40-0002 Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 1 reply; 12+ messages in thread
From: Dave Page @ 1998-12-30 09:03 UTC (permalink / raw)
To: 'Byron Nikolaidis' <byronn@insightdist.com>; +Cc: pgsql-interfaces
Hi Byron,
> Hello all,
>
> Here is a MAJOR update to the odbc driver. Lots of missing
> functionality has been added (see below). There is more to go, but
> hopefully this fills in what was lacking, especially in the area of
> retrieving data with SQLExtendedFetch and SQLGetData. I performed
> extensive testing (I actually used "odbc test" for the first time).
> But, even with all that testing, there might be some bugs, so
> please let me know if you find any.
Unfortunately I'm still not able to update data using ADO in VB6.0 - I just
get an 'Insufficient Base Table Information' error. I've attached a logfile
of a session where a select was performed, followed by an attempted update
of the last record in the recordset.
Regards,
Dave.
--
Dave Page, Network & Systems Manager, The Vale Housing Association Ltd.
dpage@vale-housing.co.uk
http://www.vale-housing.co.uk (Work)
http://www.vale-it.demon.co.uk/ (Home of pgAdmin)
Beer can be a permanent solution - but only if you have enough of it!
Attachments:
psqlodbc_4294789231.log (application/octet-stream, 6.5K) download
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: [INTERFACES] ODBC DRIVER v06-40-0002
1998-12-30 09:03 RE: [INTERFACES] ODBC DRIVER v06-40-0002 Dave Page <dpage@vale-housing.co.uk>
@ 1998-12-30 14:00 ` Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 0 replies; 12+ messages in thread
From: Byron Nikolaidis @ 1998-12-30 14:00 UTC (permalink / raw)
To: Dave Page <dpage@vale-housing.co.uk>; +Cc: pgsql-interfaces
Dave Page wrote:
> Unfortunately I'm still not able to update data using ADO in VB6.0 - I just
> get an 'Insufficient Base Table Information' error. I've attached a logfile
> of a session where a select was performed, followed by an attempted update
> of the last record in the recordset.
>
>
The driver logfile is not very useful in cases like this. I need the odbc trace log to see what
actual odbc functions are being called.
Byron
^ permalink raw reply [nested|flat] 12+ messages in thread
* RE: [INTERFACES] ODBC DRIVER v06-40-0002
@ 1998-12-31 14:58 Dave Page <dpage@vale-housing.co.uk>
1999-01-04 16:47 ` Re: [INTERFACES] ODBC DRIVER v06-40-0002 Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 1 reply; 12+ messages in thread
From: Dave Page @ 1998-12-31 14:58 UTC (permalink / raw)
To: 'Byron Nikolaidis' <byronn@insightdist.com>; +Cc: pgsql-interfaces
Hi Byron,
Here's the ODBC trace log you required. It was created using your update to
the 6.4.0002 driver.
Regards,
Dave.
> -----Original Message-----
> From: owner-pgsql-interfaces@postgreSQL.org
> [mailto:owner-pgsql-interfaces@postgreSQL.org]On Behalf Of Byron
> Nikolaidis
> Sent: 31 December 1998 00:20
> To: Dave Page
> Cc: 'pgsql-interfaces@postgreSQL.org'; Thomas G. Lockhart; Dwight
> Johnson; pgsql-announce@postgreSQL.org
> Subject: [INTERFACES] MINI-UPDATE of ODBC DRIVER v06-40-0002
<SNIP>
> Dave, I'm sure this was *at least one* thing wrong with your ADO/VB6.0
> application, because the error messages in the commlog file showed
> that. However, like I said, without the odbc trace log, I
> can't be sure
> there is not more wrong (likely).
>
> Byron
>
>
>
>
Attachments:
ADO-SQL.log (application/octet-stream, 108.1K) download
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: [INTERFACES] ODBC DRIVER v06-40-0002
1998-12-31 14:58 RE: [INTERFACES] ODBC DRIVER v06-40-0002 Dave Page <dpage@vale-housing.co.uk>
@ 1999-01-04 16:47 ` Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 0 replies; 12+ messages in thread
From: Byron Nikolaidis @ 1999-01-04 16:47 UTC (permalink / raw)
To: Dave Page <dpage@vale-housing.co.uk>; +Cc: 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
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: ODBC DRIVER v06-40-0002
@ 1999-01-05 14:36 Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 0 replies; 12+ messages in thread
From: Byron Nikolaidis @ 1999-01-05 14:36 UTC (permalink / raw)
To: Constantin Teodorescu <teo@flex.ro>; +Cc: pgsql-interfaces
Constantin Teodorescu wrote:
> Byron Nikolaidis wrote:
> >
> > This is the FINAL mini-update of the odbc driver version 06-40-0002, and
> > is available at http://www.insightdist.com/psqlodbc.
>
> Would it be possible to make the postdrv.exe available through a ftp
> site ?
>
In fact, it already is available through ftp!
Just ftp to www.postgresql.org and log in as anonymous with your email address
as the password. The files you want are in "/pub/odbc/latest". If you would
prefer a url, it is ftp://ftp.postgresql.org/pub/odbc/latest/postdrv.exe.
You can also get here through the postgresql web page if you click on
"download".
I'm not sure if you realize it, but there is also a file there called
"postdll.zip", which is only a fraction of the size of postdrv.exe. It is
just the driver (psqlodbc.dll), so it requires that you have previously
installed postdrv.exe at least once. So all you have to do is copy the
psqlodbc.dll file into your \windows\system directory.
Byron
^ permalink raw reply [nested|flat] 12+ messages in thread
end of thread, other threads:[~1999-01-05 14:36 UTC | newest]
Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-12-29 01:20 ODBC DRIVER v06-40-0002 Byron Nikolaidis <byronn@insightdist.com>
1998-12-29 02:30 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1998-12-29 02:54 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1998-12-29 14:57 ` Byron Nikolaidis <byronn@insightdist.com>
1998-12-29 15:28 Re: [ANNOUNCE] ODBC DRIVER v06-40-0002 Byron Nikolaidis <byronn@insightdist.com>
1998-12-29 15:58 ` Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1998-12-29 16:05 ` Byron Nikolaidis <byronn@insightdist.com>
1998-12-30 09:03 RE: [INTERFACES] ODBC DRIVER v06-40-0002 Dave Page <dpage@vale-housing.co.uk>
1998-12-30 14:00 ` Byron Nikolaidis <byronn@insightdist.com>
1998-12-31 14:58 RE: [INTERFACES] ODBC DRIVER v06-40-0002 Dave Page <dpage@vale-housing.co.uk>
1999-01-04 16:47 ` Byron Nikolaidis <byronn@insightdist.com>
1999-01-05 14:36 Re: ODBC DRIVER v06-40-0002 Byron Nikolaidis <byronn@insightdist.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox