Thread: 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.
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