Re: How to get correct error message before logging to database

On 07/05/2016 07:50 AM, Andrus wrote:
> Hi!
>
>> What application is actually throwing the error?
>
> Visual FoxPro.
> It uses message returned from odbc using AERROR() function.
>
>> Is the above a direct quote or a translation?
>
> It is direct quote. Copied from windows messagebox using Ctrl+C
>
>> I ask because I do not find it in the 09.05.0300 source.
>
> Maybe Windows ODBC or VFP cannot retrieve error message and thus return
> this.

Likely given that VFP is past end-of-life.

>
>> Earlier versions of drivers returned correct error message.
>> Which version(s) exactly.
>
> 09.00.0101 and previous versions.

That is many versions past. The only thing I can think of at the moment is:

https://odbc.postgresql.org/docs/release.html

psqlODBC 09.05.0100 Release
Changes:

Use libpq for all communication with the server
Previously, libpq was only used for authentication. Using it for
all communication lets us remove a lot of duplicated code. libpq is now
required for building or using libpq.

You might try the version immediately preceding the above:

psqlODBC 09.03.0400

to see if you get the old behavior or new.

>
>> What message did they return?
>
> They returned messages like:
>
> FATAL: password authentication failed for user "xxx"
>
> fe_sendauth: no password supplied
>
> could not translate host name "xxxxx" to address: Unknown server error
>
>
> After logged in normal messages appear.
>
> Andrus.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com