Skip site navigation (1) Skip section navigation (2)

Re: PG ODBC, Access, and connection limits

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Benjamin Smith <lists(at)benjamindsmith(dot)com>
Cc: pgsql-odbc <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: PG ODBC, Access, and connection limits
Date: 2010-08-16 23:10:11
Message-ID: 4C69C553.1060008@gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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

In response to

pgsql-odbc by date

Next:From: Arnaud LesauvageDate: 2010-08-17 06:25:05
Subject: Re: Connection limits and MS Access?
Previous:From: Mike ToewsDate: 2010-08-16 20:33:33
Subject: Re: Connection limits and MS Access?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group