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.