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

Re: MS Access error "could not connect to remote socket"

From: Richard Huxton <dev(at)archonet(dot)com>
To: "chor kim seng" <ksc133(at)singnet(dot)com(dot)sg>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: MS Access error "could not connect to remote socket"
Date: 2004-03-12 08:55:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
On Friday 12 March 2004 07:08, chor kim seng wrote:
> dear sir,
> i'm trying to set up a win2k client to connect to postgreSQL running on
> redhat 7.2. but every time i try to connect MS Access, the error pops up.
> error: "ODBC --call failed.
> could not connect to server;
> could not connect to remote socket."
> i've checked that firewall on redhat 7.2 was disable via lokkit.
> i've created root as a postgreSQL user.
> i've aslo allow host ip win2k to access postgreSQL.
> i've used the latest ODBC driver for postgreSQL
> i use root account to connect MS Access to postgreSQL.

You don't need root as a PostgreSQL user, but you've taken most of the obvious 

One thing to try is open up a command-prompt and type something like:
Where is the IP address of your PostgreSQL machine. Type a few 
characters and hit return once or twice and you should get an error message 
back from PG saying connection refused.

If you can't connect using telnet, then either:
  1. The firewall is still there
  2. PG isn't listening on socket 5432
Check your postgresql.conf file and make sure you are accepting tcp/ip 
connections. Also check your settings in pg_hba.conf

Hope that gets you started - reply back to the list if you still have 

  Richard Huxton
  Archonet Ltd

In response to

pgsql-odbc by date

Next:From: Jeff EckermannDate: 2004-03-12 14:49:35
Subject: Re: Very Puzzled ---
Previous:From: Gary DoadesDate: 2004-03-12 08:04:04
Subject: ODBC int2 Paremeters to PostgreSQL functions

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