The Wiki page SWI-Prolog connecting to PostgreSQL via ODBC might be of help. While it is not specific to your setup it does take smaller steps in verifying things along the way. Also it uses /etc/odbc.ini as opposed to .odbc.ini.
HTH
EDIT
In trying to identify where in the source code the error is being thrown found
Now knowing the database is MySQL and the error number seems to be 1045 with a Google search found many pages like this