Skip site navigation (1) Skip section navigation (2)

Re: odbc-4 crashing with 300000 record tables..

From: "Johann Zuschlag" <zuschlag2(at)online(dot)de>
To: "mazzo" <jambo(at)aruba(dot)it>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: odbc-4 crashing with 300000 record tables..
Date: 2001-06-05 16:32:39
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
--Original Message Text---
From: mazzo
Date: Sun, 3 Jun 2001 14:28:00 +0200

>Hi all..i've downloaded the pgsql odbc 0004 driver from the ftp site and i'm using it to access a pgsql database that i have
>exported from access of my tables has about 300000 records and when i try to open it from access 2000 as a linked
>table, ms access freezes giving me an error concerning low memory...
>The question i have is: am i using the correct odbc driver or should i download something else..(i noticed there is another
driver >>0005 in the "full" directory...)

Maybe you should switch on cursor control (Use Declare/Fetch) in the driver.
Otherwise the system will try to cache the whole table.
And of course it is better to use the latest driver (0005).

Hope that helps,


Johann Zuschlag

In response to

pgsql-odbc by date

Next:From: Cedar CoxDate: 2001-06-06 05:13:26
Subject: Re: postgreSQL ODBC
Previous:From: Dave PageDate: 2001-06-05 15:28:38
Subject: EXPLAIN via ODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group