Re: Error in communication with MSAccess

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Mihai Gheorghiu <tanethq(at)earthlink(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Error in communication with MSAccess
Date: 2001-08-07 23:55:35
Message-ID: 20010808095535.A4548@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 07, 2001 at 06:06:29PM -0400, Mihai Gheorghiu wrote:
> I attach the relevant part of the log. I guess the relevant line is
> "errmsg='Out of memory while reading tuples.'
> What can I do? I need to run MSAccess queries that return large amounts of
> data and open large tables.

I fixed a problem like that a while ago by ticking a box that told the
driver to use cursors and fetch to get the tuples rather than select *. Made
the results come somewhat faste. Mind you, this was a pretty old version of
the ODBC driver.

HTH,

--
Martijn van Oosterhout <kleptog(at)svana(dot)org>
http://svana.org/kleptog/
> It would be nice if someone came up with a certification system that
> actually separated those who can barely regurgitate what they crammed over
> the last few weeks from those who command secret ninja networking powers.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dr. Evil 2001-08-08 00:34:44 Re: Still wondering about random numbers...
Previous Message Paul Grenda 2001-08-07 23:20:11 Ugrading to 7.1 from 7.1