Re: Out of memory error
This is a discussion on Re: Out of memory error within the pgsql Interfaces odbc forums, part of the PostgreSQL category; --> > I'm receiving an out of memory error when trying to execute a long, > complex query involving many ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2008, 05:25 PM
| ||||
| ||||
 Re: Out of memory error > 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? ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq      |
 |
« Re: Unable to update JOIN'ed recordset with PSQLODBC 08.02.0400 andADO
|
Filtering ODBC table list »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 05:31 PM.
