Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to run proper error messages with new psqlodbc driver
Message
De
05/07/2016 17:04:15
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
How to run proper error messages with new psqlodbc driver
Divers
Thread ID:
01637939
Message ID:
01637939
Vues:
45
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
Répondre
Fil
Voir

Click here to load this message in the networking platform