Trying to support MS Access 2007 to our Postgres 8.4 databases with ODBC, and
running into connection limit problems.
It seems that Access opens a database connection for each linked table. Worse,
it maintains the connection even after the table is closed! I've tried going
in to enable connection pooling for the driver in the ODBC tab, and everything
else I could find a la google.
I'm going to bump up the limit from 1 to 10 for you in the meantime so that
you can be productive sooner rather than later and see if my pleas to the PG
support list are fruitful.
-Ben
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.