MS Access error "could not connect to remote socket"

MS Access error "could not connect to remote socket"

am 12.03.2004 08:08:23 von chor kim seng

This is a multi-part message in MIME format.

------=_NextPart_000_000B_01C40843.DCFD37F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

dear sir,

i'm trying to set up a win2k client to connect to postgreSQL running on red=
hat 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.=20
i've used the latest ODBC driver for postgreSQL
i use root account to connect MS Access to postgreSQL.
=20
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!


------=_NextPart_000_000B_01C40843.DCFD37F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








dear sir,

 

i'm trying to set up a win2k client to con=
nect to=20
postgreSQL running on redhat 7.2.

but every time i try to connect MS Access,=
the=20
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 w=
as=20
disable via lokkit.

i've created root as a postgreSQL=20
user.

i've aslo allow host ip win2k to=20
access postgreSQL. 

i've used the latest ODBC driver for=20
postgreSQL

i use root account to connect MS Acce=
ss to=20
postgreSQL.

 

win2k can ping and see redhat on the netwo=
rk=20
browser.

win2k can also access the shared samba=20
files.

 

i've tried to connect to MySQL but also ca=
n't=20
connect.

error:

host 192.168.100.110 not allow to connect =
to this=20
MySQL server.

 

pls help me. thanks!

 

 


------=_NextPart_000_000B_01C40843.DCFD37F0--

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

am 12.03.2004 09:55:05 von Richard Huxton

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
steps.

One thing to try is open up a command-prompt and type something like:
telnet 192.168.1.2:5432
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
problems.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org