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: | E157JjR-0005ef-00@mrelay01.kundenserver.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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 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,
regards
Johann
Johann Zuschlag
zuschlag2(at)online(dot)de
From | Date | Subject | |
---|---|---|---|
Next Message | Cedar Cox | 2001-06-06 05:13:26 | Re: postgreSQL ODBC |
Previous Message | Dave Page | 2001-06-05 15:28:38 | EXPLAIN via ODBC |