Rick,
You would be better off sending this to the list, to
get the benefit of all of those great minds out
there...
Did you say that you are able to successfully run a
psql session against the second server? If so, where
from? Have you checked that the login credentials
were really the same as you supplied via ODBC?
You may find an answer in the pg_hba.conf file,
although I would have expected an explicit error
message if that had been the problem.
Replying to the list, in case anyone else has a clue.
--- Rick <rick@reac.nl> wrote:
> Hi Jeff,
>
> I am still struggling trying to connect to postgres.
> Attached are
> mylog trace files, one for a succesful connect
> (Server 1)and one where
> the connect fails (Server 2). TCP/IP Connections are
> fine to both
> machines.
>
> Any help would be appreciated,
>
> --
> Regards,
>
> Rick
> REAC BV
>
>
> --
> REAC BV
> Sevillaweg 62
> 3047 AL ROTTERDAM
> tel +31 10 4156419
> fax +31 10 2450623
> www.reac.nl
> info@reac.nl
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
> ATTACHMENT part 2 application/octet-stream
name=mylog_217.log; type=Unknown
> ATTACHMENT part 3 application/octet-stream
name=mylog_2.log; type=Unknown
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com