Recently our postgresql servers were upgraded to 9.
Also, our odbc drivers were upgraded to PostgreSQL ANSI 8.02.04.00
Previously we used odbc PostgreSQL 7.03.02.00
I am using MS Access 2003 as a front-end to postgresql and it has worked wonderfully well.
With the old drivers, what would happen is, when Access opened it requested data from various tables simply because they are the datasources for forms etc, and the odbc driver responded with the login form. Beautifully simple.
Now however, when Access requests the data as the form opens, the driver responds with "ODBC--connection to blah blah failed."
Hence my question: if requesting the data no longer results in the login form, how do I get the login form to open so a user can sign in?
Thanks for any help.
Association of Bay Area Governments
pgsql-odbc by date
|Next:||From: Della-Croce, Gregory||Date: 2012-06-09 20:10:16|
|Subject: connecting a 64bit ODBC driver for Postgre 8.4 with Access 2010|
|Previous:||From: Adrien W. de Croy||Date: 2012-06-06 00:05:07|
|Subject: Re: Why would Postgres not show in my data connections (Win 7)|