Ah! That would explain it.
Welp, this search was more helpful: "Out of memory while reading tuples"
http://stackoverflow.com/questions/22532149/vba-and-postgresql-connection
It says: include UseDeclareFetch=1 in connect string, which sounds like its
part of odbc. How does SAS connect to PG?
-Andy
Here is another reference that describes the same problem:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4498d4f2-9646-4921-b56d-79e22c14a215/import-data-from-postgresql-into-sql-server-2005
The answer (very bottom) is to set the "use declare/fetch" option in psqlODBC
driver options.
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
