ODBC from MS Access
am 15.07.2010 20:34:27 von Joseph DoenchThis 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
charset=3Dus-ascii">
08.00.0681.000">
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:
FACE=3D"Calibri">host FACE=3D"Calibri"> LANG=3D"en-us"> all LANG=3D"en-us"> FACE=3D"Calibri"> LANG=3D"en-us"> all LANG=3D"en-us"> FACE=3D"Calibri"> LANG=3D"en-us"> my LANG=3D"en-us">I LANG=3D"en-us">Paddress LANG=3D"en-us"> FACE=3D"Calibri"> LANG=3D"en-us"> trust
FACE=3D"Calibri">… FACE=3D"Calibri">using FACE=3D"Calibri">‘ FACE=3D"Calibri">postgres FACE=3D"Calibri">’ FACE=3D"Calibri"> or FACE=3D"Calibri">‘ FACE=3D"Calibri">projop FACE=3D"Calibri">’ FACE=3D"Calibri"> for the database name. LANG=3D"en-us">
FACE=3D"Calibri">… FACE=3D"Calibri">using FACE=3D"Calibri">‘ FACE=3D"Calibri">postgres FACE=3D"Calibri">’ FACE=3D"Calibri"> as the username; no password LANG=3D"en-us">
Getting an =
error message:
LANG=3D"en-us"> =
'No connection could be =
made because the target machine actively refused it.
LANG=3D"en-us">
LANG=3D"en-us">
FACE=3D"Arial">’
LANG=3D"en-us">
LANG=3D"en">
FACE=3D"Arial">Looking for clues in pgAdmin III -- =
would be glad to get a little help from
LANG=3D"en-us">
LANG=3D"en-us">
SIZE=3D2 FACE=3D"Arial">you
LANG=3D"en-us">
LANG=3D"en-us">
FACE=3D"Arial">…
FACE=3D"Calibri">Regards,
FACE=3D"Calibri">JPD
------=_NextPart_000_002A_01CB242A.D4A9B830--