(2014/11/05 1:23), 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
The driver seems to ignore the above entry.
Could you please try Servername instead of Server?
regards,
Hiroshi Inoue
> Database=todo
> Username=postgres
> Password=postgres13
--
I am using the free version of SPAMfighter.
SPAMfighter has removed 12883 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len
Do you have a slow PC? Try a Free scan
http://www.spamfighter.com/SLOW-PCfighter?cid=sigen