Re: PG ODBC, Access, and connection limits

On 08/16/2010 12:01 PM, Benjamin Smith wrote:
> 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
>

Are the linked tables in one Postgres database or multiple? In other
words do you have a different ODBC connection for each?

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com