>
> 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