From: | Byron Nikolaidis <byronn(at)insightdist(dot)com> |
---|---|
To: | PostgreSQL Interfaces <pgsql-interfaces(at)postgreSQL(dot)org> |
Cc: | Oliver Stegle <ostegle(at)fr(dot)infra(dot)net>, Nick Urbanik <nicku(at)iohk(dot)com>, Sbragion Denis <infotecn(at)tin(dot)it>, "bcurnow(at)sonnet(dot)com" <bcurnow(at)sonnet(dot)com>, "Krasnow, Greg" <gak(at)hnc(dot)com>, Mike Edwards <medwards(at)ega(dot)com> |
Subject: | NEW ODBC DRIVER v.0243 |
Date: | 1998-05-28 21:16:02 |
Message-ID: | 356DD412.89AD108B@insightdist.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Hello,
There is a new odbc driver v.0243 at our website
http://www.insightdist.com/psqlodbc
This version works with the odbc cursor library, thus adding positioned
updates, static and block cursors, extended fetches, etc. to the
functionality of the driver. This is good for MFC, Visual Basic, and
other frameworks that have the concept of an updateable recordset.
I have tested extended scrolling, updates, deletes, and appends with
VC5.0 using their CRecordset in a snapshot mode (dynasets are not
supported). It works well. It transforms the positioned SQL statements
(which the backend does not support) coming from MFC into "searched
update" statements, which the backend accepts. The default for the
CRecordset is to load the odbc cursor library, unless you tell it not to
when constructing a CDatabase object.
The "Use Declare/Fetch" option does not matter as much anymore, since
the cursor library gets in the middle of the driver manager and driver,
and supports the additional functionality, such as an updateable, static
cursor.
It does matter somewhat, in terms of efficiency, though, since the odbc
cursor library caches the data in its own memory and disk files. If you
have the Use Declare/fetch option checked, it will be more efficient on
large result sets, since the driver will only cache 100 rows, while the
cursor library caches everything. If you dont check the option, the
driver will also cache the entire result set.
For more information about the odbc cursor library, there is an appendix
about it in the odbc programmer's reference guide and in the online help
with VC.
As always, feedback is appreciated. I.E., if it works for you, that
would be good feedback to send, as well as any problems of course.
Byron
Attachment | Content-Type | Size |
---|---|---|
v06-30-0243.txt | text/plain | 1.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew T. O'Connor | 1998-05-29 00:41:40 | WWW Access |
Previous Message | Byron Nikolaidis | 1998-05-28 20:20:45 | Re: [INTERFACES] Re: Your ODBC driver = PostODBC? |