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 192.168.1.2 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
In response to
pgsql-odbc by date
|Next:||From: Jeff Eckermann||Date: 2004-03-12 14:49:35|
|Subject: Re: Very Puzzled ---|
|Previous:||From: Gary Doades||Date: 2004-03-12 08:04:04|
|Subject: ODBC int2 Paremeters to PostgreSQL functions|