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

MS Access error "could not connect to remote socket"

From: "chor kim seng" <ksc133(at)singnet(dot)com(dot)sg>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: MS Access error "could not connect to remote socket"
Date: 2004-03-12 07:08:23
Message-ID: 000e01c40800$cf01cb40$6e64a8c0@win (view raw or flat)
Thread:
Lists: pgsql-odbc
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!

Responses

pgsql-odbc by date

Next:From: Gary DoadesDate: 2004-03-12 08:04:04
Subject: ODBC int2 Paremeters to PostgreSQL functions
Previous:From: Bob WoodsideDate: 2004-03-12 05:49:53
Subject: Re: Very Puzzled ---

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