ODBC from MS Access

This is a multi-part message in MIME format.

------=_NextPart_000_002A_01CB242A.D4A9B830
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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

------=_NextPart_000_002A_01CB242A.D4A9B830
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
08.00.0681.000">
<TITLE>ODBC from MS Access</TITLE>
</HEAD>
<BODY>


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=3D'*'.

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



</BODY>
</HTML>
------=_NextPart_000_002A_01CB242A.D4A9B830--

Joseph Doench [ Do, 15 Juli 2010 20:34 ] [ ID #2044521 ]

Re: ODBC from MS Access

On Thu, Jul 15, 2010 at 11:34 AM, Joseph Doench <jdoench [at] cinci.rr.com> wrot=
e:

> FYI, I am running Access 2007.
>
> I=92ve read some of the PG documentation=85
>
> checked and confirmed that:
>
> posgreSQL.conf contains listen_addresses=3D'*'.
>
> Added a line to pg_hba.conf containing:
>
> host =A0=A0=A0=A0 all =A0=A0=A0=A0 all =A0=A0=A0=A0=A0 myIPaddress =A0=A0=
=A0=A0=A0=A0 trust
>
> =85using =91postgres=92=A0 or =91projop=92=A0 for the database name.
>
> =85using =91postgres=92 as the username;=A0 no password
>
> Getting an error message: 'No connection could be made because the target
> machine actively refused it.=92

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

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Richard Broersma [ Do, 15 Juli 2010 20:49 ] [ ID #2044522 ]

Re: ODBC from MS Access

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 [at] cinci.rr.com> =
wrote:
>
>
> > FYI, I am running Access 2007.
> >
> > I=E2=80=99ve read some of the PG documentation=E2=80=A6
> >
> > checked and confirmed that:
> >
> > posgreSQL.conf contains listen_addresses=3D'*'.
> >
> > Added a line to pg_hba.conf containing:
> >
> > host =C2=A0=C2=A0=C2=A0=C2=A0 all =C2=A0=C2=A0=C2=A0=C2=A0 all =C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0 myIPaddress =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
trust
> >
> > =E2=80=A6using =E2=80=98postgres=E2=80=99=C2=A0 or =E2=80=98projop=E2=
=80=99=C2=A0 for the database name.
> >
> > =E2=80=A6using =E2=80=98postgres=E2=80=99 as the username;=C2=A0 no p=
assword
> >
> > Getting an error message: 'No connection could be made because the ta=
rget
> > machine actively refused it.=E2=80=99
>
>
> 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 [at] 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 =3D F023 82C8 9B0E 2CC6 0D8E F888 D3AE 810E 88F0 BED=
E

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

reedstrm [ Do, 15 Juli 2010 23:14 ] [ ID #2044523 ]