If latest psqlodbc driver (09.05.0300) is used, Visual FoxPro app does not return proper error message before logged in.
If there is no host name, user name or password is wrong, this driver
returns always same error message
Connectivity error: Unable to retrieve specific error information.
Driver is probably out of resources
Earlier versions of drivers returned correct error messages instead of this 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 logging in correct error messages are returned in all driver versions.
Visual FoxPro app uses message returned from odbc using AERROR() function.
Maybe Windows ODBC or VFP cannot retrieve error message and thus return
this.
Adrian wrote in psqlodbc mailing list that may be caused by change:
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.
Version immediately preceding the above psqlODBC 09.03.0400 returns correct messages.
How to get correct error messages with new driver versions ?
Posted also in
http://stackoverflow.com/questions/38212586/how-to-get-proper-error-message-before-logging-in-from-psqlodbc-driver
Andrus