Thread: Out of memory error

Repost with zipped attachment.  First post never showed up?

> I'm receiving an out of memory error when trying to execute a
> long, complex query involving many temp tables.  I'm using
> psqlODBC ver 8.02.0500 and PG 8.2.4 on WinXP.  I'm trying to
> execute this query via a pass-through query in MS Access
> 2003.  If I execute this query in PGAdmin III it runs without
> any errors and returns no records.
>
> My connection string in Access is:
> ODBC; DRIVER={PostgreSQL Unicode}; SERVER=myServer;
> DATABASE=iqdb; PORT=5432; UID=myUserName; PWD=xxxxxxx; B9=0;
> B7=1; B3=1; C8=1
>
> I've attached the log file which contains the SQL I'm trying
> to execute and the error details.  I've tried setting
> UseDeclareFetch = 1 but it didn't resolve the error.  Any
> suggestions?

> I'm receiving an out of memory error when trying to execute a long,
> complex query involving many temp tables.  I'm using psqlODBC ver
> 8.02.0500 and PG 8.2.4 on WinXP.  I'm trying to execute
> this query via
> a pass-through query in MS Access 2003.  If I execute this query in
> PGAdmin III it runs without any errors and returns no records.
>
> My connection string in Access is:
> ODBC; DRIVER={PostgreSQL Unicode}; SERVER=myServer; DATABASE=iqdb;
> PORT=5432; UID=myUserName; PWD=xxxxxxx; B9=0; B7=1; B3=1; C8=1
>
> I've attached the log file which contains the SQL I'm trying to
> execute and the error details.  I've tried setting
> UseDeclareFetch = 1
> but it didn't resolve the error.  Any suggestions?
>

Anybody have any suggestions on this?