MS Access error "could not connect to remote socket"

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.

 

win2k can ping and see redhat on the network browser.

win2k can also access the shared samba files.

 

i've tried to connect to MySQL but also can't connect.

error:

host 192.168.100.110 not allow to connect to this MySQL server.

 

pls help me. thanks!