Re: Unable to connect on W2K - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: Unable to connect on W2K
Date
Msg-id 20070221070455.GA14843@soptik.pzkagis.cz
Whole thread Raw
In response to Unable to connect on W2K  (Paul Lambert <paul.lambert@autoledgers.com.au>)
Responses Re: Unable to connect on W2K  (Paul Lambert <paul.lambert@autoledgers.com.au>)
List pgsql-odbc
> When I set up a System DSN and try to 'test' the connection, it returns
> "Could not connect to the server;
> No connection could be made because the target machine refused it.
> [172.17.152.207:5432]"
>
> My pg_hba.conf file looks like this:
> host    all    all      127.0.0.1/32          password
> host    all    all      172.0.0.0/8           password
>
> DSN info:
> DSN='AutoDRS',server='FOOTPRINTS',port='5432',dbase='AutoDRS',user='AutoDRS',passwd='xxxxx'

Hello

server='FOOTPRINTS' - are you sure you can reach you server with this
name? What do you get when you type 'nslookup FOOTPRINTS' in cmd.exe?
Could you try change the server to 127.0.0.1?

Does this work (?):
psql.exe -h FOOTPRINTS -p 5432 -U AutoDRS AutoDRS

Regards,

Luf

pgsql-odbc by date:

Previous
From: Paul Lambert
Date:
Subject: Unable to connect on W2K
Next
From: Paul Lambert
Date:
Subject: Re: Unable to connect on W2K