Thread: Trouble with MS Access-to-postgresql export

Trouble with MS Access-to-postgresql export

From
Mark Hesketh
Date:
Hello,

I'm sure this is going to bore the pants off anyone unfortunate enough
to read it but, here goes.

I'm running postgresql 7.1.3 under Win2000 as part of the cygwin
install. I've configured it and it works fine...

However, I'm trying to export a schema from Access to PG.

-I've downloaded the driver and successfully installed it.
-I've set up a user (not system, does that matter?) DSN called
PostgreSQL configured for my database/user.
-I've followed the instructions in the distro doco about Configuration
Files for ODBC (section 7.3) and configured
the .odbc.ini.
- I HAVEN'T touched pg_hba.conf nor postgresql.conf
- I've followed the article:
http://softwaredev.earthweb.com/sdopen/article/0,,12077_631251,00.html
by Damond Walker.
- I'm running ipc-daemon.exe.
- I've kicked off postmaster too (and setup PGPORT=5000).

Here it is (I'm not sure about the Driver nor the InstallDir bit, they
seem dodgy):

---8<----[.odbc.ini]---

[ODBC Data Sources]
SchmickDev = Read/Write Database

[SchmickDev]
Servername = localhost
Database = schmick_dev_db
Port = 5000
Username = testUser
Driver = /windows/system32/psqlodbc.dll

[ODBC]
InstallDir = /windows/system32

---8<-------

Anyway, it don't work - I always encounter "ODBC call failed" and then
"Could not connect to server" "Could not connect to remote socket (#101)".

Can someone tell me, not too harshly, what the hell else I need to do?

Thanks
Mark



Re: Trouble with MS Access-to-postgresql export

From
"Josh Berkus"
Date:
Mark,

> Can someone tell me, not too harshly, what the hell else I need to
> do?

Beats me.  You're already ahead of me when it comes to Pgsql-on-windows
configuration.  Some resources you might try:

PGAdmin:  http://pgadmin.postgresql.org/  PGadmin II comes with a
unified MSI installer for the latest ODBC drivers, etc.  It also include
a nifty Admin interface.

pgsql-odbc
pgsql-cygwin
These two mailing lists are devoted to postgres-on-windows users.  try
posting your question to each (one at a time, please!).

Also Wrox Press' "Beginning Databases With PostgreSQL" (see
http://techdocs.postgresql.org/bookreviews.php ) contains a whole
chapter on setting up PostgreSQL and Cygwin.

-Josh


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco