--Original Message Text---
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 97...one 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,
In response to
pgsql-odbc by date
|Next:||From: Cedar Cox||Date: 2001-06-06 05:13:26|
|Subject: Re: postgreSQL ODBC|
|Previous:||From: Dave Page||Date: 2001-06-05 15:28:38|
|Subject: EXPLAIN via ODBC|