All Manuals > LispWorks Release Notes and Installation Guide > 8 Configuration on Mac OS X > 8.7 The Common SQL interface > 8.7.3 Special considerations when using Common SQL

NextPrevUpTopContentsIndex Errors using PSQLODBC

The PSQLODBC driver, when it does not find any of the Servername, Database or Username in .odbc.ini , returns the wrong error code. This tells the calling function that the user cancelled the login dialog.

Therefore, if Common SQL reports that the user cancelled when trying to connect, you need to check that you have got Servername, Database and Username, with the correct case, in the section for the datasource in the .odbc.ini file.

Note: Username may alternatively be given in the connect string.

LispWorks Release Notes and Installation Guide - 23 Dec 2011