lchan wrote:
> Hi Richard,
> Thank you for responding to my plea for help.
No problem - please try to keep the mailing list cc'ed - there are
smarter people than me on it.
>> 1. Make sure you are logging connection attempts in postgresql.conf
>> and see if anything is happening there.
>
> I have double checked the postgresql.conf file. There's only a trace
> file produced, and it's a SQLERROR -2 (SQL_INVALID_HANDLE).
This is the odbc logs - we also want to look at the postgresql logs.
Their location is usually defined in your postgresql startup script.
> Pasted
> below is my postgres.conf file. I would be very grateful if you let me
> know, if
> you spot anything that's incorrect.
Where is postgresql logging to? Find out, then add the following lines
to your postgresql.conf:
log_connections=true
log_statement=true
Restart postgresql and this will then log every connection and every SQL
statement you send.
Connect using "psql -h localhost -U myuser mydatabase", you should be
asked for your password and get a prompt. Check the logs to make sure
the successful connection is logged.
Then try to connect via odbc and see what the postgresql logs say.
--
Richard Huxton
Archonet Ltd