PG ODBC, Access, and connection limits

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.


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

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.klaver@gmail.com

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc