On 11/04/2014 08:23 AM, Malcolm MacLeod wrote:
>
>>> We have a client trying to connect to PostgreSQL server 9.2 from an osx
>>> client with our software via ODBC, he has asked for instructions to
>>> assist him setting up.
>>>
>>> I have attempted the setup myself using psqlODBC and no matter what I do
>>> configuration wise, the driver fails to connect (via iodbctestw and
>>> iodbc administrator) stating that the password is incorrect - I know
>>> this is not the case because I am using identical configuration to my
>>> linux machine where it works fine.
>> What is the exact error message you are getting?
>> Are you connecting from within the same network as your Linux machine?
>> Just trying to eliminate the possibility that it is a pg_hba.conf issue.
> All on same internal network.
> Server 10.0.0.3, working machine(s) 10.0.0.24, 10.0.0.25 etc. broken
> machine 10.0.0.26
> I've tried also setting the pg_hba.conf to 'trust' and even then it
> doesn't seem to work.
>
> Various config info and traces below.
>
>
>
> Snippet from configuration (Although I've played with various other
> options SSLmode etc. here as well)
>
> [test]
> Driver=psqlODBC
> Server=10.0.0.3
> Database=todo
> Username=postgres
> Password=postgres13
>
>
>
>
> iodbctestw error messsage:
> 1: SQLDriverConnectW = FATAL: password authentication failed for user
> "postgres" (210) SQLSTATE=28P01
Well it is not liking that password.
Are you sure you do not have conflicting configurations?
What file is the configuration you show above coming from?
What is in your odbc.ini file?
How are you running the test configuration?
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
