| From: | Benjamin Smith <lists(at)benjamindsmith(dot)com> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Connection limits and MS Access? |
| Date: | 2010-08-16 19:07:49 |
| Message-ID: | 201008161207.49957.lists@benjamindsmith.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Server PostgreSQL 8.4 / 64 bit
Client MS Access 2007
ODBC driver 8.4.200
In order to support one of our clients, we've set up ODBC access to our
database server, and the contract specifies a single ODBC database connection.
We've enabled ODBC and gotten started, but Access seems to want to open a
database connection for each linked table - hardly beneficial!
We've tried enabling connection pooling for the PG ANSI driver (the one client
is trying to use) to no avail - as soon as we try to set up a 2nd linked
table, we get an error about connection limits.
Is there a way to force Access (or the ODBC driver) to reuse one connection
rather than opening multiple connections?
-Ben
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma | 2010-08-16 20:05:10 | Re: Connection limits and MS Access? |
| Previous Message | Benjamin Smith | 2010-08-16 19:01:52 | PG ODBC, Access, and connection limits |