Troubleshooting
General Error
Connection string must not contain line breaks. The Connection string editor accepts them, but connecting using such a string may result in an error. Other misplaced whitespace characters could cause similar issues.
If used in an ODBC connection string, a login or password must not contain the following characters: [] {}() , ; ? * ! @. These characters are used to either initialize a connection or separate connection values.
Character encoding issues
There are two versions of the PostgreSQL ODBC driver. PostgreSQL Unicode is a Unicode enabled driver that works well in most cases. If your database runs in ANSI mode, it is recommended to use PostgreSQL ANSI driver instead.
22.09.2023 8:59:47