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

Re: Connection limits and MS Access?

From: Benjamin Smith <lists(at)benjamindsmith(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Connection limits and MS Access?
Date: 2010-08-17 22:33:55
Message-ID: 201008171533.55685.lists@benjamindsmith.com (view raw or flat)
Thread:
Lists: pgsql-odbc
On Monday, August 16, 2010 01:33:33 pm Mike Toews wrote:
 I haven't done any special modifications from the
> default settings, except enable Row Versioning and Updatable Cursors
> (Page 2 options).

And, for some reason, checking these options fixed the problem. I haven't yet 
had the time to figure out which of these two does the trick, but changing it 
thusly does it! (Have incorporated screenshots thusly in our dox as a nice 
contribution to long, tortured existence of Cargo Cult computing) 

Thanks, 

Ben 

> 
> -Mike
> 
> On 16 August 2010 12:07, Benjamin Smith <lists(at)benjamindsmith(dot)com> wrote:
> > 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.
> > 
> > 
> > --
> > Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-odbc

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


In response to

pgsql-odbc by date

Next:From: Benjamin SmithDate: 2010-08-17 22:50:03
Subject: MS Access and field-level permissions?
Previous:From: Arnaud LesauvageDate: 2010-08-17 06:25:05
Subject: Re: Connection limits and MS Access?

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