All
I've been using (or trying to use) the pgODBC driver with 'Use
Declare/Fetch' set to true and all goes well till you try to go to the end
of a large recordset. The driver seems to load all the records instead of
just the last 50 (or whatever). I'm using Delphi 7, BDE and psqlODBC
version 7.03.01.08 to connect to Postgres 7.3.1.
Any ideas? Could this be a BDE problem? Any one else out there using this
configuration?
Regards,
Ben
>From: Mike Mascari <mascarm@mascari.com>
>To: Stephen Frost <sfrost@snowman.net>
>CC: markw@mohawksoft.com, slutz@alacritude.com,pgsql-odbc@postgresql.org
>Subject: Re: [ODBC] FUD!! ODBC will not be supported by Microsoft in the
>future
>Date: Wed, 01 Oct 2003 08:39:31 -0400
>
>Stephen Frost wrote:
>
> > * markw@mohawksoft.com (markw@mohawksoft.com) wrote:
>
> >>That is not a PostgreSQL ODBC issue. There is a setting, I forget the
> >>name, that enables a cursor in the query.
> >
> > It should be on by default then, and I didn't see that option when I was
> > looking, can you tell me where it is?
>
>Nothin' like RTFM:
>
>http://gborg.postgresql.org/project/psqlodbc/genpage.php?doc-config
>
> >>On a side not, you will be hard pressed to find a commercial ODBC
> >>application, i.e. Access, that can handle large tables.
> >
> > Uh, Access and Oracle ODBC works just fine on the same table that
> > Postgres ODBC grinds the machine to a halt on.
>
>Use Declare/Fetch
>
> >>For what its worth, I use the PGODBC driver to create an index of tables
> >>with Millions of rows.
> >
> > I tried using the postgres ODBC driver to open a table with a couple
> > million rows. It ran the client machine out of memory. Same table w/
> > the Oracle ODBC driver worked just fine.
>
>Use Declare/Fetch
>
>HTH,
>
>Mike Mascari
>mascarm@mascari.com
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
_________________________________________________________________
Express yourself with cool emoticons - download MSN Messenger today!
http://www.msn.co.uk/messenger