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

How do I request the PostgreSQL login prompt?

From: "Fred Parkinson" <FredP(at)abag(dot)ca(dot)gov>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: How do I request the PostgreSQL login prompt?
Date: 2012-06-06 19:36:20
Message-ID: 4FCF4EC4020000A70001CC87@gwia1.abag.ca.gov (view raw or flat)
Thread:
Lists: pgsql-odbc
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

Next:From: Della-Croce, GregoryDate: 2012-06-09 20:10:16
Subject: connecting a 64bit ODBC driver for Postgre 8.4 with Access 2010
Previous:From: Adrien W. de CroyDate: 2012-06-06 00:05:07
Subject: Re: Why would Postgres not show in my data connections (Win 7)

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