ODBC Troubleshooting

Common ODBC Issues and how to Troubleshoot

Error	Possible Solution
Password authentication failed	You may simply have a typo in your password. Please ensure that if you are copying and pasting a password that you ensure you do not accidentally copy any whitespace or extra characters. You may need to request a password reset from the support team. Please be sure to include authorization from your Security Officer (if possible) when submitting this request.
Could not reach server	Ensure your agency has port 5432 allowlisted on their network firewall You may need your IP allowlisted, as the one you're connecting from might not be one of the approved ones we have on file.
Cross-database references not implemented	Contact support. You will most likely need to update your ODBC driver connection to include a new database name. Support can provide this information.
Login rejected	Contact support, there may be an issue on our end.
ERROR: cannot use serializable mode in a hot standby	Please ensure your ODBC driver is up-to-date and no later than version 13.02. Any newer version should be uninstalled and replaced with 13.02.
The specified DSN contains an architecture mismatch between the Driver and Application	The incorrect driver was most likely installed. Please ensure that you use the proper one, either 32 bit (x86) or 64 bit (x64). It is recommended that you uninstall any ODBC drivers you currently have and re-download v13.02 from this site.