ODBC Troubleshooting

ODBC connection not working? Check out some of these common (and some not-so-common) issues and resolutions!

Updated over a week ago

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

ERROR: cannot use serializable mode in a hot standby

  • Please ensure your ODBC driver is up-to-date and no later than version 12.02. Any newer version should be uninstalled and replaced with 12.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 v12.02 from this site.

Did this answer your question?