Relyea, Mike wrote:
I tried posting this to the OBC list but didn't get any responses, so
I'm trying my luck here.
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.
Hmm. So what's different about the queries?
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?
[145.188]ERROR from backend during send_query: 'SERROR'
[145.188]ERROR from backend during send_query: 'C53200'
[145.188]ERROR from backend during send_query: 'Mout of memory'
[145.188]ERROR from backend during send_query: 'DFailed on request of
size 16.'
[145.188]ERROR from backend during send_query: 'Faset.c'
[145.188]ERROR from backend during send_query: 'L712'
[145.188]ERROR from backend during send_query: 'RAllocSetAlloc'
OK, so this seems to be a server-side error, which means something
should be in the server logs. Is there anything?
Oh, and I'd probably split that query into about a dozen smaller ones -
one per statement.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
