As a user, the following error occurs frequently when trying to connect to a PostgreSQL database via ODBC connection.
Specified driver could not be loaded due to system error 182: (PostgreSQL ODBC Driver(UNICODE), C:\Program Files\PostgreSQL\psqlODBC\bin\psqlodbc35w.dll)
However, once all connections are closed and only the PostgreSQL connection is restarted then the error no longer occurs.
WORKAROUND:
Set the PostgreSQL connection to auto connect upon startup of Toad so it connects first. In the connection properties, check the box "Connect on startup" and connect.
SOLUTION:
Reinstall the PostgreSQL ODBC driver to ensure all DLL files are present when the application calls for them.
