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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
