Postgres Pro
Downloads
Home   >   mailing lists

How do I request the PostgreSQL login prompt? - Mailing list pgsql-odbc

From Fred Parkinson
Subject How do I request the PostgreSQL login prompt?
Date
Msg-id 4FCF4EC4020000A70001CC87@gwia1.abag.ca.gov
Whole thread Raw
List pgsql-odbc
Tree view
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.
 
 
Fred Parkinson
Application Programmer
Association of Bay Area Governments
510-464-7931

pgsql-odbc by date:

Previous
From: "Adrien W. de Croy"
Date:
Subject: Re: Why would Postgres not show in my data connections (Win 7)
Next
From: "Della-Croce, Gregory"
Date:
Subject: connecting a 64bit ODBC driver for Postgre 8.4 with Access 2010