Thread: ODBC from MS Access
I’m fairly new to PG. I’m working on implementing Project-Open, “PO”, for a non-profit organization; I am a volunteer.
I need to migrate legacy data from MS Access to the PO database (PG) – I’m hoping that I can use Access as the front-end for the migration procedures.
FYI, I am running Access 2007.
I’ve read some of the PG documentation…
checked and confirmed that:
posgreSQL.conf contains listen_addresses='*'.
Added a line to pg_hba.conf containing:
host all all myIPaddress trust
…using ‘postgres’ or ‘projop’ for the database name.
…using ‘postgres’ as the username; no password
Getting an error message: 'No connection could be made because the target machine actively refused it.’
Looking for clues in pgAdmin III -- would be glad to get a little help from you…
Regards,
JPD
On Thu, Jul 15, 2010 at 11:34 AM, Joseph Doench <jdoench@cinci.rr.com> wrote: > FYI, I am running Access 2007. > > I’ve read some of the PG documentation… > > checked and confirmed that: > > posgreSQL.conf contains listen_addresses='*'. > > Added a line to pg_hba.conf containing: > > host all all myIPaddress trust > > …using ‘postgres’ or ‘projop’ for the database name. > > …using ‘postgres’ as the username; no password > > Getting an error message: 'No connection could be made because the target > machine actively refused it.’ Are you able to log in locally using psql with these credentials? -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug
On Thu, Jul 15, 2010 at 11:49:39AM -0700, Richard Broersma wrote: > On Thu, Jul 15, 2010 at 11:34 AM, Joseph Doench <jdoench@cinci.rr.com> wrote: > > > > FYI, I am running Access 2007. > > > > I’ve read some of the PG documentation… > > > > checked and confirmed that: > > > > posgreSQL.conf contains listen_addresses='*'. > > > > Added a line to pg_hba.conf containing: > > > > host all all myIPaddress trust > > > > …using ‘postgres’ or ‘projop’ for the database name. > > > > …using ‘postgres’ as the username; no password > > > > Getting an error message: 'No connection could be made because the target > > machine actively refused it.’ > > > Are you able to log in locally using psql with these credentials? And did you restart the postmaster after adding the lines to pg_hba.conf? Also, realize that the first line in pg_hba.conf that matches your access attempt is the one that matters: if you tacked that on at the end, there's likely an earlier line that's rejecting you. Ross -- Ross Reedstrom, Ph.D. reedstrm@rice.edu Systems Engineer & Admin, Research Scientist phone: 713-348-6166 The Connexions Project http://cnx.org fax: 713-348-3665 Rice University MS-375, Houston, TX 77005 GPG Key fingerprint = F023 82C8 9B0E 2CC6 0D8E F888 D3AE 810E 88F0 BEDE